enable full text search

• C-144941

  SSC Rookie

  Points: 37

  More actions

  July 14, 2004 at 11:31 pm

  #164223

  Hi,

  I'm trying to enable full text indexing on a table. The context menu item for Full-Text Index Table is disabled so I ran

  EXEC sp_fulltext_database 'enable' and got the error

  Server: Msg 7602, Level 16, State 2, Procedure sp_fulltext_database, Line 46

  The Full-Text Service (Microsoft Search) is not available. The system administrator must start this service.

  The configuration for my server is as follows:

  • Microsoft SQL Server  2000 - 8.00.760 (Intel X86)

     Dec 17 2002 14:22:05

     Copyright (c) 1988-2003 Microsoft Corporation

     Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

  • Both the MSSQLSERVER and the Microsoft Search services are set to start automatically.
  • Microsoft Search runs as LocalSystem account
  • MSSQLSERVER runs as a dedicated domain account
  • Full-Text search is installed

  I really don't want to re-install SQL server unless I absolutely have to.

  Please help,

  

   

• nileshsane

  Default port

  Points: 1465

  More actions

  May 30, 2005 at 5:52 am

  #561674

  I am facing the same problem. Could this be due to the type of installation, i.e. Enterprise / Standard/ Desktop etc?

  Any help would be appreciated.

  ---

  What I hear I forget, what I see I remember, what I do I understand