Why the Full-Text indexing option is greyed out?

sql-server sql-server-2008 full-text-search
silent200 picture silent200 · Jan 5, 2009 · Viewed 27.9k times · Source

I installed SQL Server 2008 Express with Advanced Services, but when I try to create a new database, the option Full-Text indexing is greyed out, I believe the full-text indexing has been installed, because I did a query as below: 

use [mydbname]
select fulltextserviceproperty('isfulltextinstalled')

This query returns 1, so I think it has been successfully installed.

Full-text indexing is supported in MSSQL Express with Advanced Services edition, which I have installed. Page for reference:
http://www.microsoft.com/downloads/details.aspx?familyid=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

Answer

Mike picture Mike · Feb 9, 2010

Make sure NAMED PIPES is enabled in the protocols in configuration manager as full text service needs this!

Related questions

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed

I am getting following error in my SQL server 2008 R2 database: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblArmy' because it is not full-text indexed.

Read More
SQL Fuzzy Matching

Hope i am not repeating this question. I did some search here and google before posting here. I am running a eStore with SQL Server 2008R2 with Full Text enabled. My requirements, There is a Product Table, which has product …

Read More
SQL Server 2008 Full Text Search (FTS) versus Lucene.NET

I know there have been questions in the past about SQL 2005 versus Lucene.NET but since 2008 came out and they made a lot of changes to it and was wondering if anyone can give me pros/cons (or link to …

Read More