SQL Server DB stuck in single-user mode"

Programming
1

My SQL Server 2016 database is stuck in single user mode, and I can’t seem to fix it. I have tried executing the following command:

 ALTER DATABASE MyDatabase
 SET MULTI_USER;

However, I get a message that the database is already in use. To find out which spID was using the database, I used the command:

 exec sp_who

The command revealed that spID 57 was using the database. After that, I attempted to kill the spID with the command:

 KILL 57

But it failed with a message that Process ID 57 is not an active process ID. I have also tried the solutions suggested by SQL Server 2008 R2 Stuck in Single User Mode, but they did not work. Does anyone have any other ideas?

2

You can try using the ALTER DATABASE command with the SET MULTI_USER WITH ROLLBACK IMMEDIATE option to force all connections to the database to be closed:

ALTER DATABASE MyDatabase
SET MULTI_USER WITH ROLLBACK IMMEDIATE;

This should allow you to take the database out of single user mode.