all groups > sql server full text search > june 2005 >
You're in the

sql server full text search

group:

Full-text Catalog Creation Problem



Full-text Catalog Creation Problem dweingarten NO[at]SPAM firstam.com
6/24/2005 5:47:45 AM
sql server full text search: 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.
Re: Full-text Catalog Creation Problem Hilary Cotter
6/24/2005 10:04:15 AM
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

--
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
[quoted text, click to view]

Re: Full-text Catalog Creation Problem dweingarten NO[at]SPAM firstam.com
6/24/2005 10:53:44 AM
Those are both set appropriately, but thanks for the tip. Any other
ideas? I'm about to call Microsoft.
AddThis Social Bookmark Button