I have a DNN 4.3.4 site that works fine most of the time... sorta. I am a noob w/asp.net. I appreciate any help that can be given.Please let me know if there is a different forum to post this to...
I think it may be a problem with my connection string?
Web.config connection strings:
<
<
add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=SSPI;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient"/>add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=SSPI;User Instance=True" providerName="System.Data.SqlClient"/>
App Settings connection string in Web.config:
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
About 20 times a day when the site is being browsed, I get the following error (on local and remote machine)(Also, the problem goes away by itself after some time but I cannot pin down how long or it always goes away after I recycle the IIS server):
Web Page that appears:
Unhandled Error
Error Details
File
Error Cannot open user default database. Login failed. Login failed for user 'scl\boss'.
In the Windows Application Event Log:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 12/1/2006
Time: 12:19:34 PM
User: N/A
Computer: INTRA
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/1/2006 12:19:34 PM
Event time (UTC): 12/1/2006 6:19:34 PM
Event ID: b19d58a5db6e45ebb7d43ea9678d9912
Event sequence: 88
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/w3svc/1/ROOT/Intranet-1-128094672815724243
Trust level: Full
Application Virtual Path: /Intranet
Application Path: C:\Inetpub\wwwroot\Intranet\
Machine name: INTRA
Process information:
Process ID: 2112
Process name: aspnet_wp.exe
Account name: INTRA\ASPNET
Exception information:
Exception type: SqlException
Exception message: Cannot open user default database. Login failed.
Login failed for user 'scl\boss'.
Request information:
Request URL:
Request path:
User host address:
User:
Is authenticated: False
Authentication Type:
Thread account name: scl\boss
Thread information:
Thread ID: 9
Thread account name: scl\boss
Is impersonating: False
Stack trace: 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.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.PurgeLog()
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.PurgeLogBuffer()
at DotNetNuke.Common.Global.LogEnd() in C:\Inetpub\wwwroot\Intranet\App_Code\Global.asax.vb:line 124
at DotNetNuke.Common.Global.Application_End(Object Sender, EventArgs E) in C:\Inetpub\wwwroot\Intranet\App_Code\Global.asax.vb:line 285
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.