Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SQL Server 2008 R2 server instance where I'm unable to use full text catalogs. It was upgraded from SQL Server 2008. When I go to the database properties of an existing database or try to create a new database the "Use full-text indexing" checkbox is disabled.

Some things that I have checked are:

  • Full text search service is installed and started
  • Named pipes protocol is enabled
  • Full text service is running under local system account
  • EXEC sp_fulltext_database 'enable' does run successfully

What else could go wrong, because I'm stuck at it?

share|improve this question
Any errors in the error log ? – Kin Sep 30 '13 at 19:29
No errors...actually in one DB I can use full-text search, while in another I can't – Albert Oct 1 '13 at 8:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.