Friday, February 24, 2012

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

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
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.
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
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:F1A440E4-2781-408A-B7CE-356968CDCF13@.microsoft.com...
> 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
|||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.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23sOoM$sFGHA.3176@.TK2MSFTNGP12.phx.gbl...
>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.
> --
> 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
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:F1A440E4-2781-408A-B7CE-356968CDCF13@.microsoft.com...
>
|||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.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23sOoM$sFGHA.3176@.TK2MSFTNGP12.phx.gbl...
>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.
> --
> 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
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:F1A440E4-2781-408A-B7CE-356968CDCF13@.microsoft.com...
>

No comments:

Post a Comment