Post reply

Full text indexing

  • August 11, 2005 at 5:54 pm

    #87095

    I have tried to update a server install (Standard Edition 2000) with full text indexing to no avail. It doesn't look like the option was originally installed on the server and when I tried by adding components from the SQL Server CD it ran fine but the log file said it wasn't installed because there is a newer version on the server. Microsoft Search is running as a service, but not of the full-text indexing options are available from the menus. If I run the stored procs to setup a catalog I get the 'error 7609 and components missing'.

    SQL Server has been updated to SP3. Not sure what to do from here. Any suggestions?

     

    Bob

  • August 12, 2005 at 9:06 am

    #581798

    Yes... I've seen this before (many times) in the public fulltext newsgroup. You can either follow the procedures in the following KB article:

    827449 "How to manually reinstall the Microsoft Search service for an instance of SQL 2000" at http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449

    Or follow the following steps:

    Re-install" the "Full-text Search" components via deleting (or renaming) the below "tracking key" and re-install (If you're not using a named instance, remove "<Instance_Name>\".)

    NOTE: be sure to be logged on to the server as either Administrator or as a member of the server's Admin Group!

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance_Name>\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}

    Once you've done removed (renamed) the above tracking key, then delete the MSSearch directory from either:

    drive_letter:\Program Files\Common Files\Microsoft Shared

    or

    drive_letter::\Program Files\Common Files\System\

    Then using your SQL Server 2000 installation CD re-install via "Custom Installation" the Full-Text Search component (it should be un-checked). When this completes find and save these files: SearchSetup.log (usually under \windows or \winnt folders) and sqlsp.log. If any problems, please post these files.

    Re-install SQL Server 2000 Service pack (SP3), so that the newly installed MSSearch components are upgraded to SP3 levels and then re-boot &/or restart the MSSearch and MSSQLServer services.

    Hope that helps!

    Regards,

    John

    SQL Full Text Search Blog

    http://spaces.msn.com/members/jtkane/


    John T. Kane

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply