This Old Code

I receive an error when trying to install

“Security Update for SQL Server 2005 Service Pack 2(KB948109)

A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to restart your computer.

The windows installer error message that shows up in my event log is:

Product: Microsoft SQL Server 2005 - Update 'GDR 3068 for SQL Server Database Services 2005 ENU (KB948109)' could not be installed. Error code 1603.

The kb known issues do not seem to align with my error.

Known issues with this security update

•
If the Microsoft SQL Server 2005 installation or the SQL Server 2005 Express Edition installation is an upgrade from an earlier version of SQL Server, you should review the "Known issues with this security update" section in one of the following articles in the Microsoft Knowledge Base:

948110 (http://support.microsoft.com/kb/948110/) MS08-040: Description of the security update for SQL Server 2000 GDR and MSDE 2000: July 8, 2008

948111 (http://support.microsoft.com/kb/948111/) MS08-040: Description of the security update for SQL Server 2000 QFE and MSDE 2000: July 8, 2008

•
You may receive an error message when you try to uninstall this update. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base:

955250 (http://support.microsoft.com/kb/955250/) Error message when you try to uninstall a SQL Server 2005 Express Edition hotfix package: "1731 The source installation package for the product [2] is out of sync with the client package"

Down loaded the Update and did a manual install: Security Update for SQL Server 2005 Service Pack 2 (KB948109)

I also see an error from the MsiInstaller:

Product: Microsoft SQL Server 2005 -- Error 1920. Service 'SQLWriter' (SQLWriter) failed to start.  Verify that you have sufficient privileges to start system services.

Followed these instructions on all MSSQL.n\setups in the registry:

SQL server uses local group for ACLs. When the server is installed the groups are created and their SIDs are stored in the registry. Somewhere along the way, the SID had to change and the SIDs in the registry were not valid anymore. Try to delete the values for the following values in Setup registry key the instance hive [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup]

The registry values are:

AGTGroup

SQLGroup

FTSGroup

ASGroup

Thanks,
Samuel Lester (MSFT)

Followed these instructions to reinstall sqlwriter:

I had the same problem, and I found an easier way:

Browse your SQL 2005 installation CD, and in the setup folder you should see a file called SQLWriter.msi (It may be in a subfolder of the setup folder - I can't remember the exact location).

Execute the msi file - it will install the missing SQL 2005 VSS Writer service.

After that your SP2 installation should succeed.

Now I have successfully Installed the hotfix.