April 3, 2009 at 8:52 am
Hello,
I created a Report on my localhost by connecting it to the Database Server.
Then I deployed the report on my Localhost.
Now When I went to my localhost (http://localhost/ReportServer/) and then I opened the Report Project and then clicked on the report.
I got the following Error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'mus'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I checked under Directory Security for the ReportServer on IIS and Integrated Windows Authentication is checked but I still get the above Error.
Kindly Advice. Thanks.
April 6, 2009 at 7:24 am
Is your SSRS service and the SQL Server Database Engine (where Report Server DB resides) installed in different machines ? If so, I think you have not configured Kerberos. Check http://www.sqlservercentral.com/articles/Security/65169/
April 6, 2009 at 7:55 am
You mentioned that Windows Integrated is checked, is the Allow Anonymous unchecked? THis will override the windows auth if it is checked.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply