Post reply

I'm trying to create Full-text catalog

  • November 13, 2010 at 5:32 pm

    #147562

    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?

  • November 14, 2010 at 9:32 am

    #1250439

    it sounds like the password that is stored for running the full text service is out of date/changed;

    Control Panel>>Administrative Tools>>Services>> find the full text service (my 2008 was named "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)", my 2005 is named SQL Server Full Text Search(InstanceName))

    go to the Log on tab, and see if that is the right account you want...try to start the service from there...if it fails, it will tell you the same as you were describing....stat and stop...so you might need to update the password or select a different account to run the service.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 14, 2010 at 10:47 am

    #1250450

    Thank you for your response.

    I don't quite follow your answer, though. Can you explain further, please.

    You say find the service for full-text search, but your picture shows the details for SQLEXPRESS, rather than the full text service. Which is the one that I need to check?

    Currently, for me, they are both set to "local system account" Is that setting wrong? What should I set it to? How do I know the correct account name and password to set?

    I've tried starting the service from the service manager, as you suggest. This time I get a different error message.

    Error1717 : The interface is unknown.

  • November 15, 2010 at 6:49 pm

    #1251070

    Can anyone help me with this?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply