Cannot create a connection to data source 'DataSource1'

  • I get an error that says Cannot create a connection to data source 'DataSource1'. I'm not sure what the problem is. I can Preview the report using 2005 but when I deploy and go to the Report Manager site and try to open the report I get this error. I have tried using Windows Authentication and SQL Server Authentication and neither work. Also when I click on the Data Sources folder in Report Manager it says 'There are no items in Data Sources. Click Help for more information about this page.'. Not sure why the Data Source isn't listed in that folder. There is no place to add a Data Source or anything in Report Manager. What am I missing here?

  • The data sources must also be deployed to the report server.

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]
  • the data source may not nessesarily be in the data source folder. when you set the target url for the report solution deployment you can also set the folder for the data source. If it does say to deploy to the data source folder then yes as Burninator said, you will need to deploy that data source to your report server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply