Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

PortalWebHosting
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)
Previous Previous
 
Next Next
New Post 8/19/2008 1:30 PM
Unresolved
User is offline Jean-Marie
22 posts
10th Ranked


DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error) 

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 2:38 PM
User is offline cathal connolly
2756 posts
www.cathal.co.uk
5th Ranked










Re: DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error) 

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

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  DotNetNuke Site Does Down After 2 Years of Perfect Uptime (Shows SQL Error)
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Faculty of Graduate and Postdoctoral Studies
At the graduate level, the University of Ottawa offers more than 180 graduate certificates, master's degrees and PhDs, as well as interdisciplinary programs such as Women's Studies and Canadian Studies. Many postdoctoral opportunities are available in both the sciences and the humanities. For further information, please consult the site of the Faculty of Graduate and Postdoctoral Studies.
www.grad.uottawa.ca
Vekkin Solutions
Vekkin Solutions provides complete website solutions and custom module development to churches and small businesses.
www.vekkin.com
Powered by Adcuent®.Com
Adcuent® Consulting & Technology offers custom development web applications and hosting projects under the brand of Powered by Adcuent®.Com
www.adcuent.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP