Symptom
Resolution
Before attempting to reinstall the SQL Server 2005 or hot fix, complete the following steps:
Important: Modifying the registry could cause irreversible damage to your Windows operating system; be sure to back up the registry before making any changes. Follow the instructions located at: http://support.microsoft.com
1) Click the Start button, then click Run.
2) Type regedit and then click [OK]
3) Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\ASGroup
Note: MSSQL.X can be determined by going to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\
2) Reinstall the SQL Server 2005 service pack or hot fix.
