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.
- Log into Microsoft SQL Server Management Studio
- Go to Databases > [Database] > Storage > Full Text Catalogs
- 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.
Article ID: 410, Created: April 9, 2012 at 3:00 PM, Modified: August 26, 2014 at 8:58 AM