User does not have permission to alter database error in Plesk | Resolved

User does not have permission to alter database error in Plesk causing trouble? Our Support Team is here with a solution.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped out a customer with the “User does not have permission to alter database” error.

How to resolve User does not have permission to alter database error in Plesk

The User does not have permission to alter database error often appears while attempting to delete an MS SQL database in Plesk under Domains > example.com > Databases.

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.

This specific error also displays the database Table count as “null” under the Domains > example.com > Databases list.

According to our Support Techs, the error is due to a non-existent database in MSSQL. Moreover, the reference exists in the Plesk database complicating matters further.

Fortunately, our Support Team has come up with a solution for this issue. All you have to do is follow these steps and you can alter your database in peace without coming across an error:

1. 1. First, we have to connect to the server through RDP.
   2. Then, we will access the SQL Management Studio and create a database manually.
   3. Next, we have to log in to Plesk.
   4. Finally, we will head to Databases under example.com in the Domains section and remove the previous database.

In fact, this solution is a foolproof way of making sure that we do not run into the Unable to delete MS SQL database error in Plesk. In other words, we can alter the database without any further worries.

[Looking for a solution to another query? We are just a click away.]

Conclusion

In essence, the skilled Support Engineers at Bobcares demonstrated how to deal with the “User does not have permission to alter database” error.