mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Thu Jun 19, 2008 7:58 am Post subject: Removing MS SQL Server |
|
|
You have a previous version of MSDE or SQL Server installed.
Please check if you have a previous version installed, if you do and wish to remove it so that you can install a newer version then try using the Windows Add/Remove Programs. If it is not listed in Add/Remove Programs dialog then try removing it manually using the following:
Open Windows Services dialog and check whether the Services "MSSQLSERVER" and/or "MSSQLServerADHelper" are running.
1 - Stop & Uninstall Microsoft SQL Server Service
You can either stop these services via Services dialog or via "scm.exe" (Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe) It is recommended that you use the file "scm.exe" for stopping and uninstalling the services
To stop service "MSSQLSERVER" open a command prompt and type:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm -Action 6 -Service "MSSQLSERVER"
To stop service "MSSQLServerADHelper" type
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm -Action 6 -Service "MSSQLServerADHelper"
To uninstall service "MSSQLSERVER" type
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm -Action 4 -Service "MSSQLSERVER"
To uninstall service "MSSQLServerADHelper" type
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm -Action 4 -Service "MSSQLServerADHelper"
2 - Delete any folder created on local drives for MSDE
Browse your folders and look for MSSQL7 and Microsoft SQL Server. Please back up these directories before deleting them.
3 - Delete registry keys for MSDE
Open the Windows Run dialog and type Regedit then browse to the following and delete the keys:
HKEY_CLASSES_ROOT\Installer\Products\9AAF876289E92F84C8F47AB5C63FB668
HKEY_CLASSES_ROOT\Installer\Products\E35343D0361D4BA4ABE5B0043796AA16
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{0D34353E-D163-4AB4-BA5E-0B407369AA61}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{2678FAA9-9E98-48F2-8C4F-A75B6CF36B86}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\InstallShield_{0D34353E-D163-4AB4-BA5E-0B407369AA61}
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
Note It is recommended that only users with experience in using Windows registry perform these tasks as incorrect use could cause problems with your operating system.
See also: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939 |
|