Re: Full text help.. anyone?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kane (jt-kane_at_comcast.net)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 18:08:12 -0700

Claudia,
Sorry for the late reply, however, assuming you're installing SQL Server
2000 Enterprise Edition on Windows 2003 Advance or Enterprise servers, Full
Text Search is installed by default. If you're using SQL Server 7.0, then
Full-Text Search is not supported in a clustered environment. Without more
info on what you're looking for, a series of steps, or troubleshooting a
specific error, it's kinda hard to provide relevant info. However, the below
KB articles should give you a good starting point...

KB Articles:
------------
817301 PRB: Microsoft Search Full-Text Catalog Population Fails When You
Upgrade SQL Server 2000 Failover Cluster to SQL Server 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;817301&Product=sql2k

812666 How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;812666&Product=sql2k

304282 (Q304282) PRB: Full Text Resource Fails to Come Online on a Cluster
with "Event ID 1069 :SQL Cluster Resource 'Full Text' failed" Error Message
http://support.microsoft.com/default.aspx?scid=kb;en-us;304282&Product=sql2k

296890 (Q296890) PRB: SQL Server 2000 Fails to Install on a Cluster If
Service Startup Account Contains a Space
http://support.microsoft.com/default.aspx?scid=kb;en-us;296890&Product=sql2k

810056 INF: You Must Use Resource-Specific Registry Keys for SQL Server
Cluster Resources
http://support.microsoft.com/default.aspx?scid=kb;en-us;810056&Product=sql2k

295732 INF: Creating Databases or Changing Disk File Locations on a Shared
Cluster Drive on Which SQL Server 2000 was not Originally Installed
http://support.microsoft.com/default.aspx?scid=kb;en-us;295732&Product=sql2k

260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;260758&Product=sql2k

814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000
Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;814035&Product=sql2k

811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a
Pre-Installation Checklist for SQL Server 2000 Virtual Server for Failover
Clustering
http://support.microsoft.com/default.aspx?scid=kb;en-us;811168&Product=sql2k

243218 Installation order for SQL Server 2000 Enterprise Edition on
Microsoft Cluster Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;243218&Product=sql2k

Regards,
John

"Claudia" <anonymous@discussions.microsoft.com> wrote in message
news:2fbc101c46da9$5bedfac0$a401280a@phx.gbl...
> Can anyone explain me how to configure full text to run on
> a windows 2003 cluster (2 machines 1 sql node)???
>

Relevant Pages

  • Installation fails when creating virtual resource on node
    ... I have spent 2 full days trying to install SQL Server 2000 Failover ... installation will not start the SQL cluster resources and complete. ... options for a single-instance clustered database (virtual server, name, IP, ... Installing a local database and then installing a new ...
    (microsoft.public.sqlserver.clustering)
  • Re: What do I need to cluster SQL under Windows 2003
    ... The Cluster service has another IP address and each Virtual ... SQL Server has yet another IP address. ... Enterprise Edition of SQL is the only edition that has the ability to create ... And when you move a clustered instance from one host to another, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS Monitoring reinstall fails
    ... -- SharePoint instance on SQL Server 2000 SP4 ... Microsoft Data Engine. ... Rerun Setup, and retry installing ...
    (microsoft.public.windows.server.sbs)
  • =?Utf-8?Q?Re:_Dear_Ekrem_=C3=96nsoy?=
    ... you should setup MSCS and add your nodes from Cluster Administrator to your Cluster. ... After installing MSCS and adding your nodes to the Cluster, then you have left one thing to do which is really important. ... After being sure it works perfect then go to the next step which is installing SQL Server. ... Move all services to first Node and then start SQL Server setup. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL2000 Cluster on Windows 2003 SP1 Cluster
    ... There is one special work-around for installing a named instance on a ... Windows 2003 cluster. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)