The mscrm server SQL Server Reporting Services (MSSQLServer) service cannot be started automatically.

Description:

The SQL Server Reporting Services (MSSQLServer) service is set to the automatic start type, but the service cannot be started automatically after each machine is restarted, causing Manual start of the service each time.

I found the following error logs in computer logs:

Event Type: Error
Event Source: Service Control Manager
Event Type: None
Event ID: 7000
Date: 2009-5-20
Event: 18:34:57
User: N/
COMPUTER: crmdb
Description:
The SQL Server Reporting Services (MSSQLServer) Service failed to start due to the following error:
The service does not respond to the start or control request in a timely manner.

For more information, see Help and Support Center in http://go.microsoft.com/fwlink/events.asp.

 

==============================

Event Type: Error
Event Source: Service Control Manager
Event Type: None
Event ID: 7009
Date: 2009-5-20
Event: 18:34:57
User: N/
COMPUTER: crmdb
Description:
Wait for the connection timeout (30000 ms) of the SQL Server Reporting Services (MSSQLServer) service ).

For more information, see Help and Support Center in http://go.microsoft.com/fwlink/events.asp.

 

Solution:

Open the Registry on the server where the CRM database is located and find the HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control item.

Create a value of the DWORD type named servicespipetimeout in this item, enter a value of 60000 (larger), and restart the computer to try.