Products

Solutions

Resources

Partners

Community

About

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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Site always fails after inactivitySite always fails after inactivity
Previous
 
Next
New Post
8/7/2017 8:35 PM
 
Restarting of the AppPool is a completely normal part of operation.

I doubt it will be the cause of this.

Is the failure always "Cannot connect to the DB"? Or is it variable?

I have one suggestion. Do you connect to the SqlServer by IP address? Don't! If your machine has woken up today with a new IP address then the IP address in the connection string will be wrong. That could explain the symptoms.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
8/8/2017 12:30 AM
 

Sebastian and Richard, my apologies.

I failed to disclose what is probably and important piece of information.

I'm running the installation at dnndev.me.

Richard, the error is: "Connection To The Database Failed" and it is always that error.

It happened yet again as I stepped away from computer for a few hours and came back to that error.

I'd really like to get this running on my machine to learn from, rather than hosted somewhere.

Thanks for help guys.

Bob

 
New Post
8/8/2017 9:59 AM
 
Can you post us your Database connection string? If you use id/password in it then please obfuscate them.

Try logging in to the database from SSMS (Sql Server Management Studio) using the same credentials as your DNN connection string. I am assuming that you are using id/password security here. I don't know if you can do that using AppPoolIdentity.

You should be able to get in.

When DNN reports a failure try it again. You may get more useful information about why.

Also in the DB, look at the view vw_EventLog. Look for where it logs the connection failure. You'll need a query like this...

SELECT top 200 [LogGUID]
,[LogTypeKey]
,[LogConfigID]
,[LogUserID]
,[LogUserName]
,[LogPortalID]
,[LogPortalName]
,[LogCreateDate]
,[LogServerName]
,[LogProperties]
,[LogNotificationPending]
,[LogEventID]
,[ExceptionHash]
,[AssemblyVersion]
,[PortalId]
,[UserId]
,[TabId]
,[RawUrl]
,[Referrer]
,[UserAgent]
,[Message]
,[StackTrace]
,[InnerMessage]
,[InnerStackTrace]
,[Source]
FROM [dbo].[vw_EventLog]
order by LogCreateDate desc

Look at all the Message/Stacktrace colums for that error for clues.

Local installs work for hundreds, probably thousands of people; including me! There *has* to be something special your environment.


Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
8/8/2017 3:37 PM
 
There are no credentials in the cxn string
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
I can’t find the db in SSMS and am unable to attach or import it, always getting errors, so there is no Eventlog to look at.
Given what you’ve said, I’m thinking that there is something wrong with this installation? But the site does work. I was wondering why there was no dnn database in SSMS.
Confused.
Bob

 
New Post
8/8/2017 4:15 PM
 
Ok. I'm immediately suspicious of the AttachDbFilename etc. I can't say that it doesn't work, only that I have never tried it.

I have a script that does my installs so I am hazy on the exact details.

I suggest you try creating an empty db in SSMS and give the AppPoolIdentity account DB Ownership rights. Then in the install screen point the DNN Installer at that DB.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Site always fails after inactivitySite always fails after inactivity


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