Default Language missing in Full Text Indexing

• AtTheLake

  SSChasing Mays

  Points: 636

  More actions

  August 29, 2008 at 9:09 am

  #125149

  I'm trying to build a FTI in SQL2005 EE, and receive the following error:

  "Default full-text index language is not a language supported by full-text search.

  Informational: No full-text supported languages found.

  When I go thru the GUI to build the FTI, the language field is blank, there are no choices in the drop down for me to choose.

  Here are some of the things I have looked at:

  /*------------------------

  sp_configure 'default full-text language'

  ------------------------*/

  name minimum maximum config_value run_value

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

  default full-text language 0 2147483647 1033 1033

  /*------------------------

  select * from sys.fulltext_languages

  ------------------------*/

  lcid name

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

  Informational: No full-text supported languages found.

  Informational: No full-text supported languages found.

  (0 row(s) affected)

  /*------------------------

  select @@language

  ------------------------*/

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

  us_english

  (1 row(s) affected)

  Any help on this is greatly appreciated!

  Thanks

• manishb1986

  SSC Rookie

  Points: 30

  More actions

  May 15, 2011 at 2:11 pm

  #1324763

  Any update on the same?????????????????????/

• manishb1986

  SSC Rookie

  Points: 30

  More actions

  May 15, 2011 at 2:14 pm

  #1324765

  when running "reconfigure" gives error

  -------

  Informational: No full-text supported languages found.

  Informational: No full-text supported languages found.

  Msg 5841, Level 16, State 1, Line 1

  The default full-text language is not supported by the full-text search component.

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

  Kindly help on the same...........