DNN Error: Cannot open user default database. Login failed. Login failed for user domain/user

Everything seems to be working fine i have installed the latest version of dnn and ad authentication. I am trying to create a intranet with users being logged in automatically according to active directory and for the most part it has been working fine. but i seem to get an error after a period of time eg over night or 2 hours i get back in the morning and i receive the abouve error for about 10 minutes then the home page can be refreshed and then loads fine.

I am very new to dnn so i could have a wrong line of code or something. i added the impersonate= 'true part and i have the following line in my web config file:

<add name="Authentication" type="DotNetNuke.Authentication.ActiveDirectory.HttpModules.AuthenticationModule, DotNetNuke.Authentication.ActiveDirectory" />

but was unable to use this line:

< add name="Authentication" type="DotNetNuke.HttpModules.AuthenticationModule, DotNetNuke.HttpModules.Authentication" />

Thanks in advance

 

The second line is commented out so thats ok i guess. yeah i think i set up the impersonation as described, i did use an active directory user who is not an administrator could that be a problem? It is the same user as the impersonation, if i look at the site from another user it still says the impersonation user name rather than there user name. I did notice the user name it displays was not a user on the database could that be a problem?

Thanks for your help Mike, this thing is so weird its not even after long periods of time its just random but when it happens no user can acccess the site and i jhust keep hitting refresh until its back, sometimes i see the install/under construction page. here is the stack trace info if that is any help, i edited the user and domain info Cannot open user default database. Login failed. Login failed for user 'domain\user'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'domain\user'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Cannot open user default database. Login failed. Login failed for user 'domain\user'.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +204 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +68 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +108 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +62 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +72 DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +176