Jun 24, 2014

Microsoft SQL Server Database Services and Analysis Services Failed Update With Error Code 1603

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.
Or

Service Pack 4 for SQL Server Analysis Services 2005 ENU (KB2463332) could not be installed. Error code 1603.
Apparently 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!

Remove the following to get database services to update:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\FTSGroup
Remove the following to get analysis services to update:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup\ASGroup
That's it, after removing those registry keys the upgrade went smoothly... Oh, and the upgrade also fixed my maintenance job problem!
[Via SDP]



Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | stopping spam