Set DB to single-user mode, now I cannot open it in SMSS
In order to allow me to rename a database I set it to single-user mode. The rename worked fine but now trying to open the DB or even view its properties gives me connection errors. I've tried restarting SMSS but to no avail. All I wanted to do was rename it now I'm stuck. SMSS is generally acting very flaky.
What has gone wrong and how do I fix it? I'm running on Windows.
- restart sql server
- open SMSS and login to sql server
- on a new query run
ALTER DATABASE dbname SET MULTI_USER;to set your db to back to Multi-user