Tips You should restart SQL Server Agent before launching the instance of SQL Server in single-user mode. Click "View," then "Object Explorer." Right-click "SQL Server Agent" and then click "Stop." ...

Click the name of your SQL server in the Object Explorer pane to expose your databases. Select "user databases," then right-click the name of the database you want to restore (Source 1).

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver.

After reboot, you will be able start SQL Server and connect from client machines using Named Pipes 7. Take a backup and delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1 ...