"Full-Text Indexing" is Grayed Out, Disabled

I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
database, except when I go into the SQL Server Enterprise Manager and
click on the "Tools" drop down menu in the tool bar, the option
"Full-Text Indexing" is grayed out (aka greyed out).
I think I need to start a service named MSSEARCH; however, when I go
into Start -> Settings -> Control Panel -> Administrative Tools ->
Services, I do not see any service whose name is close to "MSSEARCH".
I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
but the closest I got was an error message stating "Cannot get
full-text default path from registry."
I also installed SQL Server Service Pack 3.
When I execute stored procedure `sp_fulltext_database 'enable'`, I get
this error message:
"Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot be
loaded"
Therefore, how do I get the "Full-Text Indexing" to no longer be
grayed out?
Or, how to I install, start or implement full-text indexing?
Sounds like SQL FTS has not been installed.
Put your SQL Server cd on the cd platter.
double click setup.bat from the cd. click next.
select local computer, click next.
select upgrade, remove, or add components to an existing instance of SQL
Server, click next.
select the instance you wish to add SQL FTS to, click next.
select add components to your existing installation, click next.
In the component section give focus to Server Component (it should be given
focus by default).
In the sub components section, select full text search, click next. click
next, and accept all remaining defaults.
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||C_E,
It is always a good idea to know what SQL Server version as well as Edition
is as the Full-Text Search (FTS) components are not supported on all SQL
Server 2000 Editions. See SQL Server 2000 Books Online (BOL) title "Features
Supported by the Editions of SQL Server 2000" as the "Microsoft Search
(MSSearch.exe) service is installed only with certain SQL Server editions.
Could you post the full output of the following SQL script?
select @.@.version
Installing SQL Server Service Pack 3 alone will not resolve this issue as
you will need to install the FTS components (if supported) and then
re-install SQL Server Service Pack 3 to fix any FTS bugs, issues, etc.
Depending upon the output of the sql script, you may be able to install the
FTS components from your SQL 2000 installation CD via custom installation
and select Full-Text Search under the server components list.
Regards,
John
<charismatic_evangelist@.yahoo.com> wrote in message
news:dd8e1652.0409081147.21b78b87@.posting.google.c om...
> I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000
> database, except when I go into the SQL Server Enterprise Manager and
> click on the "Tools" drop down menu in the tool bar, the option
> "Full-Text Indexing" is grayed out (aka greyed out).
> I think I need to start a service named MSSEARCH; however, when I go
> into Start -> Settings -> Control Panel -> Administrative Tools ->
> Services, I do not see any service whose name is close to "MSSEARCH".
> I also tried `sqlftwiz` (SQL Full-Text Wizard) with several options,
> but the closest I got was an error message stating "Cannot get
> full-text default path from registry."
> I also installed SQL Server Service Pack 3.
> When I execute stored procedure `sp_fulltext_database 'enable'`, I get
> this error message:
> "Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
> Line 46
> Full-Text Search is not installed, or a full-text component cannot be
> loaded"
> Therefore, how do I get the "Full-Text Indexing" to no longer be
> grayed out?
> Or, how to I install, start or implement full-text indexing?
|||Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
tried the steps that you gave below. The instance of the Server that I
applied it to was the (local)(Windows NT) server, where my database resides.
Even after going through all the steps, and having turned SQL FTS on, the
full text search is still greyed out when I right click on the particular
table I need to be able to search. Any other ideas of what to do?
- MacL
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Sounds like SQL FTS has not been installed.
> Put your SQL Server cd on the cd platter.
> double click setup.bat from the cd. click next.
> select local computer, click next.
> select upgrade, remove, or add components to an existing instance of SQL
> Server, click next.
> select the instance you wish to add SQL FTS to, click next.
> select add components to your existing installation, click next.
> In the component section give focus to Server Component (it should be
> given
> focus by default).
> In the sub components section, select full text search, click next. click
> next, and accept all remaining defaults.
>
|||Mac,
While you may have the same *symptoms* as Charismatic_Evangelist, you may or
may not have the same problem, especially as s/he never provided his/her SQL
Server 2000 version & edition info. It is always a good idea to know what
SQL Server version as well as Edition is as the Full-Text Search (FTS)
components are not supported on all SQL Server 2000 Editions. See SQL Server
2000 Books Online (BOL) title "Features Supported by the Editions of SQL
Server 2000" as the "Microsoft Search (MSSearch.exe) service is installed
only with certain SQL Server editions. Could you post the full output of the
following SQL script?
select @.@.version
You should also review 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 depending
upon how you have the MSSQLServer service startup account setup.
If you did recently upgrade or install the FTS components, could you also
attach the following SQL setup log files: sqlstp.log (usually located at
C:\WINNT\Temp) and SearchSetup.log usually located at C:\WINNT\. These files
can also help in troubleshooting FTS installation issues.
Regards,
John
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:#Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>
|||There can be serveral causes of the Full-Text Index Table menu option not
being enabled
a.. SQL FTS is not enabled on this SQL server. Click here for instructions
on how to install SQL FTS on your SQL Server.
a.. You are not in the dbo role for this database
a.. The System Administrator role is not in the Local Administrators group
for this machine or the NTAuthority\Logon group is not in the System
Administrators group.
If you remove BUILTIN\Administrators and Full Text is enabled, add a login
account for the Local System account using sp_grantlogin [NT
Authority\System], and ensure that the login account is a member of the
sysadmin fixed server role. Here is some sample TSQL code to do this:
if not exists (select * from master.dbo.syslogins where loginname = N'NT
Authority\System')
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System', N'us_english'
GO
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
GO
a.. Something else yet undetermined. Microsoft acknowledges this problem in
this kb article
(http://support.microsoft.com/default...1&Product=sql2
k) and recommends that you use the full text stored procedures to manage
your catalog or tables.
When I run across this problem (I don't run across is often as typically I
use the full text stored procedures) I normally use the SQLFTSWiz.exe
program which can be found by default in: C:\Program Files\Microsoft SQL
Server\80\Tools\Binn you can launch it by opening a command prompt and
typing for NT Authentication:
sqlftwiz /n /sSQLServerName[\InstanceName] /dpubs
or for SQL Authentication:
sqlftwiz /sSQLServerName[\InstanceName] /dpubs /uAccount /pPassword
In both of the above examples, SQLServerName[\InstanceName] is the name of
the SQL Server you wish to connect to. If you are using the default instance
you would use the below:
sqlftwiz /sSQLServerName /dpubs /uAccount /pPassword
If you are using an instance, other than the default instance you would use
the below (where InstanceName is the name of the instance you are using):
sqlftwiz /sSQLServerName\InstanceName /dpubs /uAccount /pPassword
Pubs is the database you wish to create your full text table in.
The dialogs you get are for the most part identical to the dialogs you would
get if you were to just right click on a table. After the initial splash
screen select the table you wish to index. The rest of the dialogs are
identical to the dialogs you will see if you were to right click on a table
in EM and select Full Text Index table.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mac Littlefield" <warrenlittlefield@.sbcglobal.net> wrote in message
news:%23Ai13dnpEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Given that I had the same problem as charismatic_evangelist@.yahoo.com, I
> tried the steps that you gave below. The instance of the Server that I
> applied it to was the (local)(Windows NT) server, where my database
resides.[vbcol=seagreen]
> Even after going through all the steps, and having turned SQL FTS on, the
> full text search is still greyed out when I right click on the particular
> table I need to be able to search. Any other ideas of what to do?
> - MacL
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ukjtrBglEHA.2764@.TK2MSFTNGP11.phx.gbl...
click
>