SQL Server Performance

Problem with fulltext search

Discussion in 'SQL Server Clustering' started by humut, Nov 28, 2006.

  1. humut New Member

    Hi
    I have a problem with fulltext search on a fail-over cluster.
    Everything seems to work, i can rebuild, populate etc but when i search i get no results.
    On the test server everything works fine, but its not running on the cluster.
    One odd thing though, uniquecount is 1 and item count is 4 billion

  2. MohammedU New Member

    Is there any patches/sw installed before failover?
    what sql build you are on?
    Check the BuiltinAdministrator account permissions...

    Mohammed U.
  3. humut New Member

    windows 2003 updated
    SQL 2000 SP4
    Administrators of the machine has rights to the fulltext search catalogs.
  4. humut New Member

    fyi I reinstalled sql server + sp's and then everything worked....very strange
  5. satya Moderator

    That time have you checked whether MSSearch service is up and running and the local admin has got relevant privileges, for information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  6. MohammedU New Member

    quote:Originally posted by humut

    fyi I reinstalled sql server + sp's and then everything worked....very strange


    That is interesting...
    Happy to here it is working...


    Mohammed U.
  7. humut New Member

    Hi
    Yes the service was up and running and you could create a fulltext catalog, then an eventlog error occured related to c000005 which look like a permissions error, i changed filepermissions to full control on all drives and the service account already had administrative rights. It did not work with the service account either on either node.
    The fulltext catalog and the files was still created, but after a rebuild and full population it had the wrong unique and item count and calling contains statement gave no result.
    Then i gave up and reinstalled.

Share This Page