Fix: The Database “” is Not Accessible (ObjectExplorer) – Microsoft SQL Server Management Studio

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.*



Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Wednesday, 20 November 2024