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 12»»

SQL Server 2008 R2 SP2 and KB2551254 Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 9:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
Hello,

I'm in process of installing several servers with SQL Server 2008 R2 SP2. So far I've completed 5 of them and I'm finding a common issue. That Reporting Services fails to start after applying SQL Server 2008 R2 SP2. I've dug a little bit and have found one Connect post where Microsoft says they cannot reproduce it and several blogs indicating removing this KB resolves the issue.

My question is this, has anyone else ran into this issue and have differing opinions? The information I've dug up seems a bit inconclusive and nothing concrete. I have however uninstalled it from one server and confirmed it now starts successfully.
Post #1440879
Posted Wednesday, April 10, 2013 10:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 554, Visits: 1,620
This caught my attention as we are planning on installing SQL 2008 R2 SP2 next week.

Did you try changing the timeout setting as GrumpyDBA suggests here?
http://grumpydba.blogspot.com/2012/09/sql-2008-r2-reporting-services-wont.html
Post #1440940
Posted Wednesday, April 10, 2013 12:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
Thanks for this tip, I have 4 more servers to fix so I'll try this on one of them to see if it works. The odd thing is that Reporting Services did work after the initial installation of the RTM version. It was only after the service pack update they failed. I'll let you know how it goes.
Post #1440966
Posted Wednesday, April 10, 2013 12:42 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 5,867, Visits: 12,951
I am struggling to remember if it was after SP2 (I think it was) but i certainly hit the same problem where SSRS did not start and there were no error messages (not even a new log), and the registry change above fixed it for me.

I would try that before an uninstall of SP2.


---------------------------------------------------------------------

Post #1440980
Posted Wednesday, April 10, 2013 2:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
Yeah, an uninstall of SP2 definitely is the last resort (not even considered an option IMO) for me. My prior statement to uninstalling it was in reference to KB266124, not SP2.
Post #1441026
Posted Wednesday, April 10, 2013 3:05 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 5,867, Visits: 12,951
I'm confused, which KB did you uninstall, (neither number seems correct) and was it a post SP2 patch?

---------------------------------------------------------------------

Post #1441037
Posted Wednesday, April 10, 2013 3:15 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 5,867, Visits: 12,951
this looks like a good article concerning this problem

---------------------------------------------------------------------

Post #1441040
Posted Thursday, April 11, 2013 12:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
george sibbald (4/10/2013)
I'm confused, which KB did you uninstall, (neither number seems correct) and was it a post SP2 patch?
Oops, typo - http://support.microsoft.com/?kbid=2661254

That is the KB number I meant to reference.
Post #1441121
Posted Thursday, April 11, 2013 3:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:31 PM
Points: 5,867, Visits: 12,951
so, to confirm, you were also able to resolve this issue by removing a WINDOWS security patch? (2661254)

---------------------------------------------------------------------

Post #1441156
Posted Thursday, April 11, 2013 12:47 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 6:45 AM
Points: 104, Visits: 389
george sibbald (4/11/2013)
so, to confirm, you were also able to resolve this issue by removing a WINDOWS security patch? (2661254)


Yes, I removed that security patch and Reporting Services started up with no delay. Here is the original Connect post that lead me to that - http://connect.microsoft.com/SQLServer/feedback/details/774645/windows-hotifx-kb-2661254-breaks-reporting-services-in-sql-2008-r2-sp2.
Post #1441433
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse