For a pure dev-machine I only have the MS-SQL express edition installed, which is being distributed along with the current Visual Studio release.
Doing also some DBA stuff, I soon figured that I need to have the real management-console (Management Studio) as well. So I tried to install just Management Studio from the “real” SQL Server. This turned out to be quite difficult (with SQL 2008 this turned out to be no burden at all anymore).
So after doing a tremendous amount of tweaking I finally got everything working alright – until the SP2 for SQL 2005 was shipping.
Trying to install the SP2 was a bigger problem than I expected. The update for the Express Edition complained about the installed Management Studio, which created a version mismatch and the standard edition of SQL Server complaint about the mismatching database engine from the express edition.
Fortunately SP3 does a way better job. Just install both updates (for the standard edition and the express edition) and you’re all set. The last issue was an abort during the express edition update. This was somehow the sample issue, which stopped the KB 948109 update from installing. So opening up the registry and going to the key
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup (respectively
HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.2005\Setup) and deleting the settings
SQLgroup solved this issue.