ms568
asked on
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?
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?
Even with a anonymous connection you need a SQL source. When you deploy a report you HAVE to deploy a data source as well.
ASKER
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)
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.