Full Text Indexing Option Disabled

I have recently installed Full Text search component using the SQL 2000
Server CD, but still the Full Text Indexing option is disabled under Tools in
SQL 2000 Enterprise manager. Also I don't get Full Text Search option under
Support Services in Enterprise Manager. Although I am getting Microsoft
Search Services under Services. I am using SQL 2000 Server Standard Edition
with Windows 2000 Server. What could be the problem. I am also running
Commerce Server on the same. What could be the reason? pls help...
Thanks & Regards
Mitul Z
Mitul Z,
Could you post the full output of -- SELECT @.@.version -- on the server where
you recently did a custom install of Full Text Search? This is very helpful
information necessary to troubleshoot FTS issues like this one.
Additionally, SQL 2000 Server Standard Edition install the Full-text Search
components by default, so you should not of had to re-install it via the
"custom installation" from your SQL Server 2000 CD. Furthermore, I *believe*
that Commerce Server which also uses SQL Server 2000 installs and utilizes
the FTS components as well. So, SQL FTS should of been installed and
functional on this server.
However, what may be at issue (unless the re-installation caused further
problems) is how you have the SQL Server service (MSSQLServer) started and
what account it is started under. Are you using a DOMAIN\Account or the
"System account" (LocalSystem) to start and run the MSSQLServer service? If
not these, are you using local machine accounts? If so, then you may want to
review the following KB article: Q270671 (Q270671) "PRB: Full Text Search
Menus Are Not Enabled for Local Windows NT Accounts"
http://support.microsoft.com/default...;en-us;q270671
Finally, can you confirm that no one has recently changed the startup
account &/or password for the MSSQLServer service via Win2K's Component
Service vs. the Enterprise Manager? If so, then you will want to review the
following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default...b;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
Hope this helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Mitul Z" <Mitul Z@.discussions.microsoft.com> wrote in message
news:750FAA48-B51F-4815-9DF5-B90D742F9A37@.microsoft.com...
> I have recently installed Full Text search component using the SQL 2000
> Server CD, but still the Full Text Indexing option is disabled under Tools
in
> SQL 2000 Enterprise manager. Also I don't get Full Text Search option
under
> Support Services in Enterprise Manager. Although I am getting Microsoft
> Search Services under Services. I am using SQL 2000 Server Standard
Edition
> with Windows 2000 Server. What could be the problem. I am also running
> Commerce Server on the same. What could be the reason? pls help...
> Thanks & Regards
> Mitul Z
|||open up a command prompt.
go to c:\Program Files\Microsoft SQL Server\80\Tools\binn
Type SQLFTWiz /n /s.
Note that you need the period after the s.
This should launch the SQL FTS Wizard. There are cases where you account or
your cached credentials doesn't have permission to modify the SQL FTS
components. In cases like this you can use the wizard.
To launch a full population right click on your catalog or use
sp_fulltext_catalog 'catalogname','start_full' in query analyzer. You will
have to be in the database to do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mitul Z" <Mitul Z@.discussions.microsoft.com> wrote in message
news:750FAA48-B51F-4815-9DF5-B90D742F9A37@.microsoft.com...
> I have recently installed Full Text search component using the SQL 2000
> Server CD, but still the Full Text Indexing option is disabled under Tools
in
> SQL 2000 Enterprise manager. Also I don't get Full Text Search option
under
> Support Services in Enterprise Manager. Although I am getting Microsoft
> Search Services under Services. I am using SQL 2000 Server Standard
Edition
> with Windows 2000 Server. What could be the problem. I am also running
> Commerce Server on the same. What could be the reason? pls help...
> Thanks & Regards
> Mitul Z
|||our firewall blocks some of the things enterprise manager needs to
determine whether or not fulltext search is running or not so i have to
log onto the server locally before the fulltext options are available.
Mitul Z wrote:
> I have recently installed Full Text search component using the SQL 2000
> Server CD, but still the Full Text Indexing option is disabled under Tools in
> SQL 2000 Enterprise manager. Also I don't get Full Text Search option under
> Support Services in Enterprise Manager. Although I am getting Microsoft
> Search Services under Services. I am using SQL 2000 Server Standard Edition
> with Windows 2000 Server. What could be the problem. I am also running
> Commerce Server on the same. What could be the reason? pls help...
> Thanks & Regards
> Mitul Z
|||Ch,
If your firewall prevents the Enterprise Manager from working, can you use
the following T-SQL code from the Query Analyzer?
. sp_fulltext_database -- Initializes full-text indexing or removes
all full-text catalogs from the current database.
. sp_fulltext_catalog -- Creates and drops a full-text catalog.
. sp_fulltext_table -- Marks or unmarks a table for full-text
indexing.
. sp_fulltext_column -- Adds columns to full-text indexes.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"ch" <ch@.dontemailme.com> wrote in message
news:42232FE1.C90CCA59@.dontemailme.com...[vbcol=seagreen]
> our firewall blocks some of the things enterprise manager needs to
> determine whether or not fulltext search is running or not so i have to
> log onto the server locally before the fulltext options are available.
>
> Mitul Z wrote:
Tools in[vbcol=seagreen]
under[vbcol=seagreen]
Edition[vbcol=seagreen]
|||firewall doesn't stop EM from working, it only stops the fulltext things
in EM from working. for my servers inside the firewall, the fulltext
options are available in EM.
i can connect in QA and run the things below, but it's far easier to log
onto the server and use EM.
John Kane wrote:[vbcol=seagreen]
> Ch,
> If your firewall prevents the Enterprise Manager from working, can you use
> the following T-SQL code from the Query Analyzer?
> . sp_fulltext_database -- Initializes full-text indexing or removes
> all full-text catalogs from the current database.
> . sp_fulltext_catalog -- Creates and drops a full-text catalog.
> . sp_fulltext_table -- Marks or unmarks a table for full-text
> indexing.
> . sp_fulltext_column -- Adds columns to full-text indexes.
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
> "ch" <ch@.dontemailme.com> wrote in message
> news:42232FE1.C90CCA59@.dontemailme.com...
> Tools in
> under
> Edition

Full Text Indexing Option Disabled

i, like hundreds of other people, am unable to use the Full Text indexing
feature because of the bug in SQL Server Enterprise Manager that disables
the ability to configure it.
See the Microsoft Knowledge Base article, but realize that it doesn't apply.
http://support.microsoft.com/?kbid=270671
It suggests that the problem is due to being logged onto your client
computer using a local account. It implies that because the account is local
to your computer (as opposed to being a domain account), you are not able to
query the state of the MSSearch service on the target SQL Server machine.
When Enterprise Manager is unable to query the state of the MSSearch on the
target SQL Server machine, it assumes the MSSearch service on the target SQL
Server machine is either disabled or not installed - and therefore prevents
you from configuring Full-Text indexing.
Problem is, we are not logged on using a local account; we are logged on
using a domain account. What is more, the domain account we are using is a
domain administrative account - the account has full ability to query state
of services on the remote SQL Server machine.
The we are experiencing has nothing to do with logging onto the client
computer using a local account. So what does it have to do with? What should
the knowledge base article say about this problem? What is the actual
problem?
i know this bug was introduced in Enterprise Manager with 2000sp2. Does
anyone know if this will be fixed in an upcoming service pack?
References:
http://support.microsoft.com/?kbid=270671
http://tinyurl.com/2wseqa
http://tinyurl.com/2mj8aj
http://tinyurl.com/3aqhea
http://tinyurl.com/35gf54
http://tinyurl.com/384wq7
http://tinyurl.com/3bmnab
http://tinyurl.com/2spgfq
http://tinyurl.com/3df22d
Keywords:
SQL Server Enterprise Manager Full-Text Indexing option disabled grayed out
greyed out "Full-Text Indexing..." full text indexing disabled sqlem, cannot
configure full text, fulltext disabled, fulltext indexing feature disabled,
howto configure fulltext indexing menu item disabled
did you try this?
http://www.indexserverfaq.com/TableNotEnabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:OQDnYS1RHHA.488@.TK2MSFTNGP06.phx.gbl...
> i, like hundreds of other people, am unable to use the Full Text indexing
> feature because of the bug in SQL Server Enterprise Manager that disables
> the ability to configure it.
> See the Microsoft Knowledge Base article, but realize that it doesn't
> apply.
> http://support.microsoft.com/?kbid=270671
>
> It suggests that the problem is due to being logged onto your client
> computer using a local account. It implies that because the account is
> local to your computer (as opposed to being a domain account), you are not
> able to query the state of the MSSearch service on the target SQL Server
> machine. When Enterprise Manager is unable to query the state of the
> MSSearch on the target SQL Server machine, it assumes the MSSearch service
> on the target SQL Server machine is either disabled or not installed - and
> therefore prevents you from configuring Full-Text indexing.
> Problem is, we are not logged on using a local account; we are logged on
> using a domain account. What is more, the domain account we are using is a
> domain administrative account - the account has full ability to query
> state of services on the remote SQL Server machine.
> The we are experiencing has nothing to do with logging onto the client
> computer using a local account. So what does it have to do with? What
> should the knowledge base article say about this problem? What is the
> actual problem?
> i know this bug was introduced in Enterprise Manager with 2000sp2. Does
> anyone know if this will be fixed in an upcoming service pack?
> References:
> http://support.microsoft.com/?kbid=270671
> http://tinyurl.com/2wseqa
> http://tinyurl.com/2mj8aj
> http://tinyurl.com/3aqhea
> http://tinyurl.com/35gf54
> http://tinyurl.com/384wq7
> http://tinyurl.com/3bmnab
> http://tinyurl.com/2spgfq
> http://tinyurl.com/3df22d
> Keywords:
> SQL Server Enterprise Manager Full-Text Indexing option disabled grayed
> out greyed out "Full-Text Indexing..." full text indexing disabled sqlem,
> cannot configure full text, fulltext disabled, fulltext indexing feature
> disabled, howto configure fulltext indexing menu item disabled
>
>
|||Hello Ian,
Its not just permissions but also firewalls that can get in the way. I have
this and am pretty sure it was looking at my local machine.
Run EM on the server itself should allow you to create your indexes.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> i, like hundreds of other people, am unable to use the Full Text
> indexing feature because of the bug in SQL Server Enterprise Manager
> that disables the ability to configure it.
> See the Microsoft Knowledge Base article, but realize that it doesn't
> apply. http://support.microsoft.com/?kbid=270671
> It suggests that the problem is due to being logged onto your client
> computer using a local account. It implies that because the account is
> local to your computer (as opposed to being a domain account), you are
> not able to query the state of the MSSearch service on the target SQL
> Server machine. When Enterprise Manager is unable to query the state
> of the MSSearch on the target SQL Server machine, it assumes the
> MSSearch service on the target SQL Server machine is either disabled
> or not installed - and therefore prevents you from configuring
> Full-Text indexing.
> Problem is, we are not logged on using a local account; we are logged
> on using a domain account. What is more, the domain account we are
> using is a domain administrative account - the account has full
> ability to query state of services on the remote SQL Server machine.
> The we are experiencing has nothing to do with logging onto the client
> computer using a local account. So what does it have to do with? What
> should the knowledge base article say about this problem? What is the
> actual problem?
> i know this bug was introduced in Enterprise Manager with 2000sp2.
> Does anyone know if this will be fixed in an upcoming service pack?
> References:
> http://support.microsoft.com/?kbid=270671
> http://tinyurl.com/2wseqa
> http://tinyurl.com/2mj8aj
> http://tinyurl.com/3aqhea
> http://tinyurl.com/35gf54
> http://tinyurl.com/384wq7
> http://tinyurl.com/3bmnab
> http://tinyurl.com/2spgfq
> http://tinyurl.com/3df22d
> Keywords:
> SQL Server Enterprise Manager Full-Text Indexing option disabled
> grayed out
> greyed out "Full-Text Indexing..." full text indexing disabled sqlem,
> cannot
> configure full text, fulltext disabled, fulltext indexing feature
> disabled,
> howto configure fulltext indexing menu item disabled
|||> did you try this?
> http://www.indexserverfaq.com/TableNotEnabled.htm
Yes.
|||> Its not just permissions but also firewalls that can get in the way. I
> have this and am pretty sure it was looking at my local machine.
The windows firewall is not enabled on my Windows XP SP2 machine. The server
is Windows 2000.

> Run EM on the server itself should allow you to create your indexes.
This, oddly enough, works.
Thank you.
|||Ian,
Make sure your polling interval is turned on in EM. To do this,
select Tools --> Options... and check the box for "Server state
polling".
If polling is not on, EM can't check to see if the MS Search service
is running. This results in the options being grayed out.
This only works on the server where SQL Server is intalled. As a
general rule, I turn this off for client machines, as it generates a
lot of network traffic, especially if you have a bunch of servers
defined in EM.
Hope this works. I spent days following all the instructions out
there from MS and the groups. Finally figured it out after comparing
registry entries for a server that worked and one that didn't.
Rick
On Feb 4, 3:29 pm, Simon Sabin <SimonSa...@.noemail.noemail> wrote:
> Hello Ian,
> Its not just permissions but also firewalls that can get in the way. I have
> this and am pretty sure it was looking at my local machine.
> Run EM on the server itself should allow you to create your indexes.
> Simon Sabin
> SQL Server MVPhttp://sqlblogcasts.com/blogs/simons
>
>
>
>
>
> - Show quoted text -

Full Text Indexing Option Disabled

i can again/still/no longer manage full-text indexes on SQL Server.
i'm logged on locally to my server, as an administrator. EM is set to poll
the server.
Has anyone written a gui to manage SQL Server free-text indexing?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:uG7DGLVXHHA.4520@.TK2MSFTNGP06.phx.gbl...
>i can again/still/no longer manage full-text indexes on SQL Server.
> i'm logged on locally to my server, as an administrator. EM is set to poll
> the server.
>
> Has anyone written a gui to manage SQL Server free-text indexing?
>
|||Have you tried this? It works for me every time.
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlftzwiz.exe
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:uG7DGLVXHHA.4520@.TK2MSFTNGP06.phx.gbl...
>i can again/still/no longer manage full-text indexes on SQL Server.
> i'm logged on locally to my server, as an administrator. EM is set to poll
> the server.
>
> Has anyone written a gui to manage SQL Server free-text indexing?
>
|||> Have you tried this?>

> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlftzwiz.exe
Do you know which tool is used to maintain a full-text catalog / enable
disable table / start stop automatic-change tracking / start top incremental
population / start stop full population / see what databases/tables/columns
are being FT indexed / view/edit the work breaker set on a column / etc?
|||Under the covers some procs are used in SQL 2000, in SQL 2005 its moved into
the engine.
In SQL 2000 in some of the earlier versions you could use some of the com
components to manage parts of it. Have a look at ssadmin.vbs in
C:\Program Files\Common Files\System\MSSearch\Bin
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ian Boyd" <ian.msnews010@.avatopia.com> wrote in message
news:ONMJiglYHHA.2320@.TK2MSFTNGP03.phx.gbl...
>
> Do you know which tool is used to maintain a full-text catalog / enable
> disable table / start stop automatic-change tracking / start top
> incremental population / start stop full population / see what
> databases/tables/columns are being FT indexed / view/edit the work breaker
> set on a column / etc?
>