Database ‘…’ is already open and can only have one user at a time

If your database is stuck in single-user mode, connect to 'master' database and right-click on your stuck database. Click Properties->Options, scroll to the bottom and change “Restrict Access” value to “MULTI_USER”.

How to connect to master db?

Easy. First, close any query windows that you have opened for your stuck database.

Then click on 'master' and open a new query window for it.

Now you should be able to right-click on your stuck database.

Hope this helps someone.

Good luck,

Leave a Reply

Your email address will not be published. Required fields are marked *