POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

After upgrading SQL Server from 2005 to 2008 we were unable to publishing reports to CRM. The app log showed this error:

crm2011

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:

  1. Open Reports Manager.
  2. Select the CRM Organization.
  3. Click Show Details.
  4. Click the v4 folder.
  5. 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.

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.