Microsoft KB Archive/812666

From BetaArchive Wiki

PSS ID Number: 812666

Article Last Modified on 4/13/2005


The information in this article applies to:

  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit


Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



IN THIS TASK

SUMMARY

This article describes how to recover a full-text search resource that has failed on a clustered instance of Microsoft SQL Server 2000. To recover the full-text search resource, you must remove it and then re-create it. You must also reinstall the full-text search service on the clustered instance of SQL Server without affecting the instance of SQL Server.

back to the top

Remove the failed full-text search resource

To remove the failed full-text search resource from your clustered instance of SQL Server, follow these steps:

  1. Start Cluster Administrator on the node that has the failed full-text search resource.
  2. Use Cluster Administrator to locate and delete the failed full-text search resource.
  3. Delete the registry keys that are related to the instance of SQL Server where the full-text search will be reinstalled. To do so, follow these steps.

    Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
    1. Click Start, and then click Run.
    2. In the Run dialog box, type regedit in the Open box, and then click OK.
    3. In Registry Editor, locate and then click the following registry key:

      HKEY_LOCAL_MACHINE\Software\Microsoft\Search\Install\Applications

    4. In the right pane, delete the registry values that have the same name as your instance of SQL Server. For a default instance of SQL Server, the registry value is named SQLServer. For a named instance of SQL Server, the registry value is named SQLServer$Instance Name.

back to the top

Identify the required resources

To recover the full-text search service on the clustered instance of SQL Server, you must identify the following resources:

  • Identify the method that you used to install SQL Server. You must have access to the SQL Server setup files to install the full-text search service. Therefore, if you installed SQL Server on your computer by using the CD-ROM, make sure that the CD-ROM is available.

back to the top

Reinstall the full-text search service

To reinstall the full-text search service, follow these steps:

  1. Use the Searchstp.exe program to install the full-text search service. If the full-text search service is not installed on the computer, the Searchstp.exe program will create it.
  2. Use the Ftsetup.exe program to configure the full-text search service and to configure the instance of SQL Server as an application that uses the full-text search service. On SQL Server clusters, the Ftsetup.exe program also creates the required configuration files to maintain the failover properties for the full-text search resource. The Ftsetup.exe program uses the following parameter options:
    • ApplicationName: For a default instance of SQL Server, the parameter value must be SQLServer. For a named instance of SQL Server, the parameter value must be SQLServer\Instance Name.
    • User: For a local system account, the parameter value must be 0. For a domain user account, the value of the parameter must be Domain Name\User Account.
    • IsMasterNode: This parameter indicates whether the Ftsetup.exe program runs on the node that owns the disk where the FTDATA folder will be created. The parameter value must be 0 or 1.
    • IsUpgrade: This parameter indicates whether the FtSetup.exe program is upgrading the full-text search service to a later version. This parameter value must be 0 or 1.
    • IsCluster: This parameter indicates whether the Ftsetup.exe program runs on a clustered instance of SQL Server. For a stand-alone instance of SQL Server, the parameter value must be 0. For a clustered instance of SQL Server, the parameter value must be 1.
    • IsUninstall: This parameter indicates whether the Ftsetup.exe program removes the full-text search service. If the Ftsetup.exe program installs the full-text search service, the parameter value must be 0. If the Ftsetup.exe program removes the full-text search service, the parameter value must be 1. However, if the parameter value is 1, the values for the IsMasterNode parameter, the IsUpgrade parameter, and the IsCluster parameter must all be set to 0.

back to the topback to the top

Re-create the full-text search resource

To re-create the full-text search resource on your clustered instance of SQL Server, follow these steps.

On the node of the SQL Server cluster that owns the disks and the resource groups

  1. In Cluster Administrator, bring the SQL Server resource online.
  2. Create a command file named Installsearch.cmd to run on the node of the SQL Server cluster that owns the disks and the resource groups. To do so, follow these steps:
    1. Click Start, and then click Run.
    2. In the Run dialog box, type notepad.exe in the Open box, and then click OK.

    3. Add the following commands to the text file (where Full path of SQL Server Setup files is the path of the setup files that were used to install the instance of SQL Server):

      "Full path of SQL Server Setup files\x86\FullText\MSSearch\Search\SearchStp.exe"
                     /s /a:SQLServer[$Instance name]

"Full path of SQL Server Setup\x86\FullText\ftsetup.exe" SQLServer[$Instance name]
                     Domain name\User account 1 0 1 0

      Note For a default instance of SQL Server, remove [$Instance name]. For a named instance of SQL Server, replace [$Instance name] with the name of the instance of SQL Server.

    4. Save the file as installsearch.cmd.

  3. At a command prompt, run the following command:

    Full path of the Installsearch.cmd file  > installsearch.out

    Note After you run the command, you must wait for the disk activities and the network activities to stop. If the command runs successfully, a subfolder named SQLServer$Instance name is created in the FTDATA folder on the shared drive.

  4. Use Cluster Administrator to create the full-text search resource. To do so, follow these steps:
    1. Start Cluster Administrator on the node where the virtual server group is located.
    2. On the File menu, point to New, and then click Resource.
    3. In the New Resource dialog box, add a new resource with the following properties:
      • Set the value of the Name property to Full-text search.
      • Leave the value of the Description property blank.
      • Set the value of the Resource Type property to Microsoft Search Service Instance.
      • Set the value of the Group property to Virtual server group where the resource will be created.
    4. Click Next.
    5. On the Possible Owners page, click the appropriate nodes, and then click Next.
    6. On the Dependencies page, move the SQL Server resource from the Available Resources list to the Resource Dependencies list.
    7. Click Finish.
    8. Right-click the full-text search resource, and then click Properties.
    9. In the Full-Text Search Properties dialog box, click the Advanced tab.
    10. Under Restart, click to clear the Affect the group check box.
    11. Click Apply, and then click OK.
  5. Create registry values named ApplicationName and ApplicationPath for the full-text search resource that you created in step 4. To do so, follow these steps:
    1. Click Start, and then click Run.
    2. In the Run dialog box, type regedit, and then click OK.
    3. In Registry Editor, locate the registry key for the full-text search resource. To do so, view the Name value for each resource under the following registry key:

      HKEY_LOCAL_MACHINE\CLUSTER\Resources

      Note Registry keys that correspond to all cluster resources are identified by their GUIDs.
    4. Expand the registry key for the full-text search resource, and then click the Parameters registry key.
    5. Use the following information to add a registry value to the Parameters registry key for the full-text search resource:
      • Name: ApplicationName
      • Type: REG_SZ
      • Value: For a named instance of SQL Server, the value is SQLServer$Instance name (where Instance name is the name of the instance of SQL Server that is being used.) For a default instance of SQL Server, the value is SQLServer.
    6. Use the following information to add a registry value to the Parameters registry key for the full-text search resource:
      • Name: ApplicationPath
      • Type: REG_SZ
      • Value: The full path of the folder that contains the full-text data files. For a named instance of SQL Server, the value ends in MSSQL$Instance name\FTDATA. For a default instance of SQL Server, the value ends in MSSQL\FTDATA.
  6. Use Cluster Administrator to bring the full-text search resource online.

    Note If the cluster resource successfully comes online, a file that is named Clust*.* is created in the FTDATA folder.

On the node of the SQL Server cluster that does not own the disks and the resource groups

  1. Use Cluster Administrator to take the full-text search resource offline. Do not move the group to the other node, because that would change the parameters that have to be passed in the following steps.
  2. Create a file named Installsearch.cmd for the node of the SQL Server cluster that does not own the resource groups. To do so, follow these steps:
    1. Click Start, and then click Run.
    2. In the Run dialog box, type notepad.exe in the Open box, and then click OK.

    3. Add the following commands to the text file (where Full path of SQL Server Setup files is the path of the setup files that were used to install the instance of SQL Server):

      "Full path of SQL Server Setup files\x86\FullText\MSSearch\Search\SearchStp.exe"
                     /s /a:SQLServer[$Instance name]

"Full path of SQL Server Setup files\x86\FullText\ftsetup.exe" SQLServer[$Instance name]
                     Domain name\User account 0 0 1 0

      Note For a default instance of SQL Server, remove [$Instance name]. For a named instance of SQL Server, replace [$Instance name] with the name of the instance of SQL Server.

    4. Save the file as installsearch.cmd.

  3. At a command prompt, run the following command:

    Full path of the Installsearch.cmd file  > installsearch.out

    Note After you run the command, you have to wait for the disk activities and the network activities to stop.

  4. Create registry values named ApplicationName and ApplicationPath for the full-text search resource. To do so, follow these steps:
    1. Click Start, and then click Run.
    2. In the Run dialog box, type regedit, and then click OK.
    3. In Registry Editor, locate the registry key for the full-text search resource. To do so, view the Name value for each resource under the following registry key:

      HKEY_LOCAL_MACHINE\CLUSTER\Resources

      Note Registry keys that correspond to all cluster resources are identified by their GUIDs.
    4. Expand the registry key for the full-text search resource, and then click the Parameters registry key.
    5. Use the following information to add a registry value to the Parameters registry key for the full-text search resource:
      • Name: ApplicationName
      • Type: REG_SZ
      • Value: For a named instance of SQL Server, the value is SQLServer$Instance name (where Instance name is the name of the instance of SQL Server that is being used.) For a default instance of SQL Server, the value is SQLServer.
    6. Use the following information to add a registry value to the Parameters registry key for the full-text search resource:
      • Name: ApplicationPath
      • Type: REG_SZ
      • Value: The full path of the folder that contains the full-text data files. For a named instance of SQL Server, the value ends in MSSQL$Instance name\FTDATA. For a default instance of SQL Server, the value ends in \MSSQL\FTDATA.
  5. Use Cluster Administrator to bring the full-text search resource online.

Other considerations

If the latest SQL Server service pack is installed on the clustered instances of SQL Server, follow these steps to upgrade the full-text search service to the latest service pack level on the nodes in the SQL Server cluster:

  1. Click Start, and then click Run.
  2. In the Run dialog box, type notepad.exe, and then click OK.

  3. Add the following command to the text file:

    Full path of SQL Server service pack Setup files\x86\FullText\MSSearch\Search\SearchStp.exe /s
                     /a:SQLServer$Instance name
  4. Save the file as installsearch_SP.cmd.
  5. Use Cluster Administrator to take the full-text search resource offline.

  6. At a command prompt on the node that owns the SQL Server resources, run the following command:

    Full path of the Installsearch_SP.cmd file > installsearch_SP.out

    Note When the installsearch_SP.cmd command is complete, open the Installsearch_SP.out file and make sure that there are no errors in the file.

  7. Use Cluster Administrator to take the full-text search resource offline, move the virtual server group to the each node that is participating in the cluster, and then repeat steps 1 through 7 on the computer that owns the clustered resources.
  8. Use Cluster Administrator to bring the full-text search resource online.

back to the top

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

810056 You must use resource-specific registry keys for SQL Server cluster resources


254321 Clustered SQL Server do's, don'ts, and basic warnings


290211 How to obtain the latest SQL Server 2000 service pack


back to the top

Keywords: kbSetupMan kbRegistry kbRepair kbHOWTOmaster kbClustering KB812666
Technology: kbAudDeveloper kbSQLServ2000Search kbSQLServSearch



Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.


Retrieved from ‘https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/812666&oldid=332924’
the Creative Commons 3.0 ShareAlike (except the Microsoft KB Archive).
Powered by MediaWiki