Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DYeargin
Starting Member
2 Posts |
 Posted - 2006-08-17 : 13:56:53
|
| I am running SQL 2000, SP3a. Full text indexing (FTI) has been working great. The MS Search service is running under "LocalSystem". The sql server service is running under a domain account with admin rights on the server. Sometime ago, the "Builtin\Administrators" login was removed, which killed the FTI. A login was added for "NT Authority\System" and given sql server "sysadmin" rights. After a restart, the FTI ran smoothly again.This weekend I had to move db files to different drives. I detached the db's, moved the files, then re-attached the db's. Full text indexing STOPPED working at this point. I am receiving the error: Could not start the MS Search service on Local Computer. Error 1307: This security ID may not be assigned as the owner of this object.I tried reproducing this chain of events on a dev server. After the re-attach, the FTI stopped working. I tried to rebuild a catalog and got the following message: Error 15601: Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable Full-Text Search.I ran the sp_fulltext_database and everything was OK on the dev box. I then realized the dev box was on SQL SP4. I can not upgrade the production box to SP4. Any help associated to my SP3a box would be appreciated!!David Yeargin |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-18 : 05:02:08
|
| You have an 'orphaned user'....search here for a description of the problem and it's resolution.Investigate using the SP "sp_change_users_login @action='report'"and then "sp_change_users_login @action='update_one', @UserNamePattern='useridname', @LoginName='useridname' |
 |
|
|
DYeargin
Starting Member
2 Posts |
Posted - 2006-08-18 : 06:21:34
|
| Thanks for your post Andrew! I just ran the "...='report'" and returned no records so maybe this is the problem. I will be evaluating further later this morning. Thanks again!! I will offer an update.David Yeargin |
|
|
|
|
|
|
Full Text Indexing, SQL 2000 SP3a