Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with BI Answers

Received Response
11
Views
3
Comments
Askyy
Askyy Rank 1 - Community Starter
edited Aug 13, 2024 6:18PM in Oracle Analytics Cloud and Server

Hey guys,

This is my first post on the forum. If the question is too noobish, sorry

I got a problem in BI Answers. I made an rpd with a connection to a SQL Server DB. I can view data directly on BI Administration Tool, but on analytics give me this error:

Error Code: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] General Error. [nQSError: 43113] Return message from OBIS. [nQSError: 16001] Error state ODBC: 28000 code: 18456 message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'.. [nQSError: 16001] Estado de erro do ODBC: 37000 código: 4060 mensagem: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "supplier2" requested by the login. The login failed.. (HY000)
I am using Windows Authentication btw.
If you want some prints, I can post them later.
Thanks.

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    What i saw in your message what it said basically is that you have a login issue, lets start with the basics:

    1. Test your ODBC connection to your Microsoft SQL Server., has a "Test Connection Succesful"

    2. Ensure your user and passsword are good.

    3. Check the "Database" Object in the Phyisical Layer of your RDP has set up with the SQL Server as Database Type.

    Kind Regards,

  • Jay Gandhi
    Jay Gandhi Rank 2 - Community Beginner

    Hi,

    Which version of OBIEE are you on ?

    Can you copy-paste the TNS entry details(of the MS SQL Server) from the BI server directory ?(not the database directory).

    Data is visible via admin tool is because it takes the ODBC route(which directly hits the database) but when it comes to Analytics, it goes via the TNS entry file. Hence, I would like to see the TNS entry details.

    Thanks,

    Jay

  • Jay Gandhi
    Jay Gandhi Rank 2 - Community Beginner

    Also, does your Ms SQL Server database have more than one instance setup ? I guess yes.

    If it is indeed yes, then make sure you explicitly mention the instance name in your TNS entry. i.e., <server_name>/<instance_name> or <server_name>\<instance_name>