Forum Discussion
Single User Mode on SQL Server Management Studio
We have an instance where the resource for our SQL Database was updated, when we try and sign into SQL Server Management it just says Single User Mode and only one admin can be signed in at any one t...
1. SSMS = "SQL Server Management Studio" is just a tool, it can't be in "single user mode"; the database engine may is.
2. SSMS always open 2 connections to SQL Server, one to many. Close the "Object Explorer", which holds a separate connection.
3. Review SQL Server ErrorLog file for details, why SQL Server is in single-user mode; it's a simple text file.
Viewing the SQL Server Error Log - SQL Server | Microsoft Learn