/
The Database Is Not Accessible

The Database Is Not Accessible

Description of Issue

When trying to connect to a database in SSMS, you get the error The database xxx is not accessible

Context
  • SSMS

  • SQL

  • SQL Server Management Studio

  • Database connection

Cause

SQL services not functioning properly

Resolution
  1. Connect to the Database server

  2. Open Services

  3. Scroll down to the SQL Services

  4. For the applicable SQL instance:

    1. If the service is not running, right click the SQL Server service > click Start

    2. If the service is already running, right click the SQL Server service > click Restart

Additional Information










Related content

A network-related or instance-specific error occurred while establishing a connection to SQL Server
A network-related or instance-specific error occurred while establishing a connection to SQL Server
More like this
How Do I Connect to a Database Using SSMS
How Do I Connect to a Database Using SSMS
More like this
Database Stuck In Restoring Status
Database Stuck In Restoring Status
More like this
How to Grant access to DB owner ET
How to Grant access to DB owner ET
More like this
Unable to see databases or tables when connecting to server using SSMS
Unable to see databases or tables when connecting to server using SSMS
More like this
Cannot See Database Listed When Setting Up ODBC or SSMS Connection
Cannot See Database Listed When Setting Up ODBC or SSMS Connection
More like this