Search This Blog

Tuesday, September 22, 2009

Manually Add Full Text Search Resource For A SQL Server 2005 Failover Cluster

STEPS TO MANUALLY ADD FTS AS RESOURCE FOR A SQL 2005 FAILOVER CLUSTER
1. Open the SQL Server Configuration Manager (Start -> Programs -> SQL Server 2005 -> Configuration Tools)
2. Check to see that the Full-text service for your instance of SQL Server is actually there. If not, then go ahead with the
installation. Start the Full-text service in Configuration Manager.
3. In the Cluster Administrator, right-click on 'Resources' and choose New -> Resource
4. In the New Resource dialog, choose 'Generic Service' for the type and give it a name like SQL FULLTEXT. Any name is fine.
Choose the desired group for the resource.
5. In the next screen choose the nodes that the Full-Text resource can run on. These should be the same as your SQL Server
resource.
6. In the next screen don't do anything. Full-text search doesn't need any dependencies.
7. In the Generic Service Parameters screen type msftesql$ in the 'Service Name' box, where
is the Virtual Server name for the SQL Server. You can verify this name by opening Services.msc (Start -> Run -> type
'Services.msc' -> OK) and right-clicking on the SQL ServerFulltext Search service and choosing properities. Us the Service
Name in the properties dialog as the Service Name in the New Resource dialog.
8. In the 'Startup Parameters' box, enter the parameters shown in the service property dialog
(Start -> Run -> type 'Services.msc' -> OK -> right-click on SQL ServerFulltext Search service -> choose 'Properties) at the end
of the path in the 'Path to executable' box. For example: -s:MSSQL.2 -f:INST2
9. In the next screen don't do anything. Leave the 'Registry Replication' information blank.
10. Click finish. The Full-text resource should be visible in your SQL Server group in the Cluster Administrator.
11. Test by bringing the Full-text resource online and failing it over to the other node.

I Hope this will help you.
Regards
GURSETHI

No comments: