Dynamics 365 Finance & Operations Talk: The database principal owns a fulltext catalog in the database

Showing posts with label The database principal owns a fulltext catalog in the database. Show all posts

The database principal owns a fulltext catalog in the database, and cannot be dropped.

Problem

Msg 15138, Level 16, State 1, Line 1

The database principal owns a fulltext catalog in the database, and cannot be dropped.

Find the catalog name and change the owner ship like below

Run the command on your database

select * from sys.fulltext_catalogs

Now change the ownership with below script

Example

ALTER AUTHORIZATION ON Fulltext Catalog::[CatalogName] TO [dbo];

Script should be in my case like

ALTER AUTHORIZATION ON Fulltext Catalog::[COMMERCEFULLTEXTCATALOG] TO [dbo];

ALTER AUTHORIZATION ON Fulltext Catalog::[SqlTempDBForSync_catalog] TO [dbo];