Home > Full Text Catalog > Resolution step for the issue” No full-text supported languages found. Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.”

Resolution step for the issue” No full-text supported languages found. Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.”


We are getting the below issue after install the full text search and here I mention the workaround.

Issue: Informational: No full-text supported languages found. Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.

Workaround:

1st Step:SELECT @@language; then run the below command

 

sp_fulltext_service ‘update_languages’

 

If the issue is not resolved then needs to follow the below step.

After the installation completed,I went into SQL Server Configuration Manager and under the SQL Server 2005 Services detail Right Click SQL Server Full Text Search -> Properties.

  • Stop the service here.
  • Change the Built In Account to Network Service
  • Start the service.
  • Went back into SQL Server Management Studio
  • Selected properties from my database – > files -> uncheck the full-text >Then saved.
  • Then went back into the same setting and re-enabled it.
  • Then when I went to the table level – > create full-text index. I can now select a language (before I saw an empty drop-down list)
Advertisements
Categories: Full Text Catalog
  1. March 2, 2017 at 2:26 pm

    Hi there, I would like to subscribe for this web site to get most recent updates, therefore where can i do it please
    help.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: