news.microsoft.com

hi all. i have a win2K box with sqlserver 2000, and i'm trying to get full
text indexing to work. the ms search service is running under the local
system account. sql server is running under a domain account with full admin
priveledges. the enterprise manager shows the Full-Text Search support
service as running, but when i try to define full text indexing on a table,
i get to the last step in the FT wizard, and when i click Finish, i get a
pop error that says "Execution of a full-text operation failed. Access is
denied." i click OK, then i get another pop error that says "Wizard failed
to complete the catalog setup. It will try to recover the initial settings."
i click OK, and nothing happens. anyone know what's going on? i have tried
this while logged in as local admin and domain admin, with the same results.

thanks,
ben

john kane

Ben,
What is your access level to this SQL Server? Could you confirm if this
server supports "named pipes" as well as IP? There was a bug in the past
(with SQL 7.0) that gave similar denied access errors, but it was fixed. How
do you have this sql server registered in your Enterprise manager? with an
IP address or alias? Also, can you successfully run sp_fulltext_catalog,
sp_fulltext_table from the QA?

Regards,
John

ben

hey, i just figured this problem out. the sql server service was running
under an account that my dba told me had full admin priveledges, but it
actually did not. grr. changing the account solved the problem.

john kane

Ben,
Yep, it's always the "little" details like this that solve problems!! <g>
John