uninstall msde

卸载msde

[@more@]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_ROOTInstallerProductsID_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_ROOTInstallerPatchesID_Number

3) For MSDE 2.0 Default instance, remove
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoftSQLServerYour_instance_name

4) If you have the following key points to MSDE 2.0 productGUID, then remove the InstanceComponentSet.x
For example, HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoftSQLServerComponent Set InstanceComponentSet.x
For example, InstanceComponentSet.1 has value matching the productGUID of sqlrun01.msi.

5) Remove:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstallProductGUID
-- 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_MACHINESYSTEMCurrentControlSetServicesMSSQLServer
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMSSQL$Your_Instance_Name

7)Remove the Sql server agent service key:
For MSDE 2.0 default instance, remove
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesSQLServerAgent
For MSDE 2.0 named instance, remove
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesSQLAgent$Your_Instance_Name

B) Remove the MSDE 2.0 instance data and program install directory:
For example, G:Program FilesMicrosoftSQLServerMSSQL$Your_instanceNamedata
For example, G:Program FilesMicrosoftSQLServerMSSQL$Your_instanceNamebinn

就是手动删除了。恩,这下终于可以装msde了。不太明白,msde装 完后没有管理器。在网上下了一个共享的管理器,一言,不好用。

我平时都在2003上做事,手头的本本系统是xp,就把2003上的toolsbinn目录里的东西全部调过来,直接覆盖到 xp 里的msde安装目录里 80toolsbinn里,(覆盖时请退出sqlserver服务管理器),试运行SQL Server Enterprise Manager.MSC,果然不行,网上续查。

发现只要注册几个文件就可以了。见包里的msc.bat,运行就可以了。

__________

几点小结论:

msde是免费的数据库,对于程序员和分发中小型数据库足够用,(2G大小,25个连接)也不是很大,就安装吧。msde删除是个难题,不行的话用上面的手动删除法。怎么盗用sqlserver企业版的管理器。

还有一个小建议,不要再在所谓的精简版在耗费时间。
请使用浏览器的分享功能分享到微信等