Start SQL Server in single user mode

Single User mode in SQL Server can connect with single user only and did not start checkpoint process. We have to start SQL Server in single user mode, when issues are like master Database restore, Sysadmin locked out etc,.. Process is very simple. This is three step process.

1) Open SQL Server COnfiguration Manager by executing following *.msc file for respective versions. Stop SQL Server services

SQL Server 2016 C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 C:\Windows\SysWOW64\SQLServerManager11.msc
SQL Server 2008 C:\Windows\SysWOW64\SQLServerManager10.msc

Start SQL Server in Single User Mode

2) Double click on SQL Server or Right click on SQL Server, select properties and goto Advanced Properties. Add -m in startup Parameters as shown below.

In SQL Server 2005 and 2008 Versions
Start SQL Server Instance in Single User Mode

In SQL Server 20012 or later Versions
Start SQL Server Instance in Single User Mode

3) Now, Start SQL Services & SQL server will come online in single user mode.

Dont forgot to remove the parameter -m added in last step to put server in mulit user mode and start server SQL service.

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: