Reporting Service can't start - Event ID 107

Today, one of my clients reported that, the reporting service cannot started.
They didn't change anything and database service is running fine.

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 12/10/2009
Time: 11:53:21 PM
User: N/A
Computer: ABC
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 7/27/2008
Time: 7:26:24 PM
User: N/A
Computer: PRODB
Description:
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.

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

The Reporting Services logs mostly just repeat that "The Report Server Windows service 'ReportServer' is not running." ...


This issue was caused by a windows hotfix - KB948109, it changed Windows Internal Database (WYukon) security settings that could make the service start timeout.

There are 2 ways can make it resolved.

        Solution A: Use Add/Remove to uninstall this hotfix KB948109.

        Solution B: Change the registry to increase the timeout value.

        We suggest Solution B.

 

To increase the timeout value in the registry, follow these steps:

  1. Start Registry Editor (Regedit.exe).
  2. To change the value data for the ServicesPipeTimeout DWORD value to 60000 in the Control key, follow these steps:
    1. Locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet

    1. Click the Control subkey
    2. Right-click the ServicesPipeTimeout DWORD value, and then click Modify.
    3. Click Decimal.
    4. Type 60000, and then click OK.
  1. If the ServicesPipeTimeout value is not available, add the new DWORD value, and then set its value data to 60000 in the Control key. To do so, follow these steps:
    1. Locate and then click the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet

    1. Click the Control subkey.
    2. On the Edit menu, point to New, and then click DWORD Value.
    3. Type ServicesPipeTimeout, and then press ENTER.
    4. Right-click the ServicesPipeTimeout DWORD value, and then click Modify.
    5. Click Decimal.
    6. Type a value of 60000, and then click OK.

      The value is 60000 milliseconds and is equivalent to 60 seconds or to one minute.

Note This change does not take effect until the computer is restarted

4 Comments

Hi
Are you interested in building af new HMC 4.5 environment for our company?

Looking for a job?

hi
i want to know where do u live
we are building new HMC 4.5 for ISP

email me plz
person_hk@hotmail.com

Hi Hussein,
I am living in Shenzhen city, Guangdong province, China

Cheers,
Randy

Leave a comment

Recent Entries

  • How to remove a VMHost from SCVMM 2008 R2 forcefully

    这几天碰到个问题,有个服务器原来安装的是 2008 Server Core系统,上面跑 Hyper-V,已经将其导入 SCVMM 2008 R2 来管理。最近实在是嫌 Server Core 管理太不方便,于是想把系统换成带图形界面的,也没在 SCVMM 里面把主机删除,直接就重装了,IP和计算机名什么的都没变,结果问题来了,再打开 SCVMM 的控制台,发现这台主机联系不上(当然,因为重装的没有了 Agent),就想删掉再重加,结果删除过程报错:Error (801) VMM cannot find ISO object . Recommended...

  • Outlook Mobile Update

    现在你可通过新的Microsoft Office Outlook Mobile更新程序和 Microsoft Exchange Server 2010 来保证你手上的信息是最有价值的。 这次的 Outlook Mobile 更新仅针对 Windows Mobile 6.1 的手机。 当你的手机连接到 Exchange Server 2010 时,如果有适合的更新你会收到自动的提示。 如果你的手机的系统是 Windows Mobile...

  • 哥们,我的更新汇总在哪呢?

    我刚刚在我全新的 Exchange 2010 服务器上安装了更新汇总1 - RU1, 然后运行 Get-Exchangeserver -Identity MyExchangeServer (译者: 可以用 Get-Exchangeserver -Identity MyExchangeServer | fl ExchangeVersion, AdminDisplayVersion)得到以下关于AdminsDisplayVersion 和 ExchangeVersion 的版本信息: 嗯, 这看上去有点眼熟(译者:...

  • Exchange 2010 Update Rollup 2

    Today Microsoft released Update Rollup 2 for Microsoft Exchange Server 2010. RU2 comes 3 months after the release of RU1. The list of included fixes...

  • HMC 4.0 Update Rollup 3 has been updated

    Description of Update Rollup 3 for Hosted Messaging and Collaboration 4.0http://support.microsoft.com/kb/979702/en-usMicrosoft released an update rollup that is dated December 2009. This update fixes issues that...

Close