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