15 Replies Latest reply: May 19, 2011 12:55 PM by Sumanth Rai RSS

10901 - {Microsoft}{ODBC SQL Server Driver}{SQL Server} Login failed

Doron Shai
Currently Being Moderated

Hi all,

 

I hope that you will be able to assist me with an error that have on a WEBI report that I created.

 

The WEBI report is based on an SQLServer universe (using ODBC connection), and it is working just fine in the Web Intelligence Rich client. (preview is possible and I see all the DB data correctly).

 

When I am trying to run it in a dashboard (via the Infoview) I get the following exception:

 

"a database error occurred. The database error text is: {ODBC SQL Server Driver}{SQL Server} Login failed for user 'XXXXX\ZZZZZZ'... WS10901"

 

I have no idea what is the issue, since the reports runs just fine in the Rich Editor.

 

Can you please assist?

 

Thanks

Actions