SSRS Sharepoint Integrated Mode
Hi All I have set up SSRS to work with sharepoint i have created a report and saved to a document libary, If i can view the report when logged in locally as Administrator. But all domain users trying to see the report get the following error An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors, Can anybody shed some light as to what it is i am doing wrong.
March 22nd, 2011 5:41pm

Hi Pepps1976, From the error message, we could see that it is a permission issue. You have the permission to open the report, but you have to make sure you could access to report's datasource. If I understand you correctly, your report’s datasouce is an external datasource. To access an external data source , you could store the credentials in the datasource. The credentials we provide retrieve the same data for every user who runs the report. The user name and password that you specify can be Windows credentials or a database login. For more detail steps about how to set Store Credentials for a Data Source, please see: http://technet.microsoft.com/en-us/library/ms159736.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 1:43am

The Execution Account is set to domain\administrator also if i am logged directly onto the sharepoint server which also has the sql server installed, as administrator i can view the report. Hope that helps
March 23rd, 2011 6:51pm

The selection that i have chosed for the Datasource in Report Builder Is Use a connection embedded in my report the credentials are set to use current windows user.
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 7:46pm

Hi, Try to deploy the datasource with SQL server authentication.
March 23rd, 2011 7:55pm

Then in this case, when an user access the report, the user should have access to the database. So, try adding NT AUTHORITY\NETWORK SERVICE rights to the database. Also check the Execution Account for the reporting service.
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 8:27pm

thanks for the reply could you just guide me as to where i make these changes i am quite new to this and do not want to mess anything up. Thank You
March 23rd, 2011 8:55pm

The Execution Account is set to domain\administrator Hope that helps
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 9:00pm

Hi pepps1976, Right-click the report ,and then select manage parameter, then specify stored credentials for a report-specific data source, Type a user name and password. If the account is a Windows domain user account, specify it in this format: <domain>\<account>, and then select Use as Windows credentials when connecting to the data source. If the user name and password are database credentials, do not select Use as Windows credentials when connecting to the data source. If the database server supports impersonation or delegation, you can select Impersonate the authenticated user after a connection has been made to the data source. If you have any question, please feel free to ask. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
March 30th, 2011 10:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics