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?