Cannot create a connection to data source 'mydatasourcename'.

No matter how many times I redeploy my report and data sources from my project to Report Manager, I keep getting this error when trying to run the report from Reprt manager. It runs fine in VS 2005 though. I don't know what else to do. I see no way to delete the report from Report Manager in attempts to try to redeploy it from scratch either.

An error has occurred during report processing.

Cannot create a connection to data source 'myservername'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Report manager has an icon in the toolbar to toggle between list view (default view) and detail view. In the detail view, you can select a report and delete it.

One reason why the connection could fail is that you are using Windows Integrated Security, but Kerberos is not set up for delegation.

-- Robert

|||I'm having the same problem. But how do I fix it without deleting my reports?|||

If your report server and the database used to get report data are not on the same machine,

1. Enable Kerberos protocol so that credentials can be delegated to other computers without limit.

2. If enabling Kerberos is not an option, consider using either stored credentials or a combination of Windows Authentication and database authentication. For example, you can use Windows Authentication to connect a client to a report server, and then configure the report to use database authentication to access an external data source. For this use a specific username and password in the credentials tab of data source designer. The report server will use the specific credential to access the database server.

Another option is to locate the report data sources on the same computer that hosts the report server.