Update Warning: Security Update for SQL Server 2005 Service Pack 2 (KB948109) might break Reporting Services - TFS & Visual Studio ALM - by Neno Loje

TFS & Visual Studio ALM - by Neno Loje

(formerly Team System, VSTS)

News

Recent Posts

Community

Tags

Email Notifications

VSTS Blogs

VSTS Community

My Other Blogs

German VSTS Websites

Archives

Update Warning: Security Update for SQL Server 2005 Service Pack 2 (KB948109) might break Reporting Services

Name des Updates und Nummer:

  • Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    version 9.00.3068.00 released on 7/8/2008

Applies to:

  • SQL Server 2005 Service Pack 2 with Reporting Services installed

Symptoms & Result:

  • After installation the SQL Server 2005 Reporting Services service might not start. Therefore the Reporting Services cannot be used anymore.

Distribution:

  • The Update is distributed via Windows Update.

Workaround:

  • Uninstall the update (requires a restart).

My recommendation:
(for your internal SQL server you use for TFS)

  • Do not install the update and wait for the next service pack release.

Related Links:

Comments

admin said:

Did anyone give this guy the log files he's asking for?

He's closed the bug as non repro-able.

Saying wait until the next service pack is not acceptable.

# August 15, 2008 3:29 PM

neno said:

You find a workaround how to fix it on the connect site if you prefer.

I do not advise any hotfixes on production machines other than offical service packs.

N.

# August 15, 2008 3:48 PM

bradley said:

This isn't a hotfix, this is a security patch.

As MVPs can we better get to the bottom of this.

Each person needs to evaluate the risk factors of this security patch, but calling it merely a hotfix is not what this is.

# August 15, 2008 8:15 PM

neno said:

Although I went to the bottom of it, that actually doesn't matter to me. This update won't get installed since it creates a new problem.

With calling it a "hotfix" I wanted to refer to the level of testing which is not adequate for environments I support.

# August 16, 2008 4:35 AM

neno said:

Susan, I added the remark that my recommendation is "for your internal SQL server you use for TFS" and does not generally apply other situations.

N.

# August 16, 2008 4:51 AM