Share

Microsoft Dynamics CRM 2011 Reporting Extension (SRS Data Connector) Installation Service Account Warning

The Microsoft Dynamics CRM 2011 Reporting Extensions, previously known as the SRS Data Connector, will sometimes return an error message during installation that is intended to be a warning, not an error. The message that you see is ‘A Microsoft Dynamics CRM Server component is using the same account as the instance of SQL Server Reporting Services.’

image

There are several conditions which will provoke this message

· A Microsoft Dynamics CRM Server 2011 component is installed on the computer where Microsoft Dynamics CRM Connector for SQL Server Reporting Services Setup is being run.

· The SQL Server Reporting Services account is a member of the Active Directory SQLAccessGroup security group. This can occur when the Reporting Services is running under the same account as another Microsoft Dynamics CRM component.

· All Microsoft Dynamics CRM Server 2011 components, SQL Server, and Reporting Services are installed on a computer that is running Microsoft Windows Server Small Business Edition where Microsoft Dynamics CRM Connector for SQL Server Reporting Services Setup is being run.

· The SQL Server Reporting Services account is set as "Local Service."

To get around this error, follow the steps below. Once this is completed, you will still see the error message however the ‘Next’ button will be available and you can continue with the installation. This does require a registry setting change, so it is recommended that the registry be backed up PRIOR to making any changes. One thing to note before using this, if you change this key on your CRM server, any checks that are supposed to take place during the CRM installation will also be ignored. This should only be used with great care and turned off after the Reporting Extensions installation is completed. Failure to do so may result in checks being ignored during other installations and could have negative consequences.

1. Close the installer window

2. Find the MSCRM key in the HKLMSOFTWAREMICROSOFT directory

3. If the MSCRM key does not exist, create it in the HKLMSOFTWAREMICROSOFT directory

4. Once you have the key, create a new DWORD value named IgnoreChecks and set the value to 1

5. Launch the installer and follow its instructions. When you get to the environment checks the ‘Next’ button will be available.

Free Guide
On-Premises vs. Cloud CRM

A guide to help you determine the best solutions for you.