During the last weeks Vista always claimed that there’s an update to install, but it never succeeded installing it. So this afternoon I dug into it.
The update in question was the Security Update for SQL Server 2005 Service Pack 2 (KB948109). It failed with error 11032. When looking at the log file in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB948109_sqlrun_sql.msp_13.log I saw another error: 1603. A search on the internet showed that a lot of people had similar errors with various patches, but nothing really helped. I also tried to install a hotfix (KB951217), but that didn’t help either.
Then I looked in the log file again and discovered somewhere in the middle of the file that it couldn’t access a folder named FTData. So I created it manually – and the update worked!
I should add that I have a non-standard location for my SQL Server instance which is probably the reason that the installer couldn’t do it automatically.