July 25, 2008 at 8:12 am
I have two instances of SQL Server 2005 version 9.00.3042 and 9.00.3054 on a windows 2003 Enterprise Edition server service pack 1.
I installed the Cumulative hot fix 3068 (MS08-040-KB948109) and it ran for both instances of SQL Server without error. Now both instances are version 9.00.3068. The problem that I am getting is with my reporting services on both instances. When I try to restart SQL Server Reporting Services I get the following error “Could Not start SQL Server Reporting Services (TWO) service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion”.
During the install, I noticed the following warning:
Warning
Event ID: 63
A provider, ReportingServicesWMI, has been registered in the WMI namespace, root\Microsoft\SqlServer\ReportServer\v9\Admin, to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.
And then I got the following errors for Instance TWO because Instance ONE has reporting services, but it is not configured.
Error
Event ID: 107
Report Server (TWO) cannot connect to the report server database.
Error
Event ID: 1101
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
Has anyone had the same problem?
July 25, 2008 at 11:22 am
OK... I guess I was the only one having this problem, but incase anyone else runs into this there are 2 ways out.
1- Uninstall the hotfix
2- Add a registry key. (http://support.microsoft.com/?kbid=884495)
A) Click Start, click Run, type regedit, and then click OK.
B) Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
C) Right-click Control, point to New, and then click DWORD Value.
D) In the New Value #1 box, type ServicesPipeTimeout, and then press ENTER.
E) Right-click ServicesPipeTimeout, and then click Modify.
F) Click Decimal, type the number of milliseconds that you want to wait until the service times out, and then click OK. I used 60000 for 60 seconds.
July 28, 2008 at 2:07 pm
Thanks for the info.
December 26, 2008 at 8:37 am
Your post is right on the money with the problem I am having but I do not racall installing the Cumulative hot fix and I cannot find it in the Add and Remove Programs. Can you offer any suggustions?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply