SQL Server Performance

Full Text on Cluster

Discussion in 'SQL Server Clustering' started by simondm, Apr 5, 2005.

  1. simondm New Member

    I'm trying to re-install full text on my cluster as per this knowledge base article:<br /><br /<a target="_blank" href=http://support.microsoft.com/default.aspx?kbid=812666>http://support.microsoft.com/default.aspx?kbid=812666</a><br /><br />Because I currently can't use any of my full text indexes.<br /><br />I've deleted the resources and registry key and am now running the .cmd file as requested. This is the output I get:<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />C:&gt;"C:x86FullTextMSSearchSearchSearchStp.exe" /s /a<img src='/community/emoticons/emotion-7.gif' alt=':S' />QLServer <br /><br />C:&gt;"C:x86FullTextftsetup.exe" SQLServer MYDOMAINMyUser 1 0 1 0 <br />FulltextSetup returned error code: 0x80040D02<br /><br /></font id="code"></pre id="code"><br /><br />I cannot work out why I am getting this error, or any reference to what it may mean. Because I deleted the resource, I had no full text service at all - I have tried to add back the resource (including setting the registry keys as per the kb article) but now my full text service fails to start at all. In the event log I get a message invalid file name.<br /><br />Any ideas?
  2. satya Moderator

    May search this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;827449 to resolve the issue.

    I'd recommend that you install the Full-text Search components via your SQL Server 2000 Setup CD and select "custom installation" and under "server components" you will see "Full-text Search" and you should checkmark this and then the SQL Server 2000 Setup process will install these components for you.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. simondm New Member

    That article is for non clustered servers - for clusters it links back to teh article I was using.

    Any other ideas?
  4. satya Moderator

    Confirm:
    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.


    .. and also confirm whether you followed all the steps defined in your KBA. Also review and post anyother error messages from SQL server and Cluster services.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. simondm New Member

    The orgianl install was done from a network share. I have followed KB 812666 step by step using the network share and copying the files to the local server. I have also tried it with the orginal sql files and the SP3a files.

    Everytime I run the install I get the error in my first post. To which I can't find any reference to anywhere.
  6. satya Moderator

    Remove the registry key: HKLMSoftwareMicrosoftSearch1.0LanguageNeutral
    Restart Microsoft Search, and then restart any populations that failed. This might include catalog populations for other instances of SQL Server, and any other products that use Microsoft Search.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page