Adding Full-Text Search Indexing to a Cluster

Ihave an Active/Passive Cluster. Can someone point me to a Technet
article or provide the steps for adding Full-text indexing?
I can't seem to find one!
Thank you.
Jay
SQL FTS has to be installed from the start on a cluster. The SQL Server 2000
High availablilty book is pretty good for installing a cluster.
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Jay,
Could you post the full output of -- SELECT @.@.version -- as this is helpful
in understanding your current clustered environment.
For the time being, I'm going to assume that you have a clustered SQL Server
2000 A/P environment. Correct? If so, then you should be using SQL Server
2000 Enterprise Edition and Full-text Indexing (and Full-text Search, often
referred to as SQL FTS) is installed by default.
You can use the SQL Enterprise Manager and select Server and database, you
want to FT-enable and click on Tools -> Full-text Indexing to launch the FT
Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all the
necessary steps for adding Full-text Indexing to a selected table. Note, the
table, must have a single column, non-nullable, unique index to qualify for
a table to be FT Indexed. Also, the only restriction for FTI in a clustered
environment, is that the FT Catalog, must be created on the shared disk
drive in your clustered environment.
You may also want to do this via pure T-SQL code, and if so, checkout "Full
Text Indexing using T-SQL from a Profiler Trace" at
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
and this blog entry will walk you though all the necessary T-SQL code.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
> Ihave an Active/Passive Cluster. Can someone point me to a Technet
> article or provide the steps for adding Full-text indexing?
> I can't seem to find one!
> Thank you.
> Jay
>
|||Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
Adv Server. Sorry to omit that important information.
Here is my problem -- Full Text indexing is not installed. When I try
to do what you indicated, Full Text Indexing is grayed out.
I was installing some other software which was going to create a
database. It gave the a warning that Full text indexing was not
installed and the software would not function properly.
If I go into the SQL Setup, I can't add/remove components. The only
option I have is to Uninstall. I am wondering how I can add full-text
indexing.
Thanks for your help,
Jay
John Kane wrote:
> Jay,
> Could you post the full output of -- SELECT @.@.version -- as this is
helpful
> in understanding your current clustered environment.
> For the time being, I'm going to assume that you have a clustered SQL
Server
> 2000 A/P environment. Correct? If so, then you should be using SQL
Server
> 2000 Enterprise Edition and Full-text Indexing (and Full-text Search,
often
> referred to as SQL FTS) is installed by default.
> You can use the SQL Enterprise Manager and select Server and
database, you
> want to FT-enable and click on Tools -> Full-text Indexing to launch
the FT
> Indexing Wizard. This wizard (SQLFTWiz.exe) will walk you though all
the
> necessary steps for adding Full-text Indexing to a selected table.
Note, the
> table, must have a single column, non-nullable, unique index to
qualify for
> a table to be FT Indexed. Also, the only restriction for FTI in a
clustered
> environment, is that the FT Catalog, must be created on the shared
disk
> drive in your clustered environment.
> You may also want to do this via pure T-SQL code, and if so, checkout
"Full
> Text Indexing using T-SQL from a Profiler Trace" at
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> and this blog entry will walk you though all the necessary T-SQL
code.[vbcol=seagreen]
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> <jay.griffin@.burke.com> wrote in message
> news:1107212619.013634.8160@.c13g2000cwb.googlegrou ps.com...
|||You're welcome, Jay,
Despite what you see as "Full Text Indexing is grayed out", it is most
likely that Full Text Search (FTS) is installed because of what you see when
you attempt to add the "Full-Text Search" components via SQL Setup and
"custom installation" where the "Full-Text Search" component option is
already checkmarked. Correct?
If the above is not correct, you may have the MSSQLServer service running
under a local machine account, if so, then checkout 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
If the above is correct, then you can force the removal of the checkmark via
the removal or renaming of the following tracking registry key and the
following procedure to Re-install" the "Full-text Search" components via
deleting (or renaming) the below "tracking key" and re-install (If you're
not using a named instance, remove "<Instance_Name>\".)
NOTE: be sure to be logged on to the server as either Administrator or as a
member of the server's Admin Group!
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Once you're done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, please post
these files.
Re-install the service pack that you may have applied to SQL Server 2000, so
that the newly re-installed MSSearch components are upgraded to SP3a levels
and then re-boot &/or restart the MSSearch and MSSQLServer services.
You may also want to consult or perform the procedures document in the
following Kb article: 827449 "How to manually reinstall the Microsoft Search
service for an instance of SQL 2000" at:
http://support.microsoft.com/default...b;EN-US;827449
Finally, and considering that this is a clustered environment, you may also
want to review the following KB articles:
812666 "How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000" at:
http://support.microsoft.com/default.aspx?kbid=812666
"The full-text search results that are returned in a clustered SQL Server
2000 environment may be different when the active node changes" at:
http://support.microsoft.com/default...b;en-us;889708
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107270434.064396.309410@.c13g2000cwb.googlegr oups.com...
> Thanks for your help. It is SQL 2000 Enterprise (A/P) on Windows 2000
> Adv Server. Sorry to omit that important information.
> Here is my problem -- Full Text indexing is not installed. When I try
> to do what you indicated, Full Text Indexing is grayed out.
> I was installing some other software which was going to create a
> database. It gave the a warning that Full text indexing was not
> installed and the software would not function properly.
> If I go into the SQL Setup, I can't add/remove components. The only
> option I have is to Uninstall. I am wondering how I can add full-text
> indexing.
> Thanks for your help,
> Jay
>
> John Kane wrote:
> helpful
> Server
> Server
> often
> database, you
> the FT
> the
> Note, the
> qualify for
> clustered
> disk
> "Full
>
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry
> code.
>
|||Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. =ADThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||You're welcome, Jay,
Ok, so we take 10 yards and punt (to use a football analogy)... Before I ask
you to un-cluster your servers and re-install SQL Server (a big effort, I
know), I want you to confirm something for me.
Is this SQL Server installed on a Domain Controller or a backup DC? As I've
seen problems with FTS working correctly when installed on a DC or BDC and
with MSSQLServer service startup account being the Domain Administrators
account. If it's not on a DC or BDC, but you are using an account that is a
member of the DOMAIN Administrator group, could you create a separate
DOMAIN\Account and add that account to the local server's Administrators
Group and then using the SQL Enterprise Manager's server property security
tab, change the MSSQLServer service startup account to the newly created
DOMAIN\Account. This change should prompt you to stop & re-start SQL Server
and click yes to this prompt. Then close and re-launch the Enterprise
Manager and see if the Full Text Indexing is still grayed out. If it is not
grayed out, then failover to your Passive node and do the same thing there.
As I've said I've seen this before in non-clustered environments where SQL
Server 2000 was installed on a DC or BDC and the MSSQLServer service
startup account being the Domain Administrators account. The solution in
this case was as I described above or resetting the MSSQLServer service
startup account use LocalSystem or as a last resort move the SQL Server off
the DC or BDC.
Let me know if this successful for you, otherwise, the fallback solution is
to un-cluster your servers and re-install SQL Server :-(
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107277007.739900.246620@.z14g2000cwz.googlegr oups.com...
Thanks John.
Clarification from my previous post: "If I go into the SQL Setup, I
can't add/remove components. XThe only option I have is to Uninstall.
" -- ALL other options are grayed out. It is not a matter of them
already being checked. I have no option to check them. It isn't
installed and it won't let me add it.
I am assuming because this is a cluster, components have to be added
differently. Because I have no option to add/remove components under
the custom install. My only option is to Uninstall. (yes - I am
logged in as administrator).
MSSQLServer is running as a domain account and that account is in the
domain admins group.
|||Based on what you are telling me -- I am going to have to uncluster and
re-install. The servers are not a DC. The special user I setup for
the SQL servers is in the local admins group already.
Do you know of any KB articles that would walk me through this without
losing any information?
|||Jay,
Yep, 10 yards & punt... Re-installing a Clustered SQL server is never easy,
but these references may help:
a.. SQL Server 2000 Clustering Whitepaper,
http://www.microsoft.com/SQL/techinf...vercluster.asp
a.. 815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual
Server http://support.microsoft.com/?id=815431
a.. 325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup
http://support.microsoft.com/?id=325485
a.. 274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for
All... http://support.microsoft.com/?id=274446
a.. 254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?id=254321
a.. 243218 INF: Installation Order for SQL Server 2000 Enterprise Edition
http://support.microsoft.com/?id=243218
a.. 260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering http://support.microsoft.com/?id=260758
Hope this helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
<jay.griffin@.burke.com> wrote in message
news:1107354007.277719.324960@.g14g2000cwa.googlegr oups.com...
> Based on what you are telling me -- I am going to have to uncluster and
> re-install. The servers are not a DC. The special user I setup for
> the SQL servers is in the local admins group already.
> Do you know of any KB articles that would walk me through this without
> losing any information?
>
|||John,
Thank you for all your help on this issue.
Jay