Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: SQL Full Text Search

    Hi.

    We are having a problem with full text search.

    Our server has recently been down graded from enterpise to standard eddition SP3.

    I have reset the SQL Service account to local admin using enterpise manager but when i try to populate the full text catalogue I get an item count of 0.

    I have reregistered all dlls in the mssearch\bin directory and the language key in HKLM\software\micorsoft\search\1.0\neutral doesn't exist.

    Both the MSSearch and SQL services are running under the local admin account, and the built\administrators account is a sysadmin.

    Any help will be much apreciated.. pulling my hair out on this one.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    WHat is the error while populating?
    Review SQL Server error log or run PROFILER during the process.

    Try to reinstall FULLTEXT search on the downgraded version of SQL.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Sep 2003
    Posts
    8
    Event Log 3024

    The crawl for project <SQLServer SQL0001600005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.


    Can i just reinstall MSSearch if so how do i go about this?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    MSSearch must be running under local system account as specified in this KBA http://support.microsoft.com/default...b;EN-US;317746

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Sep 2003
    Posts
    8
    I've also found this article, both SQL and MSSearch Services are running under the local system. Which has sysadmin rights on the SQL box.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    There is a difference between running as local system account and having sysadmin privileges.

    ENsure to run MSSearch Service only with local system account.
    And for MSSQLSErver service use an admin privileged account.

    You need to restart the services if you make any changes.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Sep 2003
    Posts
    8
    Satya,

    I have both the builtin\administrators and Ntauthority\system account set up in SQL Server as sysadmins. I have tried running SQL under a domain account which is also a sysadmin but get the same results.

    I think that MSSearch has somehow become corrupted i'm interested to here if you can uninstall and reinstall this.

    It is a production server so I obiously dont want to much downtime.

  8. #8
    Join Date
    Sep 2003
    Posts
    8
    Sorry forgot to mention, both services have been restarted several times.

  9. #9
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    This KBA http://support.microsoft.com/default...b;en-us;327217 refers that applying Sp3 (currently SP3a is only available) will upgrade the FUlltext catalogs by rebuilding them.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  10. #10
    Join Date
    Sep 2003
    Posts
    8
    Thanks. I'll try this tonight and let you know if it helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •