Start Sql Server in Single User Mode

Start Sql Server in Single User Mode

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

  1. Access Command prompt (C:\)
  2. At the prompt type: net start MSSQLSERVER /m
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.