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