Unable to delete MS SQL database in Plesk: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks

Vincent Lauton

Updated December 17, 2024 14:54

Plesk for Windows kb: technical

Applicable to:

Plesk for Windows

Symptoms

On attempt to delete an MS SQL database in Plesk from Domains > example.com > Databases results in the following error:

User does not have permission to alter database 'DB', the database does not exist, or the database is not in a state that allows access checks.

There is an error referencing this database in the example.com's subscription backup:

Warning: Database "DB"
Unable to make database dump. Error: Failed to exec mssqldump.exe: Exit code: 1: Cannot open database "DB" requested by the login. The login failed.
Login failed for user 'sa'.

The database Table count is displayed as null in Domains > example.com > Databases list

Resetting the 'sa' user's password does not help

Cause

Database doesn't exist in MSSQL but reference exists in Plesk database.

Resolution

Connect to the server via RDP
Access SQL Management Studio and manually create database
Log in to Plesk
Go to Domains > example.com > Databases and delete the affected database