Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with Reporting Services after MS08-68 & 69 patch Expand / Collapse
Author
Message
Posted Monday, November 17, 2008 3:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 15, 2011 11:04 PM
Points: 95, Visits: 100
Hi everyone.

Since this is my first post here, i hope you guys can bare with me if its not placed in the correct thread (though i hope it is).

Ok, to the issue...

After patching the operating system Windows 2003 R2 SP2 with Ms Patches MS08-68 and MS08-69 the Reporting Services service wont start. The version im using is 9.00.3073.

In the Event log i see that it appears the Reporting Services service times out.
Generating the Event 7000 and 7009. Does anyone know how to get this service started? Or does anyone else have this problem after patching?

I will try to solve this, and get back to you all with a solotion if i find one, but please let me know if you have similar problems or a solution.

Thanks in advance.
Tomas M.
Post #603526
Posted Monday, November 17, 2008 4:20 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:01 AM
Points: 4,055, Visits: 3,578
Under which account are you running Report Services? Is it a local account or a domain account?

Markus Bohse
Post #603554
Posted Monday, November 17, 2008 4:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 15, 2011 11:04 PM
Points: 95, Visits: 100
Hi all. This was resolved, and im gonna try to explain how below.

The problem obviously had something to do with time, since the service didnt have time to complete. I tried to do the ServicesPipeTimeout(*1) registry hack and extend the timeout from 30s to 60s. This worked and the service did start. However i wanted to know what caused it to take such a long time.

The problem was that the service was trying to connect to the internet and check for certificates. Since this particular server dont have access to the internet, it resulted in a timeout. So where can i turn these checks off? After consulting some collegues, the answer laid in Internet Explorer..

Tools -> Internet Options -> Advanced -> Security :
[x] Check for publisher’s certificate revocation
[x] Check for server certificate revocation

Unchecking these options will prevent the timeout since the service wont check the certificates and therefore complete in time (below 30s).

HOPEFULLY this will help others with timeout issues. Time for another cup of coffee.

*1
The registry hack:
----------------------------------------------------------
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 server.
Post #603562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse