Unable to remove MSSQL database: Changes to the state or options of database 'database' cannot be made at this time

Created:

2016-11-16 13:13:44 UTC

Modified:

2017-08-08 13:37:34 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to remove MSSQL database: Changes to the state or options of database 'database' cannot be made at this time

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

Unable to remove/add data in the specific database in Plesk > Domains > example.com > Databases due to the following error;

    Remove database failed: mssqlmng failed: Changes to the state or options of database 'database' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

Cause

Database is using the single-user mode.

Resolution

Switch database to multiple user mode using SQL Management Studio:

ALTER DATABASE "database_name" SET MULTI_USER
go

Additional information can be found in Microsoft Technet Library .

Have more questions? Submit a request
Please sign in to leave a comment.