Full Text Service not starting from EM

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
Benoit
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...;en-us;q270671 this should
explain the problem you are experiencing.
Regards,
John
"Benoit" <anonymous@.discussions.microsoft.com> wrote in message
news:cdae01c43958$fb582660$a101280a@.phx.gbl...
> 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
> Benoit
|||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

>--Original Message--
>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
>
>"Benoit" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:cdae01c43958$fb582660$a101280a@.phx.gbl...
fine[vbcol=seagreen]
now[vbcol=seagreen]
stopped[vbcol=seagreen]
a "an[vbcol=seagreen]
indexes
>
>.
>
|||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
<anonymous@.discussions.microsoft.com> wrote in message
news:d43301c439e0$21c78d40$a001280a@.phx.gbl...[vbcol=seagreen]
> 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
>
> (Q270671) PRB: Full
> Accounts" at
> us;q270671 this should
> message
> fine
> now
> stopped
> a "an
> indexes
|||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
"John Kane" <jt-kane@.comcast.net> wrote in message
news:eJO9aqhOEHA.3896@.TK2MSFTNGP12.phx.gbl...
> 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
>
>
> <anonymous@.discussions.microsoft.com> wrote in message
> news:d43301c439e0$21c78d40$a001280a@.phx.gbl...
>
|||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

>--Original Message--
>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[vbcol=seagreen]
>you can enable your Full Text menus.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"John Kane" <jt-kane@.comcast.net> wrote in message
>news:eJO9aqhOEHA.3896@.TK2MSFTNGP12.phx.gbl...
start & run the[vbcol=seagreen]
exact configuration[vbcol=seagreen]
you re-confirm that[vbcol=seagreen]
>you
server property[vbcol=seagreen]
>security
the system stored[vbcol=seagreen]
server, (see SQL[vbcol=seagreen]
>2000
indexing or removes all[vbcol=seagreen]
text catalog.[vbcol=seagreen]
full-text indexing.[vbcol=seagreen]
indexes.[vbcol=seagreen]
connecting[vbcol=seagreen]
NT[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
etc...[vbcol=seagreen]
grayed[vbcol=seagreen]
tables[vbcol=seagreen]
The[vbcol=seagreen]
administration from
>
>.
>
|||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
"Benoit" <anonymous@.discussions.microsoft.com> wrote in message
news:cdae01c43958$fb582660$a101280a@.phx.gbl...
> 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
> Benoit