Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL 2005 will not unistall

Author  Topic 

leifthoreson
Starting Member

16 Posts

Posted - 2007-01-26 : 12:32:40
Ok, this is just to share a solution to an error that I had a hard time tracking down.
"If this solution does not work for you or crashes your server, sorry but I will not be held responsible. So back your system up before you change the registry or uninstall anything."

I attempted to uninstall sql 2005 and the uninstall would never complete. I was using add/remove programs from the control panel.
The server would never give me an error message as to why it would not unistall. The item remained in add/remove.
Finally I attempted to uninstall SQL Server 2005 using the GUID (that I tracked down in the registry) start/wait msiexec /uninstall {GUID}

and the error popped up telling me

"The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation"
wow!
after some searching I found
(NOTE: the following site list a change to the registry, Do Not Do This unless you know what you are doing. )

http://support.microsoft.com/kb/919945

NOTE: the following has a change to the registry, [b]Do Not Do This
unless you know what you are doing. I will not be held responsible if you do.

It had me check in the registry.

Microsoft SQL Server\MSSQL.2005\Setup
•Microsoft SQL Server\MSSQL.X\Setup

[b](Back up your registry before you change anything!!!!)

Empty the following registry entries:
• SQLGroup
• FTSGroup
• AGTGroup



sure enough this error was because of a name change in the AD.
I cleared the groups and the uninstall ( from add remove) worked.



sure enough there error was because of a name change in the AD.
I cleared the groups and the uninstall ( from add remove) worked.


   

- Advertisement -