I cannot start the "SQL Server Reporting Services (SCE)" service
-
Wednesday, October 29, 2008 6:28 PM
Attempts to run any of the Windows Computer Reports fail with an error:
Date: 10/29/2008 10:19:30 AM
Application: System Center Essentials
Application Version: 6.0.1251.0
Severity: Error
Message: Cannot initialize report.Microsoft.Reporting.WinForms.ReportServerException: The Report Server Windows service 'ReportServer$SCE' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)
at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
My attempts to start the "SQL Server Reporting Services (SCE)" service fail with an error:Could not start the SQL Server Reporting Service (SCE) service on Local Computer.
Error 1053: The service did not respond to the start or control request in a timely fashion.
The application log in the event viewer has hundreds of instances of Event ID 107:Event Type: Error
Event Source: Report Server (SCE)
Event Category: Management
Event ID: 107
Date: 10/29/2008
Time: 10:36:25 AM
User: N/A
Computer: DC
Description:
Report Server (SCE) cannot connect to the report server database. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Please help.
Answers
-
Monday, November 10, 2008 3:37 PM
Thanks for the link to the Reporting Services forum. I found the fix in this thread:
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3644545&SiteID=1
I had to create a registry key and reboot:
1.
Click Start, click Run, type regedit, and then click OK.
2.
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3.
In the right pane, locate the ServicesPipeTimeout entry.
Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:a.
On the Edit menu, point to New, and then click DWORD Value.
b.
Type ServicesPipeTimeout, and then press ENTER.
4.
Right-click ServicesPipeTimeout, and then click Modify.
5.
Click Decimal, type 60000, and then click OK.
This value represents the time in milliseconds before a service times out.6.
Restart the computer.
After the reboot, the service was running. Thanks for your help with this.
All Replies
-
Thursday, October 30, 2008 6:59 PM
I still need help with this.
-
Friday, October 31, 2008 9:00 AMModerator
Hi,
Is it a new installed SCE server? Did you finish the Reporting Services Configuration? Did you use a remote SQL server? Is the "SQL Server" service running properly?
Please check the properties of "SQL Server Reporting Services (SCE)" service. Is it log on as "Local System account" or a domain user account? If you use "Local System account", make sure the "Allow service to interact with desktop" check box was selected. If you use other account, make sure the password is correct and it is authorized to access the database.
For more information, please read the KB nelow:
You receive an "Error 1053: The service did not respond to the start or control request in a timely fashion" error message when a service that uses the local system account tries to start on a Windows Server 2003-based computer
http://support.microsoft.com/kb/886695/
Hope it helps. -
Friday, October 31, 2008 5:56 PM
This SCE server has been up for about a month. It is in a lab environment for testing purposes. The install disc came from our MSDN subscription.
I do not know if I finished Reporting Services Configuration. How do I tell?
The SQL Server instance is local. It is SQL Server Express Edition.
The "SQL Server (SCE)" service is running.
The "SQL Server Reporting Services (SCE)" service logs on as Local System account. The checkbox for "Allow service to interact with desktop" was not checked. I checked this box but it did not fix the problem (I even tried rebooting the server).
I tried to install KB886695 but the only download available is for IA64 machines (mine is x86).
-
Monday, November 03, 2008 10:54 AMModerator
Hi,
You can verify the SQL reporting service as following step:
1. Go to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools. Open “Reporting Service Configuration”, make sure the flags are shown as green.
2. Click “Start” – “Run” – “Services.msc”, scroll to Report Server (MSSQLSERVER). The status should be Started.
3. Type “http://<computer name>/ReportServer<instance name>” in the address bar to verify the report server installation.
The following article contains more detail information for your reference;
How to: Verify a Reporting Services Installation
http://technet.microsoft.com/en-us/library/ms143773.aspxHope it helps.
-
Tuesday, November 04, 2008 6:42 PM
Okay I opened the "Reporting Service Configuration" as described in step one. I have a red X for "Server Status":
The service status is stopped. If I try to start the service, I get the same error I've had previously --
System.InvalidOperationException: Cannot start service ReportServer on computer '<COMPUTERNAME>'. ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion
--- End of inner exception stack trace ---
at System.ServiceProcess.ServiceController.Start(String[] args)
at System.ServiceProcess.ServiceController.Start()
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)Why can't I start this service?
-
Thursday, November 06, 2008 10:16 AMModerator
Hi,
There is a similar issue that caused by KB948109:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3840037&SiteID=17
If you just installed this KB, uninstall it to see if this is your scenario.
If this cannot help you, please use the following Forum for further research, which would be the best resource for your question.
SQL Server Reporting Services
https://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
Thanks, -
Monday, November 10, 2008 3:37 PM
Thanks for the link to the Reporting Services forum. I found the fix in this thread:
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3644545&SiteID=1
I had to create a registry key and reboot:
1.
Click Start, click Run, type regedit, and then click OK.
2.
Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3.
In the right pane, locate the ServicesPipeTimeout entry.
Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:a.
On the Edit menu, point to New, and then click DWORD Value.
b.
Type ServicesPipeTimeout, and then press ENTER.
4.
Right-click ServicesPipeTimeout, and then click Modify.
5.
Click Decimal, type 60000, and then click OK.
This value represents the time in milliseconds before a service times out.6.
Restart the computer.
After the reboot, the service was running. Thanks for your help with this.
.png){kind=spacer}
