September 30, 2009 at 3:48 pm
I am receiving the following error when I try to run a deployed report. "An error has occurred during report processing.
Cannot create a connection to data source 'DataSourceName'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
Let me start off by saying I had this working for a long time, but I screwed up the IIS on the server, had to uninstall and reinstall IIS and now the reports won't run when requested. If I am on the server where SSRS is installed, everything works fine. It's not until I try to run them from another workstation, that I run into the problem.
I'm pretty certain it's something simple, but I've been working on this for a couple of days now and the frustration level is reaching new heights!!!
Any help would be greatly appreciated!
September 30, 2009 at 5:01 pm
I am receiving the following error when I try to run a deployed report. "An error has occurred during report processing.
Cannot create a connection to data source 'DataSourceName'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
SSRS 2005 is Asp.net dependent the above error means Asp.net runtime using Network service account does not have permissions to the datasource database. If your datasource database is in a different server you need to add the Network service account where IIS6 is running to the SQL Server and the database.
Kind regards,
Gift Peddie
October 1, 2009 at 12:30 pm
I have NT Authority\Network Service as an authorized user for the server that houses the database as well as the SQL Server global security and Database security itself. I'm thinking that since I had to re-install IIS, that there is a setting that I'm missing in IIS. And I know absolutely nothing about IIS!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply