这里是msde with sp4,下下来吧,80多的兆。接下来安装,唉,总装不上去,真不知道为什么?我怕是所谓的绿色版和免安装版有影响吧,大概把注册表写得乱七八糟吧。接下来装了N次,都这样,要不然自动回退,要不然无任何消息退出。晕。在添加删除程序里想把msde删掉,出现严重错误,一句话,想删我,不容易。怎么办,到ms查,说是msde安装里的一个已知bug,说要找到是那个msi文件才能删除。看了半天,试了多次,无功而返。继续查,发现一文,终于可以不用重装OS了。如下:
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\MicrosoftSQLServer\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\MicrosoftSQLServer\Component Set InstanceComponentSet.x For example, InstanceComponentSet.1 has value matching the productGUID of sqlrun01.msi.
5) Remove: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ProductGUID -- 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\Services\MSSQLServer For MSDE 2.0 named instance, remove HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$Your_Instance_Name
7)Remove the Sql server agent service key: For MSDE 2.0 default instance, remove HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent For MSDE 2.0 named instance, remove HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLAgent$Your_Instance_Name
B) Remove the MSDE 2.0 instance data and program install directory: For example, G:\Program Files\MicrosoftSQLServer\MSSQL$Your_instanceName\data For example, G:\Program Files\MicrosoftSQLServer\MSSQL$Your_instanceName\binn
我平时都在2003上做事,手头的本本系统是xp,就把2003上的tools\binn目录里的东西全部调过来,直接覆盖到 xp 里的msde安装目录里 80\tools\binn里,(覆盖时请退出sqlserver服务管理器),试运行SQL Server Enterprise Manager.MSC,果然不行,网上续查。