Recently we had to update passwords for our database that DNN is attached to.  While users are able to log in and use the system we have a nagging entry that keeps appearing in our event log that indicates that the Help Search Item collector can not log into the system (see event log below.)

 

In attempting to resolve the problem I have insured that I can log into our database server with the username (dnnProd1) and the new password (no problem.)  I have also verified that the connection parameters in the web.config are correct.  I have made a grep sweep of the DNN directories as well as the registry looking for the aforementioned user to which I found nothing.

 

I’m at wits end with this and am looking for any help that could help resolve the problem.  Does anybody have a suggestion on how to resole this problem?

 

AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: Login failed for user 'DnnProd1'.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.Data.SqlClient.SqlException: Login failed for user 'DnnProd1'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Help.SqlDataProvider.GetTutorialsByModule(Int32 ModuleId) at DotNetNuke.Modules.Help.HelpController.GetByModules(Int32 ModuleId) at DotNetNuke.Modules.Help.HelpController.GetSearchItems(ModuleInfo ModInfo) at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 PortalID)

Check BOTH connection strings in web.config.

That was the problem.  Someone had inadvertently set one of the password parameters in the connection string to password=password=.  A typical cut-and-paste problem.  Thanks for the advise.