Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE SQL Server username error

majortomJan 19 2010 — edited May 4 2010

Hi Experts

Have installed OBIEE on my local machine.

Have set up a repository that has some SQL Server Data sources, and tried to access them through Answers. Within Answers I can see the tables I have set up in the presentation layer, but when I query them I get this error.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: 28000 code: 18456 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MTRUST\CMP-001258$'.. (HY000)

It seems that it is using my computer name CMP-001258 to connect to SQL server which won't work - I believe it needs to use my username.

How do I tell it to use my username instead of the computer name to connect?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2010

Added on Jan 19 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

2,611 views