卸载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企业版的管理器。
还有一个小建议,不要再在所谓的精简版在耗费时间。