SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2008 R2 SP2 and KB2551254


SQL Server 2008 R2 SP2 and KB2551254

Author
Message
tafountain
tafountain
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 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.
dan-572483
dan-572483
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1326 Visits: 1997
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
tafountain
tafountain
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 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.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10294 Visits: 13687
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.

---------------------------------------------------------------------
tafountain
tafountain
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 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.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10294 Visits: 13687
I'm confused, which KB did you uninstall, (neither number seems correct) and was it a post SP2 patch?

---------------------------------------------------------------------
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10294 Visits: 13687
this looks like a good article concerning this problem

---------------------------------------------------------------------
tafountain
tafountain
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 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.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10294 Visits: 13687
so, to confirm, you were also able to resolve this issue by removing a WINDOWS security patch? (2661254)

---------------------------------------------------------------------
tafountain
tafountain
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search