sql server full text search: Access denied when trying to index a table? -- sql server full text search

You're in the

sql server full text search

group:

Access denied when trying to index a table?

news.microsoft.com
8/19/2003 1:39:41 PM

sql server full text search:

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

Re: Access denied when trying to index a table?

John Kane
8/19/2003 8:44:38 PM

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

[quoted text, click to view]

Re: Access denied when trying to index a table?

Ben
8/20/2003 12:17:19 PM

hi john. thanks for your help. i am accessing sql server as the system
admin. i have confirmed that the installation is using named pipes and
TCP/IP. the sql server is registered in the enterprise manager as "local",
with login as "sa".

i tried running sp_fulltext_catalog, but got this error

Server: Msg 15601, Level 16, State 1, Procedure sp_fulltext_catalog, Line 17
Full-Text Search is not enabled for the current database. Use
sp_fulltext_database to enable Full-Text Search.

so i ran sp_fulltext_database, and got this error:

Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 46
Execution of a full-text operation failed. Access is denied.

how can access be denied to sa? i don't get it.

thanks,
ben

Re: Access denied when trying to index a table?

Ben
8/20/2003 12:40:30 PM

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.

Re: Access denied when trying to index a table?

John Kane
8/20/2003 5:41:37 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server full text search group.

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn