View Single Post
Old 06-10-08, 09:14 PM   #2 (permalink)
Sean2
Senior Member
 
Join Date: Feb 2008
Posts: 147
Thanks: 15
Thanked 71 Times in 46 Posts
Rep Power: 10 Sean2 is a splendid one to behold Sean2 is a splendid one to behold Sean2 is a splendid one to behold Sean2 is a splendid one to behold Sean2 is a splendid one to behold Sean2 is a splendid one to behold Sean2 is a splendid one to behold
Re: Question for installing Quality Center

Just uninstall msde from add-remove programs and you do NOT even need to restart the machine after uninstalling. msde will be installed by qc installer itself.
and then everything works fine...

Good Luck
nswer:
Two ways to iuninstall MSDE, the easy way and the hard way:

Easy Way:

1. Open the Control Panel and double-click Add/Remove Programs.

2. To uninstall MSDE, select MSDE and click Install/Uninstall.

Hard Way:

Here is how Microsoft suggests manually removing MSDE.

A) Remove the following registry:
1) Remove the following ID_Number from your MSDE 2.0 instance
HKEY_CLASSES_ROOT\Installer\Products\ID_Number
-- It has key value name 'ProductName' which displays the instance name.

For example, "ProductName" = Microsoft SQL Server Desktop Engine
(MYINSTANCE)

2) If you had patch applied on this MSDE 2.0 instance, you need to
remove
ID_Number for that MSDE 2.0 instance:
HKEY_CLASSES_ROOT\Installer\Patches\ID_Number

3) For MSDE 2.0 Default instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Your_instance_name

4) If you have the following key points to MSDE 2.0 productGUID, then
remove the InstanceComponentSet.x
For example, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\Component Set InstanceComponentSet.x
-- For example, InstanceComponentSet.1 has value matching the
productGUID
of sqlrun01.msi.

5) Remove:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr
entVersion\Uninstall\Produ
ctGUID
-- The Product GUID which refers to your MSDE 2.0 instance.

6) Remove the Sql server service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic
es\MSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic
es\MSSQL$Your_Instance_Nam
e

7)Remove the Sql server agent service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic
es\SQLServerAgent
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic
es\SQLAgent$Your_Instance_
Name

B) Remove the MSDE 2.0 instance data and program install directory:
For example, G:\Program Files\Microsoft
SQLServer\MSSQL$Your_instanceName\data
For example, G:\Program Files\Microsoft
SQLServer\MSSQL$Your_instanceName\binn
Sean2 is offline Offline   Reply With Quote
 
45,000 Jobs - Get an Interview Call,  Post Your Resume Here