Fix: The Database “” is Not Accessible (ObjectExplorer) – Microsoft SQL Server Management Studio
In Microsoft SQL Server Management Studio, you may connect to a database but receive the following error.
The database “” is not accessible. (ObjectExplorer)
The cause of this error is because you connected to a Microsoft database in Single User mode. Start the SQLServer instance with the –m parameter then start SQL Server Management Studio using windows authentication. Assign yourself the sysadmin role to your user then remove the the –m parameter. Restart SQL server.
* Please use the comment form below. Comments are moderated.*
Comments