Tfs 2008 dual server installation failes with the error "Error: Full-Text Search is not installed, or a full-text component cannot be loaded" - MY TROUBLESHOOTING TIPS - Site Home

Hi People,

I am back. Recently, I saw a very interesting scenarion while doing dual server installation of TFS 2008, we receive the following error message:

Microsoft.TeamFoundation.DatabaseInstaller.DatabaseException:
                                    Line 7239
                                    Error: Full-Text Search is not installed, or a full-text component cannot be loaded.
Creating full text index on Workitem ---> System.Data.SqlClient.SqlException: Full-Text Search is not installed, or a full-text component cannot be loaded.
Creating full text index on Workitem
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.TeamFoundation.DatabaseInstaller.DataDeployer.ExecuteSql(SqlConnection sqlConnection, String batch)
   at Microsoft.TeamFoundation.DatabaseInstaller.DataDeployer.DeployScript(String script)
   --- End of inner exception stack trace ---
   at Microsoft.TeamFoundation.DatabaseInstaller.DataDeployer.DeployScript(String script)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunDbActions(InstallerMode mode, String server, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.RunSteps(InstallerMode mode, String server, IPropertyCollection properties, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.Installer.Install(String server, IPropertyCollection properties, Boolean preview)
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.CommandInstall.OnRun()
>Ã
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.Commands.InstallerCommand.Run()
   at Microsoft.TeamFoundation.DatabaseInstaller.CommandLine.CommandLine.RunCommand(String args)
> Inner Exception:
SQL Error #1
SQL Message: Full-Text Search is not installed, or a full-text component cannot be loaded.
SQL LineNumber: 1
SQL Source: .Net SqlClient Data Provider
SQL Procedure:
SQL Error #2
SQL Message: Creating full text index on Workitem
SQL LineNumber: 3
SQL Source: .Net SqlClient Data Provider
SQL Procedure:

System.Data.SqlClient.SqlException: Full-Text Search is not installed, or a full-text component cannot be loaded.
Creating full text index on Workitem
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.TeamFoundation.DatabaseInstaller.DataDeployer.ExecuteSql(SqlConnection sqlConnection, String batch)
   at Microsoft.TeamFoundation.DatabaseInstaller.DataDeployer.DeployScript(String script)
Exception Data:
Key: HelpLink.ProdName, Value: Microsoft SQL Server
Key: HelpLink.ProdVer, Value: 09.00.4035
Key: HelpLink.EvtSrc, Value: MSSQLServer
Key: HelpLink.EvtID, Value: 7609
Key: HelpLink.BaseHelpUrl, Value: http://go.microsoft.com/fwlink
Key: HelpLink.LinkId, Value: 20476

Cause

This issue happens for two reasons

1. If the full text search service is not installed or started on Data Tier

2. Second and the most important one is if the full text search service is running under local system account or any other machine account

Resolution

-To resolve the issue, please do the following as per the condition applicable

1. If you find that the full text search service component of sql server is not installed, please go and run the setup again and install that particular feature.

2. After installing full text search service, please make sure that it is started and set to automatic by going to services console.

3. Once it is started, please make sure it is running under domain/tfsservice account and not the local system account.

4. In case it is running under local system account, please change it to domain/tfsservice account by going to sql server configuration manager

Hope it helps :) Well today I am gonna come up with another interesting scenario related to loop back issue.....just wait and watch

Nitish