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 ...DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)
Previous
 
Next
New Post
8/19/2008 3:30 PM
 

I hope this helps others with the same error I had.

I have had our DotNetNuke site up for 2 years now with no problems.
 
http://www.acocares.org/aco/
 
No changes have been made to the files on the site (other the jpg's and pdf's).  No changes were made to the webpages for 3 days before the error.  This is a very simple site with a very simple DNN DB that has not changed in years.  As of Friday August 16th, the site has been down with the following error:
 


ERROR: Could not connect to database.
 
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 0 - Insufficient system resources exist to complete the requested service.)


After hours of emailing the hosting company and checking DB connection strings and verifying that the SQL DB was just fine I found this:

Here was the fix:
www.fasthostinghelp.com/error-assembly-version-assemblyversion-t81.html?s=baa9a3b38c595dcfbc00f837d7e5d687&s=fecd12ee7902be831c6bf9ebcf5971ca&p=160

Even though the site had never been upgraded or the config (or any) files modified since it was setup 2 years ago, the "web.config" file still needed to be updated to make the site work now.

Here is the entry that needed to be made in the web.config under appSettings:

add key="UseDnnConfig" value="false"

I hope this information will help others, though I am still very baffled by what made this setting necessary after all this time.

Does anyone have an idea why this change was needed after all these months of flawless uptime?

 
New Post
8/19/2008 4:38 PM
 

Jean-Marie,

i suspect that that change you made didn't actually fix your problem, it simply resolved the symptoms of another issue. If you make a change to the web.config file it forces an application unload - if enough app unloads have happened the application pool will also recycle. It's rare but sometimes an application pool becomes corrupt (usually through a memory leak - if the leak is small this can take a v.long time to occur), and this then causes the web app to stop working. I suspect that's whats likely to have happened - the app pool became corrupt and the change to the web.config forced it a new one to be created.

Cathal


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)


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