• 0 environment
  • 1 prepare
  • 2 Step Reappearance
  • 3 to solve
    • 3.1 virtual installation of sqlserver

0 environment

  • System environment: Windows platform, VM
  • Editor: IDEA, VScode
  • Vscode plug-in: MSSQL

1 prepare

  • This article refer to
    • Refer to the article
    • Blog Garden Article

2 Step Reappearance

  • First go to control panel and click R2 and delete
  • When the bat deletion is complete, it is sometimes prompted that the deletion cannot be done
@echo off set /P dv= Please confirm forcibly delete MSDE2008 (please uninstall in control panel first),Y= delete, N= exit: if not defined dv set dv=N if /i "%dv%"=="n" goto :next rd /s /q "C:\Program Files\Microsoft SQL Server" rd /s /q "C:\Program Files (x86)\Microsoft SQL Server" reg delete "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager" /v "PendingFileRenameOperations" /f reg delete "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server" /f reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" /f reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer" /f reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQL Redist" /f :next echo delete MSDE directory! & pauseCopy the code
  • Delete C:\Program Files\Microsoft SQL Server” and “C:\Program Files (x86)\Microsoft SQL Server”
  • Search for Microsoft SQL Server in the registry and delete it all but I can’t reinstall it

3 to solve

❝

Repeated several times to uninstall the installation of SQLServer is not good I would like to use a virtual machine (Windows series optional test death) failed to directly delete all to do not care about what registry what

❞

3.1 virtual installation of sqlserver

  • Install win7 on the virtual machine a lot of not much to say
  • After the sqlserver is installed
    • “Turn off firewall” –> “Control Panel” “System and Security” “Windows Firewall”
    • “Host and VM ping each other (CMD ipconfig to obtain the IP address of each other)“
    • “After the ping succeeds, test the sqlserver“
      • “Sqlserver is starting in the virtual machine“
      • “IDEA is used on the host to test whether the sqlserver is successfully connected“
    • “Connect to sqlserver using vscode (I don’t like to use sqlserver)“

  • “Install sqlserver requires binary configuration“