An error like this when viewing an SSRS report...
The report server cannot process the report or shared dataset. The shared data source 'YOURNAMEHERE' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)
...may occur when specifying "Credentials stored securely in the report server" as the "Connect using" option at a datasource, and even so when one gets "Connection created successfully" upon clicking the "Test Connection" button. How is this possible? If you navigate to the Security tab for the data source you will likely see that the user you specified is just not there in the list of permissioned users. Click "New Role Assignment" to add the user. Give the user the "Browser" role.
No comments:
Post a Comment