Start Microsoft SQL Server in Single User Mode for admin task

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

  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.