How to install FullText Search on SQL Server 2008

Question

Possible Duplicate:
How to install fulltext on sql server 2008?

I have recently installed SQL Server 2008 R2

When I tried to create Full Text Search Index

Example

CREATE FULLTEXT INDEX ON DATABASENAME.dbo.MYTABLE
(
column_to_index
Language 0X0
)
KEY INDEX myindex ON DATABASENAMECatalog
WITH CHANGE_TRACKING AUTO

It had given me following error:

Msg 7609, Level 17, State 5, Line 4 Full-Text Search is not installed, or a full-text component cannot be loaded.

I tried following

1: Right Click on My Computer and Click "Manage"

2: Double Click "Services and Applications"

3: Double Click "SQL Server Configuration Manager"

But I can't able to perform following 2 steps, as their is No FULL TEXT SEARCH service was their.

4: Double Click "SQL Server Services"

5: Check if "SQL Server Full Text Search" is not started, than Right Click and Press on Start.

Can anyone please guide me how to install full text search on SQL Server 2008

Answer 1

As the comments suggested, you should probably re-install and make sure you choose the Full-Text Search option (directly under SQL Server Replication).

FYI, this image comes from a step by step install guide

Answer 2

The simplest way to validate whether or not you have installed the Full Text "component" of SQL Server 2008 is to execute the following T-SQL

select SERVERPROPERTY('IsFullTextInstalled')

If this query returns a value of '1' then the component is installed.

For further readining on how to get started see: Getting Started with Full-Text Search