Solved

Drop Failed: Te database principal owns a fulltext catalog in the database

Posted on 2011-03-17
3
1,951 Views
Last Modified: 2012-05-11
Hello,

I moved a SQL Server 2005 database to SQL Server and the account has lost its password. So, I tried dropping it and recreating it in the database. I get the error:

Drop failed for User 'dba'.  (Microsoft.SqlServer.Smo)
The database principal owns a fulltext catalog in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

I have about 20 fulltext catalog's in the database. Which owner would I use in the script below?

sp_changeobjectowner  'app_facility_catalog', [ @newowner = ] 'owner'

Thanks.



0
Comment
Question by:gtrapp
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
Ztinel earned 500 total points
Comment Utility
0
 

Author Comment

by:gtrapp
Comment Utility
Hi,

Yes, I saw that, but wondering what I put as the owner when I run the script.
0
 

Author Comment

by:gtrapp
Comment Utility
Thanks, I got it fixed by running this:

exec sp_change_users_login 'Auto_Fix', 'dba'
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now