Database 'XXX' is Already Open and Can Only Have One User at a Time

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

Question

I am receiving the error "Database 'xxx' is already open and can only have one user at a time. How do I resolve this error.


Answer

The reason you are receiving this error is that your DB is set to single user mode. To correct this error go into Enterprise Manager and right click on the DB and go to Properties, than go to the options tab and uncheck the Single User check box.




This article was TechKnowledge Document ID:19039

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×