On a Windows XP Professional with ACT by Sage 2009. Windows Automatic Update was not able to install the Security Update for SQL Server 2005 Service Pack 2 (KB948109). It would fail each time. Manual update also failed.
Details of the problem and a solution are offered at this SQL Server FAQ page. I found that information helpful, but it was not a complete solution for my situation. These are the steps that I used to solve my problem:
- Stop the SQL Server (ACT7) Service by going to Administrative Tools > Services, click on "SQL Server (ACT7)" and then click "stop".
- Open a "command prompt" by clicking Start > Run and typing "cmd" in the "open" box and press ENTER.
- Check to make sure the prompt is using the letter of the drive or partition which contains the program files - usually "C:" - if not, you can change to the correct drive by typing cd c: and press ENTER.
- At the prompt, type cd c:\program files\microsoft sql server\MSSQL.1\Binn press ENTER.
- Type Sqlservr.exe -s ACT7 -m -c to start SQL - press ENTER.
- Open a second command prompt - see step 2 above.
- In the new command prompt, type sqlcmd -S mypc\ACT7 -E where "mypc" is the name of the computer (found by "right" clicking on My Computer and going to Properties) - press ENTER.
- Type create login [mypc\richie] from Windows where mypc\richie is the name of the computer followed by your user login name - press ENTER.
- Type go and press ENTER.
- Type Sp_addsrvrolemember 'mypc\richie','sysadmin' substituting mypc\richie as in step 8 and press ENTER.
- Type go and press ENTER.
- Type exit and press ENTER.
- Return to the first command prompt - press and hold the Control key and press the "c" key.
- Then surf to the Windows Hot Fix at http://www.microsoft.com/downloads/details.aspx?FamilyID=4c9851cc-2c4c-4190-872c-84993a7623b7&DisplayLang=en and select and RUN the download for your computer. Generally, for Windows XP/Vista 32bit system, you need to choose SQLServer2005-KB948109-x86-ENU.exe to install.
- Now you should be able to clear the Windows "update" icon on the task bar and complete the update.
- Last thing you need to do is START the service that you stopped in Step 1.