The Database Is Not Accessible

Owned by Knowledge Assistant
Jun 17, 2024
1 min read
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