Here are the steps to install and enable full text search in MSSQL server.
Launch the sql server setup
Choose the Installation page on the left hand side of the SQL Server installation center and Click on ‘New Installation or add features to an existing installation.’ option as highlighted below:
The sql server setup launches the ‘System Configuration Check’ and checks the setup support roles as shown below. Go ahead and click OK to proceed if all the rules have passed the check, otherwise you will need to take appropriate actions for the rules that failed the checks.
Go ahead and click install on the next page to install the setup support files further.
Once done the system configuration checker kicks in again and performs a check against a different set of rules, review and click ‘Next’ if all seem ok.
Go ahead and select ‘Add feature to an existing instance of SQL server 2008 R2′ and the instance name and click Next.
On the feature selection page notice that Full-Text search is available under the ‘Database Engine services’ under ‘Instance Features’.
Select Full-Text Search and you should see ‘Server Configuration’ page added to the left hand side of the setup window, we will get to that in a minute. Click ‘Next’ to continue.
System Configuration checker checks the Installation Rules this time and provides us the status of each check and gives a go-no go signal. Click ‘Next’ to go further.
The Next page computes the space required for the installation of the Full-Text Search feature; Review and click next to proceed.
The next is the server configuration page, where the ‘SQL Full-Text Filter Daemon Launcher’ Service Account name password needs to be defined, and its startup type needs to be defined. Set appropriate domain account and click ‘Next’.
The Next page gives you an option to handle the Error Reporting to send information to Microsoft. Click ‘Next’ to proceed.
The system configuration checker runs once last check on the Installation configuration rules and provides the status to decide to proceed with the install. Review and click ‘Next’
On the next page review the installation features and settings collected and their summary and click ‘Install’ to begin installation.
Then Next page provide you the installation progress and the installation should be fairly quick. wait for the completed successfully message and click ‘Close’
Now Open the query window on the instance and check the result for the serverproperty(‘IsFullTextInstalled’) to confirm installation.
