Thursday, January 31, 2013

CRM Reporting Extensions Installation Error - Microsoft.CRM.Setup.SRSdataconnector.restart Services action failed. Cannot start service report server on computer

While installing Microsoft Dynamics CRM 2011 Reporting Extensions to the SQL 2008 R2 server in my lab, I kept getting the following error snippet... "Microsoft.CRM.Setup.SRSdataconnector.restart Reporting Services action failed. Cannot start service report server on computer'".  During the installation of CRM reporting extensions, the SQL Server Reporting Services service stops, and on restart fails.  I tried this in service manager manually (start... same error), and even after rebooting the error was present when manually attempting to start the SQL Server Reporting service.  It appears that this occurs because the service manager doesn't wait around long enough for the service to start.  There are some good resources on how to do this already, including Microsoft KB article 2745448 (method 4)... but in short, use regedit and navigate to the key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control, right-click Control and create a new DWORD named ServicesPipeTimeout, then modify it such that the decimal value is 60000 (1 minute wait).  Then restart the service.

No comments: