MSSQL: How To Get Database Out of Single User

The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state.
Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code below with the database you want to restore.
ALTER DATABASE YourDatabase SET MULTI_USER
The database will then be ready for multiple users accessing it.

Leave a Comment