Cannot create a connection to data source 'dataSource1'.

Hello,

We are using SQL Server 2005 Report Services, Report Builder, and we've created a Report model and  deployed it to the server. When i run the a report builder on the network it runs fine. When I run the report from anywhere else,  I get the error below, when I press 'run report'.

*******************************************************************

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.

*******************************************************************

 I don't have a datasource called 'dataSource1'. We are allowing anonymous users to the report builder, and the system automatically prompts the user for a usernm/pwd for authentication. I'm not sure what we might have setup wrong here.  Has anyone seen this error before?
ms568Asked:
Who is Participating?
 
ms568Author Commented:
The XML source did not have a reference to dataSource1.

What ended up being the problem was that in Report Manager, my user account did not rights to run a report. Two steps were necessary 1) create a system role with 'Execute Report Definitions' task rights. 2) Grant my app user rights to this system role.

To add this system role, from the Report Manger go to 'Site Settings', then 'Configure system-level role definitions'. Select Add New and check task 'Execute Report Definitions', and save.

To add the user to this system role, go to 'Site Settings', and 'Configure site-wide security'. Here add the app user and grant them permission to the system role created above.

This fixed my problem of not being able to run the report.
0
 
Ted BouskillSenior Software DeveloperCommented:
Even with a anonymous connection you need a SQL source.  When you deploy a report you HAVE to deploy a data source as well.
0
 
ms568Author Commented:
Ah I think I didnt describe that clearly. I do have a data source defined and it is linked to the report model, but the name is not 'dataSource1'. The data source does use is an impersonated windows account to access the database (since we have our database setup to allow only windows accounts to connect)
0
 
Ted BouskillSenior Software DeveloperCommented:
Hmm, I would use Notepad to look at the XML source for the report.  Search it and make sure that there isn't a reference to dataSource1.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.