After upgrading SQL Server from 2005 to 2008 we were unable to publishing reports to CRM. The app log showed this error:
Error: An attempt has been made to use a data extension ‘MSCRM’ that is either not registered for this report server or is not supported in this edition of Reporting Services
Testing further we discovered existing reports failed to render with the error: MissingDataSourceCredentialsException: One or more data sources is missing credentials
This was similar to the issue with SP2 for SQL 2005 however, repairing the SRS Data Connector and reapplying rollup 10 for the connector failed to resolve the errors.
Finally we checked the CRM Data Source in the Organization folder on the Report Server and manually resolved the connection information:
- Open Reports Manager.
- Select the CRM Organization.
- Click Show Details.
- Click the v4 folder.
Click the CRM Data Source.
If you are not using the CRM Data Connector for SQL Reporting Service, the connection string will resemble the following:
Data Source=server;Initial Catalog=ORG_MSCRM;Integrated Security=SSPI
With Windows integrated authentication radio selected.
If you are using the CRM Data Connector for SQL Reporting Service and the Microsoft CRM Data Extension,
the connection string resembles the following:
MSCRM Data Connector Connection String
With Credentials Supplied by the user running the Report.