The other night I was trying to configure a simple database backup maintenance job on one of my company's older Microsoft SQL 2005 servers. For some reason every time I tried to run the maintenance job I created it would fail for some reason.
Well after Googling around someone suggested that it might be a problem where Microsoft SQL Management Studio was a different version than the database services. Looking at it that was the case. Database services was at version 9.00.4035 and Microsoft SQL Management Studio was running 9.00.500. Apparently at some point, someone tried to run the SP4 upgrade and it failed and they just left it (Evil eyes goes to the DBA).
Anyhoo, so I decided to try and install SP4 for Microsoft SQL 2005, and it kept failing for database services and analysis services with an error similar to this:
Service Pack 4 for SQL Server Database Services 2005 ENU (KB2463332) could not be installed. Error code 1603.
OrApparently that is a common issue. To fix it you have to remove a few registry keys. MAKE SURE TO MAKE A BACKUP OF THOSE KEYS FIRST!
Service Pack 4 for SQL Server Analysis Services 2005 ENU (KB2463332) could not be installed. Error code 1603.
Remove the following to get database services to update:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\SQLGroupRemove the following to get analysis services to update:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\ASGroupThat's it, after removing those registry keys the upgrade went smoothly... Oh, and the upgrade also fixed my maintenance job problem!