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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy