Telephone: (480) 722-1227 Toll Free: (888) 722-1227
  Email - Contact
  Register Login   |   Knowledge Base  >  Knowledge Base Systems  >  MSSQL  >  sql 2008 crawl errors   |   Friday, September 03, 2010 search:    
sql 2008 crawl errors
Last Post 11 Apr 2009 10:31 AM by Vigilant CIO. 0 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Vigilant CIOUser is Offline
Basic Member
Basic Member
Posts:353

--
11 Apr 2009 10:31 AM  

ref link; http://msdn.microsoft.com/en-us/lib...aspx  and http://msdn.microsoft.com/en-us/lib...42487.aspx

sypmtoms;

in storage>catalogue the catalogs show not records or catalog size. SQL logs and windows event logs show

  1. "SQL Server failed to communicate with filter daemon launch service  (Windows error: The service did not start due to a logon failure.
    ). Full-Text filter daemon process failed to start. Full-text search functionality will not be available."
  2. "A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is  ....
     Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION."

resolutions;

The fulltext admin service proably has a security problem. Correct the service login account. If the service is not part of a cluster and uses only local resources, try using a local service account.

You are not authorized to post a reply.

Active Forums 4.2
Copyright 2006 - 2010 Vigilant Support   |  Privacy Statement  |  Terms Of Use