SharePoint Report Error: Cannot create a connection to data source ‘dataSource1’.
Problem:
You recieve the following error when running a report from report builder.
Report Execution error the report might not be vaild or the server could not process the data.
for more information about this error navigate to the report server on the local server machine, or enable remote errors
—-
Cannot create a connection to data source ‘dataSource1’.
—
An error has occurred during report processing.
Resolution
In my case the problem was the login that was used when running the report did not have access to the catalog and the sql server. I granted the correct access to the databases in sql manager and the user was able to run the report.
Tags: SharePoint, SQL, SQL 2008
2011/10/24 at 14:25:42
Great article. You should add that the report user id needs access to the Master catalog of the reported database.