Full-Text Search is not installed, or a full-text component cannot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shima - 11 Jan 2006 11:30 GMT

Active-active cluster. The second node was reinstalled after a hardware
failure.
The MS Search service is started.
But when I try to query full-text the error message shows up:
Server: Msg 7609, Level 17, State 1, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

How can I reinstall full-text on cluster environment without affect the node
is working ?

thank you
Shimon

Reply to this Message

Hilary Cotter - 11 Jan 2006 16:55 GMT

I believe you need to evict this node from the cluster, reinstall SQL Server
there and then upgrade it to add it back to the cluster. I have forwarded
this to microsoft.public.sqlserver.clustering for their response to this, as
this is really a clustering question.

Signature

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

> Active-active cluster. The second node was reinstalled after a hardware
> failure.
[quoted text clipped - 10 lines]
> thank you
> Shimon

Reply to this Message

Geoff N. Hiten - 11 Jan 2006 19:59 GMT

When you evict a node from a cluster and replace it, you must also clean the
node from the SQL installation. Run the SQL installer and remove the old
node. Then you can re-add it to SQL, which will also re-install full-text.
Don't forget to reapply any service packs and hotfixes to the new node.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I believe you need to evict this node from the cluster, reinstall SQL
>Server there and then upgrade it to add it back to the cluster. I have
[quoted text clipped - 15 lines]
>> thank you
>> Shimon

Reply to this Message

Z - 11 Jan 2006 20:50 GMT

Any time you need to rebuild a piece of hardware in a cluster, it should be
evicted. You need to run SQL Server setup to evict it from the SQL Server
piece of the cluster and then you need to evict the node from the cluster.
Once you add the node back into the cluster, you then need to run SQL Server
setup again to add the node back in for SQL Server. That operation will
reinstall all of the software components.

>I believe you need to evict this node from the cluster, reinstall SQL
>Server there and then upgrade it to add it back to the cluster. I have
[quoted text clipped - 15 lines]
>> thank you
>> Shimon

Reply to this Message

Shima - 12 Jan 2006 15:56 GMT

Thank you for the informatios.
The Node B is ok. I've already reinstalled SQLServer, sp3 and hot fix. My
problem is only with FullText. Is there some way to reinstall full text
without reinstall all sqlserver ?

> Any time you need to rebuild a piece of hardware in a cluster, it should be
> evicted. You need to run SQL Server setup to evict it from the SQL Server
[quoted text clipped - 22 lines]
> >> thank you
> >> Shimon

Reply to this Message

Shima - 24 Jan 2006 13:53 GMT

The problem was solved running ftsetup on 2 nodes without "evict", "reinstall
SQL" or whatever...

> Thank you for the informatios.
> The Node B is ok. I've already reinstalled SQLServer, sp3 and hot fix. My
[quoted text clipped - 27 lines]
> > >> thank you
> > >> Shimon

Reply to this Message