Restart your SQL Server instance and it should then run in single-user mode. Append the -m to the end of the Startup Parameters box.Д¬lick Apply to save your changes. If youвЂ™ve installed SQL Server 2008, 2005 or an earlier version, click Advanced tab.

Type -m in the Specify a startup parameter box and then click Add. In SQL Server 2014 or 2012, click Startup Parameters tab. Select Properties from the drop-down menu. Choose SQL Server Services from the left panel and then right-click on desired SQL Server service that needs to run in single-user mode. Method 1: Start SQL Server in single-user mode through SQL Server Configuration Manager This can be either done via SQL Server Configuration Manager by setting the startup parameters or through the Command Prompt. IвЂ™m going to walk you through the process of putting your SQL Server database into single-user mode.

Only one user can connect to the database.

Any current connections to the database are dropped without warning.

When a database is started in single-user mode, the following events occur: Both actions require starting an instance of SQL Server in single-user maintenance mode.

For example, you might need to restore your master database from a backup in the event of a failure or damage, detach the database and kill all the connections. There are certain situations when user may have to start a SQL Server instance in single-user mode.

Start sql server on mac