SQL Server offers a Full Text Search allowing the application to perform full-text queries against character-based data in SQL Server tables. The search text has been working great for a while until recently we have encounter the error "An unknown full-text failure (80004005) occurred in function EnumCatalogs on full-text catalog". After the application has failed to return any search result we have quickly go into SQL Server and check out the database. We try to rebuild the catalogue but only ended up with an error message. We then try to repopulate the database but again we fail to get the database catalogue working.

This error usually occurs when we move the database from one logical drive to another by means of detaching and attaching the database. But this error could also be the cause of something else.

Here are some steps to follow to trouble shoot the error “An unknown full-text failure (80004005) occurred in function EnumCatalogs on full-text catalog”

• Make sure that the folder config, projects and GatherLogs existed.
  
  - C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\ SQLServer\Config
  - C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\ SQLServer\Projects
  - C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\GatherLogs
  
  
• Ensure that the SQL Server process has the permission to

1. Log On Locally
2. Log on as service
3. Increase quotas
4. Act as part of the operating system
5. Log On as a Batch
6. Access this computer from the network

If after you have done the verification and you still unable to perform a full text search then try to re-install the SQL Server 2000 Full-Text Search components from your SQL Server 2000 setup CD. Make sure you have un-install the service first. You might have to force the removal of the search service via the registry key.

Re-install Full-Text Search

• Log onto the server with local admin right
• delete or rename the registry key ( HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
  Server\\Tracking\ {E07FDDA7-5A21-11d2-9DAD-00C04F79D434} )
• Delete the MSSearch directory from drive_letter:\Program Files\Common Files\Microsoft Shared\ or drive_letter::\Program Files\Common Files\System\
• Now use your SQL Server 2000 installation CD to re-install the MSSearch components.
• Now rebuild your database catalogue.

OK I hope this will help those who are experience a headache with this issue.

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."