Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Intermittent Connection ProblemIntermittent Connection Problem
Previous
 
Next
New Post
12/4/2006 9:47 AM
 


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:

<

 

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.

 

add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> 
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Intermittent Connection ProblemIntermittent Connection Problem


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out