I have SQL 2008 SP1 installed on a 2008 Server Ent SP2 32bit with 13GB RAM and 2 x Intel Xeon.
The SQL Server Reporting Services stops unexpectedly and most times it starts by itself via the Recovery tab on Service. First, second and third failure is 'Restart the Service'.
'The SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.'
'The SQL Server Reporting Services (MSSQLSERVER) service entered the running state.'
That is okay. But when it does not start, it causes issues.
'A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.'
'The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.'
The Event ID is Generic: 7000 as too is the Source: Service Control Manager.
I have binged it, but nothing on line helps me resolve the issue.
Does anyone have any ideas?