Start Microsoft SQL Server in Single User Mode for admin task
Step 1.
Click “Start | All Programs | Microsoft SQL Server 2012 | Configuration Tools.”.
Step 2.
Click “SQL Server Configuration Manager.” Select “SQL Server Services” from the left pane and then right-click the server.
Related Reading: How to Build a Query String in T-SQL.
Step 3.
Choose “Properties” from the context menu. Click “Startup Parameters.” Select the the field next to Specify a Startup Parameter and then enter “-m” — without the quotes.
Step 4.
Click “Add,” then “OK.” Restart SQL Server to run the instance in single-user mode.
2nd Method
- Access Command prompt (C:\)
- At the prompt type: net start MSSQLSERVER /m