Manufacturing Information Solutions Forum Index Manufacturing Information Solutions
Your Place for Support and Discussions
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Removing MS SQL Server

 
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> Microsoft Servers
View previous topic :: View next topic  
Author Message
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Thu Jun 19, 2008 7:58 am    Post subject: Removing MS SQL Server Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> Microsoft Servers All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group