Re: Help - An unknown full-text failure (80004005) while trying to create a new full-text catalog

From: John Kane (jt-kane_at_comcast.net)
Date: 06/29/04 

Date: Mon, 28 Jun 2004 22:52:00 -0700

Andrew,
You are correct *most* of the causes for the "unknown full-text failure
(80004005) while trying to create a new full-text catalog" in SQL Server
2000 were either eliminated or more specific error text messages were
defined. Still, you should check the obvious causes, for example, have you
recently changed the DCOM settings on this server? Have you or anyone else
changed the MSSQLServer startup account via Win2K's Component services? Does
the SQL logon account BUILTIN\Administrator exist with the default settings
of master database and have sysadmin privileges? Is this SQL Server
installed on a Domain Controller (DC) or backup DC (BDC)? Except for the
DCOM setting & installed on a DC/BDC, you should of gotten different error
text messages if any other changes were made. You should review the
following KB articles:

277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746

263712 (Q263712) INF: How to Impede Windows NT Administrators from
Administering a Clustered SQL Server
http://support.microsoft.com/default.aspx?scid=KB;EN-US;263712

Depending upon your answers, it may be necessary to re-install the SQL FTS
components via the procedures doc'ed in the following KB article: 827449 How
to manually reinstall the Microsoft Search service for an instance of SQL
2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449
Regards,
John

"Andrew Zoltay" <andy_trek@hotmail.com> wrote in message
news:69abe98.0406281407.6885baa7@posting.google.com...
> Hi,
>
> We just started getting this error when trying to create new catalogs
> on databases that do not already have a Full-Text catalog. I can
> create a new catalog on a database that has an existing catalog, but
> cannot on one that does not.
> I get the following error: "An unknown full-text failure (80004005)
> occurred in function EnumCatalogs on full-text catalog" when I try to
> create a new catalog through Enterprise Manager and this error when I
> execute sp_FullText_Database:
> "Server: Msg 7608, Level 17, State 1, Procedure sp_fulltext_database,
> Line 46
> An unknown full-text failure (80004005) occurred in function
> EnumCatalogs on full-text catalog ''."
>
> Line 46 in sp_fulltext_database looks to be:
> DBCC CALLFULLTEXT ( 7, @dbid ) -- FTDropAllCatalogs ( "@dbid" )
>
> I've seen plenty of postings of this error, but they are all for SQL
> Server 7.0.
> We're running SQL Server 2000:
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003
> 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> Any ideas?
>
> Thanks in advance.
> Andy

Relevant Pages

  • Re: Performance question
    ... perhaps in your case by sales rank. ... Looking for a SQL Server replication book? ... For the past year as our catalog has grown, ... say a customer searches our ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Update based on SQ LDynamic Stored Proc Problem
    ... I'm using Visual Studio 2005 with SQL Server 2005 ASP.NET 2.0 VB ... I have a Catalog table and I created a form with textboxs and Submit button to call stored procedure to updated existing records ... Basically you create a SQLParameter for each input parameter for the SP provide each parameter with a value and add the SQLParameter to the SQLCommand. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Fulltext index for 2 columns in one table
    ... In SQL Server 2005 you can now pass a list of indexed columns instead, ... >> You can put both columns in one catalog. ... >> In Sql Server 2000 you can query one column or all columns. ... >>> have to search using this tilldescription. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: When does Full Catalog Break.
    ... Extensions to SQL Server to Support Full-Text Search ... Textual Searches on Database Data Using Microsoft SQL Server 7.0 ... > A good KB article that describes the procedures for moving a FT catalog - ... >> Will the full text catalog break if I delete all the records from a ...
    (microsoft.public.sqlserver.fulltext)
  • SQL error
    ... An unknown full-text failure occurred in function ... EnumCatalogs on full-text catalog ''. ... sql server 2000 enterprise edition ...
    (microsoft.public.sqlserver.clients)