May 11, 2010 at 7:42 am
I am using SQL Server 2005 and Visual Studio 2005. I created a report and Deployed it to the Report Server. When I run the report on the Report Server everything is o.k. When the user attempts to run the report, after he/she enters the parameters for the report, he/she receives the following: "An error has occurred during report processing. Cannot create a connection to data source 'DataSourceName'. For more information about this error navigate to the report server on the local server machine, or enable remote errors.
I have checked the database's (Datasources) security via SQL Server Management Studio 2005, the account " “first.last" has "db_datareader" and "db_datawriter" permissions for the database being used.
I checked the Report Manager in IE and went to Datasources to check the connection setting. I double clicked on the Datasource's name. In the "General" information; "Enable this data source" is checked, the connection type is "Microsoft SQL Server", the connection string is correct, and "Windows integrated security" is selected. In the "Security" information the user "DOMAINAME/first.last" is there with the roles of "Browser" and "Report Viewer".
I then went to the folder the report was in and checked the security. "DOMAINNAME/first.last" is there with the roles of "Browser" and "Report Viewer".
I then opened the report and checked Properties > Security. "DOMAINNAME/first.last" was there with "Browser" and "Report Viewer" roles.
What should I be doing differently? What other settings should be checked?
May 13, 2010 at 9:06 am
I found the issue. In the Data Sources properties, I had to change it from "Windows Integrated Security" to "Credentials stored securely in the report server", and "Use as Windows credentials when connecting to the data source".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply