Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 how to create Full-text catalog?

Author  Topic 

Norman Castle
Starting Member

9 Posts

Posted - 2010-11-12 : 18:20:15
I'm having trouble setting up full text search on my database. I have been unable to create a fulltext catalog. I get the following message when I try:

========================================================
Full-Text Indexing Wizard Progress

- Create full-text catalog TextCatalog (Error)
Messages
* Create full-text catalog failed.

------------------------------
ADDITIONAL INFORMATION:

Create failed for FullTextCatalog 'TextCatalog'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+FullTextCatalog&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Execution of a full-text operation failed. 'Server execution failed' (Microsoft SQL Server, Error: 7689)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476


- Create full-text index on eBay_Items.Current_Items (Stopped)

========================================================

Also, in management studio when I try to run Management>Full-Text Search>Start I get the message :

The msftesql service on EMERAC started and then stopped (explorer)


What can I do about this?
   

- Advertisement -