Tags

, ,


Problem

When trying to start SQL Server Reporting Services, an error message appear with the following text:

The request failed or the service did not respond in a timely 
fashion. Consult the event log or other applicable error logs 
for details

After checking the event log:

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

Solution

The Microsoft Windows Service Control Manager controls the state (i.e., started, stopped, paused, etc.) of all installed Windows services. By default, the Service Control Manager will wait 30,000 milliseconds (30 seconds) for a service to respond. However, certain configurations, technical restrictions, or performance issues may result in the service taking longer than 30 seconds to start and report ready to the Service Control Manager.

  1. Go to Start Run > and type regedit
  2. Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  3. With the control folder selected, right click in the pane on the right and select new DWORD Value
  4. Name the new DWORD: ServicesPipeTimeout
  5. Right-click ServicesPipeTimeout, and then click Modify
  6. Click Decimal, type ’180000′, and then click OK
  7. Restart the computer

or

Start->All Programs -> Microsoft Sql server 2005 -> Configuration Tools -> SQL Server Configuration Manager.
In the SQL SERVER configuration Manager Window, click the plus (+) sign against SQL SERVER 2005 Network Configuration.
Highlight ‘Protocols for MS SQL SERVER’
In the right pane you’d find VIA in protocol name column , you can right click it san select ‘Disable’

Advertisements