Groups | Blog | Home
all groups > sql server full text search > may 2004 >

sql server full text search : Full Text Service not starting from EM


Benoit
5/13/2004 7:13:00 PM
hello,

I have the following problem. Everything was working fine
with the full text search. I created a catalog etc... now
in EM, database->tools->"Full Text Indexing" is grayed
out. I cannot use the full text indexing with tables
(grayed out) and the full text search is marked as stopped
in the support services. Trying to start it returns a "an
instance of the service is already running" error. The
Microsoft search service is started however.

I am also able to run queries using the full text indexes
I have created, so it seems only the administration from
EM is not working.

any idea would be greatly appreciated

thank you

John Kane
5/13/2004 8:09:17 PM
Benoit,
You should checkout the following KB article "Q270671 (Q270671) PRB: Full
Text Search Menus Are Not Enabled for Local Windows NT Accounts" at
http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671 this should
explain the problem you are experiencing.

Regards,
John



[quoted text, click to view]

anonymous NO[at]SPAM discussions.microsoft.com
5/14/2004 11:20:27 AM
John thank you for your reply...

The instance of the SLQ server 2000 is running on my
computer under the localsystem account. I am connecting
with EM on my computer running the service, not from
another client computer. in EM the local server is
registered with Windows Authentication.

Isnt there a way for me to administer Full Text Search
from EM under these conditions? Seems like the most
straightforward configuration to me.

thanks again

Benoit


[quoted text, click to view]
John Kane
5/14/2004 6:16:20 PM
You're welcome, Benoit,
If you are using the (system) LocalSystem account to start & run the
MSSQLServer service, then it should work. This is the exact configuration
I'm using on my home server and it works for me. Can you re-confirm that you
are not using a local machine account, check the EM server property security
tab and "system account" should be marked. Can you use the system stored
procedures to create and populate FT Catalogs on this server, (see SQL 2000
BOL for examples of use):

a.. sp_fulltext_database -- Initializes full-text indexing or removes all
full-text catalogs from the current database.
a.. sp_fulltext_catalog -- Creates and drops a full-text catalog.
a.. sp_fulltext_table -- Marks or unmarks a table for full-text indexing.
a.. sp_fulltext_column -- Adds columns to full-text indexes.

Regards,
John




[quoted text, click to view]

Hilary Cotter
5/16/2004 8:22:26 AM
I find sometimes you have to right click on your SQL FTS catalog in EM, and
refresh it. Sometimes through a combination of manipulating your catalogs
you can enable your Full Text menus.

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


[quoted text, click to view]

anonymous NO[at]SPAM discussions.microsoft.com
5/17/2004 1:31:21 PM
hello,

thank you both for your help. the system stored procedures
are working fine to create/populate catalogs but my menus
are still disabled. I have another computer with the exact
same configuration and all the menus are enabled. Ive seen
others users report the same bug but with no answer.

Guess Ill stick to the system stored procedures. Thanks
again

Benoit


[quoted text, click to view]
John Kane
5/17/2004 9:21:10 PM
Benoit,
A couple of additional questions... Are you accessing the server with this
problem via the internet using the EM? Also, how have you registered this
server in the EM via the server name, as an IP address or as a server alias?
If you're using either an IP address or a server alias, could you delete and
re-register the server with the true server's name? and then re-test the
FT-enabled table's properties and confirm if the FT menus are still grayed
out.

Thanks,
John


[quoted text, click to view]

news.microsoft.com
6/30/2004 2:23:49 AM
I ran into this as well. I had my SQL Server registered in EM as (local).
I deleted the registration, and re-registered it as the server name and
everything worked.

Brien King


[quoted text, click to view]

AddThis Social Bookmark Button