SQL Server 卸載不乾淨是導致重裝失敗、服務衝突的常見主因。本文提供四階段「控制台 → 3rd 工具 → 手動註冊表/檔案 → 重啟」標準化卸載流程,確保無殘留。



sc delete MSSQLSERVER
sc delete SQLSERVERAGENT
sc delete MSSQLSERVERADHELPER

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVERADHELPER
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
若為具名實例,在上述機碼路徑後加 \InstanceName(如 MSSQLSERVER\MYINST)。
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSFTPSVC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSCNTRS
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSEARCH
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSGATHERER
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSGTHRSVC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSINDEX
C:\Program Files\Microsoft SQL Server、C:\Program Files (x86)\Microsoft SQL Server。C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server 等。msdtc -resetlog 重設 DTC 記錄。