Full Text Search returning zero records

[krisplus5]

Hi all,

I've moved a database to a new server (both SQL Server 2K, both with full-text search installed & enabled). On the old server, full-text search worked fine. On the new server, with the exact same data, full-text searches return zero records.

Any clues?

Thanks,
Kris

 

[mrdenny]

Have you rebuilt the catalog and repopulated it?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[krisplus5]

Yes. Rebuilt & repopulated. Twice ;-).

We moved the database over via an export. Had initially done it with detach-attach, but when full-text wasn't returning records, decided to try export instead.

Cheers,
Kris

 

[krisplus5]

Okay, got this fixed:
The test-server had had the BUILTIN\Administrators user deleted. We added it back in, and voila! it works.

mrdenny: I think I read another post of yours somewhere here regarding the BUILTIN\Administrators, and remembered it when I was checking user rights. Thanks for the off-hand tip!

Cheers,
Kris

 

[mrdenny]

You can use full text indexing with the buildin\administrators group removed. You have to manually add the local system account as a sysadmin then remove the BUILTIN\Administrator group.

sp_addlogin 'NT Authority\System'
go

You have to add this via code, Enterprise Manager can't add this account to SQL because it doesn't reconise the domain.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief