Tuesday, October 4, 2011

A Microsoft Dynamics CRM Server component is using the same account as the instance of SQL Server Reporting Services.

I got this error while upgrading CRM 4.0 to CRM 2011.

After uninstalling the CRM 4.0 data connector, the 2011 SRS data connector setup stopped at this error in the last System Checks screen


Also the following error was logged in the setup log file (find it in %APPDATA%\Microsoft\MSCRM\Logs)

08:55:45|  Error| Check ReportingAccountMemberOfSecurityGroupValidator : Failure: A Microsoft Dynamics CRM Server component is using the same account as the instance of SQL Server Reporting Services.


It was fixed by removing the Reporting Services service account from the AD security group SQLAccessGroup in the CRM OU.

8 comments: