Solved

Why does the SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly?

Posted on 2011-02-21
6
5,205 Views
Last Modified: 2012-08-13
Hi,

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?

Thanks,
0
Comment
Question by:ErgoTeam
  • 2
  • 2
6 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 34948803
>> I have SQL 2008 SP1 installed on a 2008 Server Ent SP2 32bit with 13GB RAM

Apply SP2 for SQL Server 2008 from here:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17

Are you sure you have 32 bit OS and 32 bit SQL Server..
If so, have you configured AWE so that SQL Server can utilize more than 4 GB RAM else it would not..

>> 'A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect

Is there by any chance your SSRS service is trying to access remote SQL Server Database and if so then make sure that Firewall or any network connections are not causing any issues.
Also check for any errors in log files here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
0
 
LVL 18

Expert Comment

by:chrismc
ID: 34948813
It sounds like another service it relies on isn't ready when it's starting up.

My knowledge of SQL 2008 is limited at the moment but 2005 required IIS and SQL Server itself to be running. It may be that you may need to delay the startup of the Reporting Services service, this is an option in the services app.

There are also a series of log files under the ReportingServices folder that may give more information as to why it's failing.

0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 35178327
mlmcc,

I would recommend split between

http:#a34948803 and http:#a34948813
0
 
LVL 18

Expert Comment

by:chrismc
ID: 35181961
Fine by me.
0
 

Author Closing Comment

by:ErgoTeam
ID: 35188323
I am not able to install SP2 untill the dev team test it out, but I'd say that it will do the job. So untill I am allowed to installed SP2 I will close the question.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now