Module Load Exception Error When Trying To Use Full-Text Indexing On Your DNN Site

Module Load Exception Error When Trying To Use Full-Text Indexing On Your DNN Site


Issue
When you try to use a module that utilizes Full-Text Indexing, you receive an error similar to the following:
DotNetNuke.Services.Exceptions.ModuleLoadException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance. ---> System.Data.SqlClient.SqlException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Forums.SqlDataProvider.Search_FullText(Int32 PortalId, Int32 ModuleId, Int32 UserId, Int32 ForumId, Boolean IsSuper, Int32 RowIndex, Int32 MaxRows, String SearchString, Int32 MatchType, Int32 SearchField, Int32 Timespan, Int32 AuthorId, String Author, String Forums, String Tags, String ForumsAllowed) at Active.Modules.Forums.af_search_new.BindPosts(Int32 Column, String Sort) at Active.Modules.Forums.af_search_new.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Cause
The SQL Server Full-Text Indexing services are either not installed or are not running under the correct user account.

Resolution
If you are on a shared hosting server, then issue must be resolved by a Support Technician.
  1. Log into your server through Remote Desktop.
  2. Click on Start > Run (Windows - R).  Type Services.msc and press Enter.
  3. Search for SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
  4. Right-Click on the service and choose Properties
  5. Set the following properties on it:
    • General > Startup Type = Automatic
    • Log On > Log On As = Local System Account
  6. Click OK.
  7. Right-Click on the service and select Restart.
  8. Close the Services box.

 

Add Feedback