Views:

Step 1: Open a Command Prompt Window (cmd.exe) as Administrator.

Step2: Copy and Paste the Following Lines, One at a Time, into the Command Prompt Window and Press the 'Enter' Key After Pasting Each One.

  • osql -S (local)\ADVANCEWARE -E -Q "USE [master]; EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2;"
  • net stop MSSQL$ADVANCEWARE
  • net start MSSQL$ADVANCEWARE

The Result Should Look Like This:

Administrator: C:\Windows\System32\cmd.exe <br>-S -E -Q "USE EXEC xp_ins <br>tance_regwrite N' , N' <br>er', N' REG_DWORD, 2;" <br>rows affected) <br>C: \Windows ysten32> <br>stop MSSQL$ADUANCEWARE <br>The SQL Server <ADUANCEWARE) seru ice is stopping. <br>he SQL Server service was stopped successfully. <br>C: start MSSQL$ADUANCEWARE <br>The SQL Server <ADUANCEWARE) service is starting. <br>he SQL Server (ADVANCEWARE> service was started successfully. <br>C: Windows ysten32>