When I create a report using Report Builder I receive the following error when I click Run Report. Any help would be appreciated. (I do not have a data source named datasource1!!!?)
w3wp!webserver!c!07/10/2006-10:30:39:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'dataSource1'. > System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
dataSource1 is the default datasource for the model.
I am assuming you are trying to run IIS without authentication. Do you have to run it that way or can you turn it on? From everything I read (and opinions will differ here) it seems that RS really wants to have authentication. Without it, how will you control who can deploy a model to your server?
Once you have authentication fixed, you can setup an impersonated user to access the database. Letting 'NT AUTHORITY\ANONYMOUS LOGON' access your SQL Server is a really bad idea.
R
|||Anonymous Access is disabled in IIS on the Report Server. (Integrated Windows Authentication is checked). That is why I cannot figure out why the Anonymous Logon account is attemtping to access the database?|||My problem was related to the Report Builder Model's Data Source. I changed the authentication method to SQL Server authentication and voila! It worked.|||Has anyone gotten the Report Builder to work with Integrated Security (given this is Microsoft's preferred authentication method)?
No comments:
Post a Comment