 |
|
|
|
Next: HTML word breaker
|
| Author |
Message |
External
Since: May 17, 2004
Posts: 3
|
(Msg. 1) Posted: Thu May 13, 2004 10:13 pm
Post subject: Full Text Service not starting from EM
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
|
|
|
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 |
|
| Back to top |
|
 | |
External
Since: Mar 02, 2004
Posts: 499
|
(Msg. 2) Posted: Thu May 13, 2004 11:09 pm
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Benoit,
You should checkout the following KB article "Q270671 (Q270671) PRB: Full
Text Search Menus Are Not Enabled for Local Windows NT Accounts" at
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671" target="_blank">http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671</a> this should
explain the problem you are experiencing.
Regards,
John
"Benoit" wrote in message
> 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 |
|
| Back to top |
|
| |
External
Since: Oct 22, 2003
Posts: 589
|
(Msg. 3) Posted: Fri May 14, 2004 2:20 pm
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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
>
>
>
message
>> 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
>
>
>.
> >> Stay informed about: Full Text Service not starting from EM |
|
| Back to top |
|
| |
External
Since: Mar 02, 2004
Posts: 499
|
(Msg. 4) Posted: Fri May 14, 2004 9:16 pm
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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
wrote in message
> 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
> >
> >
> >
> message
> >> 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
> >
> >
> >.
> > >> Stay informed about: Full Text Service not starting from EM |
|
| Back to top |
|
| |
External
Since: Mar 14, 2004
Posts: 470
|
(Msg. 5) Posted: Sun May 16, 2004 11:22 am
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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?
<a rel="nofollow" style='text-decoration: none;' href="http://www.nwsu.com/0974973602.html" target="_blank">http://www.nwsu.com/0974973602.html</a>
"John Kane" wrote in message
> 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
>
>
>
>
> > 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
> > >
> > >
> > >
> > message
> > >> 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
> > >
> > >
> > >.
> > >
>
> >> Stay informed about: Full Text Service not starting from EM |
|
| Back to top |
|
| |
External
Since: Oct 22, 2003
Posts: 589
|
(Msg. 6) Posted: Mon May 17, 2004 4:31 pm
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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
>you can enable your Full Text menus.
>
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>
>> 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
>>
>>
>>
>>
>> > 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
>> > >
>> > >
>> > >
in
>> > message
>> > >> 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
>> > >
>> > >
>> > >.
>> > >
>>
>>
>
>
>.
> >> Stay informed about: Full Text Service not starting from EM |
|
| Back to top |
|
| |
External
Since: Mar 02, 2004
Posts: 499
|
(Msg. 7) Posted: Tue May 18, 2004 12:21 am
Post subject: Re: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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
wrote in message
> 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
> >you can enable your Full Text menus.
> >
> >--
> >Hilary Cotter
> >Looking for a book on SQL Server replication?
> >http://www.nwsu.com/0974973602.html
> >
> >
> >> 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
> >>
> >>
> >>
> >>
> >> > 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
> >> > >
> >> > >
> >> > >
> in
> >> > message
> >> > >> 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
> >> > >
> >> > >
> >> > >.
> >> > >
> >>
> >>
> >
> >
> >.
> > >> Stay informed about: Full Text Service not starting from EM |
|
| Back to top |
|
| |
External
Since: Feb 09, 2010
Posts: 1
|
(Msg. 8) Posted: Tue Feb 09, 2010 9:25 am
Post subject: RE: Full Text Service not starting from EM [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
| Related Topics: | Full-Text Limitation in SQL 2000? - Hello, Is there a limit to the number of databases on a single SQL Server that can be Full-Text enabled? I have 15 databases all with Full-Text search working fine. Now I just made a 16th database and enabled Full-Text in the usuall manner and nothing..
Can Full Text Searching do this???? - 1. Create a robust search engine able searching of information across all types of content. 2. Support Open Search specification 3. content indexer applying A-Z indexing model and establish keyword metadata references. 4. performs naive Bayes..
periods in full text - Hello - We are using: Windows Server 2003 SP2 SQL Server 2000 SP2 Data is stored using periods such as 12.XT.1234.1 I realize that the . is a punctuation, but how exatly does it search for this when I use the following contains query: select count(*)...
FULL TEXT SEARCH PROBLEM - I have a table which has a record T17.1.516.32 I try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' ) )) it returns T17.1.516.32 i try SELECT Urun_Ad as guUrun_Ad FROM TBL_URUNLER WHERE (..
Full text index - migration - What is the easiest way to migrate full text indexes from SQL2K to SQL2K5? |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
