SQL Server 2005 卸載殘留導致後續安裝 2008 失敗,需徹底清除註冊表、服務、檔案與使用者群組。本文整理完整六階段卸載流程,含關鍵註冊表機碼清單與輔助工具。

services.msc) 停止:MSSQLSERVER、SQLSERVERAGENT、MSSQLSERVERADHELPER、MSDTC、SQL Browser 等。

sc delete MSSQLSERVER
sc delete SQLSERVERAGENT
sc delete MSSQLSERVERADHELPER
sc delete MSDTC
sc delete SQLBrowser
核心機碼:
HKLM\SOFTWARE\Microsoft\MSSQLServer
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server
HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist
HKLM\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
HKLM\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT
HKLM\SYSTEM\CurrentControlSet\Services\MSSQLSERVERADHELPER
HKCU\Software\Microsoft\Microsoft SQL Server
全文檢索/搜尋相關 (若安裝):
HKLM\SOFTWARE\Microsoft\Search
HKLM\SYSTEM\CurrentControlSet\Services\MSFTPSVC
HKLM\SYSTEM\CurrentControlSet\Services\MSSCNTRS
HKLM\SYSTEM\CurrentControlSet\Services\MSSEARCH
HKLM\SYSTEM\CurrentControlSet\Services\MSSGATHERER
HKLM\SYSTEM\CurrentControlSet\Services\MSSGTHRSVC
HKLM\SYSTEM\CurrentControlSet\Services\MSSINDEX
具名實例** 在上述機碼路徑後加 \InstanceName (如 MSSQLSERVER\MYINST)。
C:\Program Files\Microsoft SQL Server、C:\Program Files (x86)\Microsoft SQL Server (若無法刪除用 Unlocker)。C:\Windows 下搜尋 sql* 清理 (含隱藏 inf 資料夾)。SQLServer* 相關群組。msdtc -resetlog 重設 DTC 記錄。