Full-text Catalog Creation Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dweingarten@firstam.com - 24 Jun 2005 13:47 GMT

I am trying to set up full-text indexing on my SQL Server 2000 instance
running on WIndows 2000 Server. Every time I try to create a FT
catalog, I get the following message:

"The microsoft search service cannot be administered under the present
user account."

I have read other postings that recommend changing logon credentials
for the MSSQL\SQLAgent services. I have tried every combination
imaginable, and have made the changes from both SQLEM and the services
control panel applet.

No matter what I do, I can't get it to work on this server. It works
fine on other servers in my network, so I'm not sure what's missing.

I don't want to have to reinstall the product, if I don't have to.

Any help would be greatly appreciated.

Reply to this Message

Hilary Cotter - 24 Jun 2005 15:04 GMT

Its not the SQL Server Agent account, but rather the account that SQL Server
runs under.

Also verify that the builtin\Administrators account is part of the sysadmin
role. For more info review this kb article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q317746

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I am trying to set up full-text indexing on my SQL Server 2000 instance
> running on WIndows 2000 Server. Every time I try to create a FT
[quoted text clipped - 14 lines]
>
> Any help would be greatly appreciated.

Reply to this Message

dweingarten@firstam.com - 24 Jun 2005 18:53 GMT

Those are both set appropriately, but thanks for the tip. Any other
ideas? I'm about to call Microsoft.

Reply to this Message