Home Dashboard Directory Help
Search

Windows Hotifx KB 2661254 Breaks Reporting Services in SQL 2008 R2 SP2 by Nicholas Cain


Status: 

Closed


9
0
Sign in
to vote
Type: Bug
ID: 774645
Opened: 12/18/2012 8:18:32 AM
Access Restriction: Public
2
Workaround(s)
view
2
User(s) can reproduce this bug

Description

When attempting to install a slipstreamed version of SQL Server 2008 R2 with Service Pack 2, or to apply Service Pack 2 to an existing installation of SQL Server 2008 R2 the Reporting Services service will fail to start if Windows hotfix KB 2661254 (Update for minimum key kength) has been applied.

Installing the hotfix on a system with SQL Server 2008 R2 SP2 causes the Reporting Services service to fail to start.

This impacts systems running Reporting Services only, there is no impact on other installations of SQL Server.

Logged under SQL Server 2008 R2 SP2 CTP as there is no option for SQL Server 2008 R2 SP2.
Details
Sign in to post a comment.
Posted by umone on 7/11/2013 at 7:25 AM
This issue occurs because of an inability to retrieve trusted and untrusted certificate trust lists (CTLs).
Posted by Vitаl on 4/1/2013 at 8:57 AM
I experience the same issue with SQL Server 2008 SP3 10.00.5512.
Posted by Microsoft on 1/22/2013 at 3:54 PM
Thank you for reporting this issue. We followed the same repro steps on a clean machine and we could not reproduce the issue. If you continue to see this problem, please open a case with Microsoft Support and they will help troubleshoot the issue. Thank you.
Sign in to post a workaround.
Posted by umone on 7/11/2013 at 7:24 AM
This issue occurs because of an inability to retrieve trusted and untrusted certificate trust lists (CTLs).


KB 2745448 provides a number of methods to workaround the issue.
I choose to implement method 4 and increased the timeout on the SSRS service startup to 90 seconds and I have resolved
Posted by Nicholas Cain on 12/18/2012 at 8:45 AM
Uninstall SQL Server 2008 R2 Service Pack2
or
Uninstall Windows hotfix KB 2661254