I have a .NET web site which calls reports running on SQL Server 2008R2 which resides on the same server.  The reports have a default data source and default values for all parameters.  When calling these reports, I use a URL of 10.0.0.1 and pass values for the data source as well as the parameters.  I am trying to move the reporting services to a separate server.  I have installed SQL Server on this server and deployed the reports.  When I call the reports, I now specify the URL of the new server.  I am getting the error message "One or more data sources is missing credentials".  As far as I can tell, I am passing all the values to the new server that I sent to the old server.  Any suggestions as to what I should be looking at?

Thanks

Tim

Hi Tim,

Based on my understanding, after you move the Reporting services to another server, you come across an error One or more data sources is missing credentials when you call the report from the original server, right?

In your scenario, please check if you can run the report on the new server correctly. If not, please go to report manager, then check the connecting string and stored credentials on the Data Sources page of the report are right. If the database you connect to doesnt exist on the new server, you should specify the connection string like below:
data source=<servername>;initial catalog=<Databasename>

Regarding the stored credentials, you can specify the Windows credentials or database credentials to connect to the data source. You can check if the connection is successful with Test Connection button. Then you should run the report on report manager. After the report can run correctly on the new sever, you can call the report again on the original server to check if issue persists.

Reference:
Specify Credential and Connection Information for Report Data Sources

If you have any question, please feel free to ask.

Best regards,
Qiu

Qiuyun Yu,

Thank you for answering.  I'm sorry, I should have mentioned that I have used IE to run the reports locally on the new server, with the datasource on the old server.  I have set default values for the credentials in the report, but pass new ones when trying to call the report from my web site.  When I get the message about missing credentials, I'm not sure if I'm missing credentials to access the report or if the report is missing credentials to access the data.  As I said, this process works when the reports, database and web site are all on the same server.  I have looked at the link you posted, but don't see anything there that I haven't looked at.  Is it possible that I need to call the report differently from the web page when reports are not on the local server?

Thanks,

Tim

Hi,

Please check if the web site need the credential to access the report server. Then please specify the stored credential to access the database.