If you are using Reporting Services and Integration Services and you noticed that the service couldn’t start after the installation of the MS12-070 security patch (http://support.microsoft.com/kb/2716429) you can use the following 2 workarounds below.
(the issue already appeared in the past and was solved by http://support.microsoft.com/kb/936707/en-us)
Why is this happening?
When a .NET application startup the .NET Framework it tries to check if the Microsoft assemblies are right and have not been modified, this is done connecting to a server that has a revocation list in internet. When the framework tries to connect to the server to check if it has access to internet with an elevated timeout, this makes that any other .NET application that has less timeout setting fails (as SSIS or SSRS) with the error message you are getting.
The error message you are getting when you try to start SSRS:
“The request failed or the service did not respond in a timely fashion.”
Means that the SSRS timeout is lower than the timeout of the connection to the revoke list server. Some recent windows updates have introduced this issue after you installed SP2 of SSRS 2008 R2. We are aware of this problem and we have already provided several workarounds.
This issue affects to all applications that runs on .NET framework 2.0 and there are several workarounds for this problem:
Modify the registry to increase the default time-out value for the service control manager. To increase this value to 60 seconds, follow these steps:
1. Click Start, click Run, type regedit,and then click OK.
2. Locate and then click the following registry subkey:
3. In the right pane, locate the ServicesPipeTimeout entry.
Note If the ServicesPipeTimeout entry does not exist, you must créate it. To do this, follow these steps:
- On the Edit menu, point to New, and then click DWORD Value.
- Type ServicesPipeTimeout, and then press ENTER.
- Right-click ServicesPipeTimeout, and then click Modify.
- Click Decimal, type 60000, and then click OK.
This value represents the time in milliseconds befor
Restart the computer for the changes to take effect.
Check that SSRS and SSIS services can be started now…
If the first action plan didn’t work, try disabled the certificate checking in the ReportingServicesService.exe.config file:
- Edit the ReportingServicesService.exe.config file usually located in this folder: C:\Program Files\Microsoft SQL Server\<RS Instance>\Reporting Services\ReportServer\bin
- Add the “<generatePublisherEvidence enabled=”false”/>” within the <Runtime> tag
- Patch the server with the KB.
If you want to distribute this workaround to many users you can créate a script in PowerShell
Another option would be disabling the global checking of the certificated in the machine following the steps below:
o Start -> Control panel
o Internet Options
o Uncheck “Check for publisher’s certificate revocation”
If the services are running under the Network Service account the change to the revocation in internet options is not working for them. In that case, you can perform the following changes for the SSRS service account:
Modify the following setting in the registry:
Where the default value for State key is 0x00023c00
And you will need to change it to 0x00023e00
(More information in: http://support.microsoft.com/kb/2715304)
In order to get the Windows SID for this user and be able to find out the previous registry key, please follow the below instructions.
- Download SPGETSID tool from http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx
- Once it is installed and save to a local file, open a cmd window (with administrator privileges ) and navigate through the cmd to the folder where this spgetsid.exe is located.
- Then type the following command line: spgetsid domain\user (where the domain\user is your SSRS service account)
- Once get the SID please go to the previous registry key for this user and apply the change.
S-1-5-20 is the SID for Network Service, and for other SIDs: http://support.microsoft.com/kb/243330
Name: Local System
Description: A service account that is used by the operating system.
Name: NT Authority
Description: Local Service
Name: NT Authority
Description: Network Service
Note: Check workarronds in http://support.microsoft.com/kb/2745448 too
Reporting Services Support Engineer