Article ID: 1538, created on Oct 6, 2008, last review on May 10, 2014

  • Applies to:
  • Plesk 7.6 for Windows


When attempting to delete an MSSQL 2005 database using Plesk, the following error message is displayed:

Error: Unable to delete the database user: Unable to remove database user: Delete database user failed: The database principal owns a database role and cannot be dropped.

This often happens with databases of the DotNetNuke application.


The database user owns a role or a schema.


1. For each database user that cannot be deleted, its role or schema ownership needs to be identified. To do this, the following query can be used:

select as role, as owner from sys.database_principals as dp1 inner join sys.database_principals as dp2 on dp1.principal_id = dp2.owning_principal_id where = 'Username'

(where Username is the name of the user that needs to be deleted).

2. The owner of this principle (role) should be changed to dbo. This can be done using the role manager in SQL Management Studio.

3. Once these changes have been made, it will be possible to delete the database and the user.

Additional Information

This problem has been solved in Plesk version 8.2. Consider upgrading Plesk to the latest version.

c0c38d2367acfa8909699e0b34b01dea 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c e115c1a9652baf38f4af4f18d5b7ac6e 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF