Become The Solution Chicago Logo

Become The Solution Chicago Logo

Search Become The Solution:

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.

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Guest
Saturday, 02 July 2022