Delete Database User Failed: The Database Principal Owns A Fulltext Catalog In the Database, and Cannot Be Dropped.

Plesk Servers > SQL > MSSQL

 

 
Delete Database User Failed: The Database Principal Owns A Fulltext Catalog In the Database, and Cannot Be Dropped.

Issue
When you try to delete a database user through Plesk Control Panel you receive the following error message: Delete database user failed: The database principal owns a fulltext catalog in the database, and cannot be dropped.

Cause
The database user owns a full text catalog.  In order to delete the user you will need to manually delete the full text catalog first.

Resolution
These steps require you to have Microsoft SQL Server Management Studio installed on your computer.  If you do not have this installed
Microsoft SQL Server Mangement Studio Express 2008 is available for free from Microsoft, and can be downloaded through this link: http://www.microsoft.com/download/en/details.aspx?id=22985

Always back up the website before making any changes to the database . Shared hosting customers can do this through the Control Panel. Refer to Back Up Your Website Using Plesk. Dedicated server customers can back up the site either through the Control Panel, or through the Control Suite. Refer to How to Back Up a Domain Using Control Suite.


Caution: These steps will permanently remove your Full Text Catalog.  You should not perform these steps if you intent to use the catalog.
  1. Log into Microsoft SQL Server Management Studio  
  2. Go to Databases > [Database] > Storage > Full Text Catalogs
  3. Delete any listed full-text catalogs.
You may now follow the instructions in the How To Delete An MSSQL or MySQL Database article to delete your Database in the Plesk Control Panel.

 

Add Feedback