Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...SQL Express - File v Database?SQL Express - File v Database?
Previous
 
Next
New Post
3/20/2008 5:00 PM
 
David Toohey


Joined: 1/30/2007
Posts: 690

Carlos & Jeff

That is great so thank you both.  It is much clearer... I am new to the Express version, and the user instance (new DNN install alongside older one).

Looking to switch from a shared SQL server to Express running on my own dedicated server (more control, space etc) so I had been unsure (mostly performance) if there was a lot of difference between the user instance and SQL instance. Now I know it just depends on my needs and performance is not too much of an issue.

Cheers!
 
New Post
3/21/2008 1:07 AM
 
Carlos Rodriguez

www.almacigo.com
Joined: 6/10/2003
Posts: 615

David:

One feature about Express you may want to research is that by default it sets the databases to "Auto Close" after the last user disconnects and a period of inactivity .  This may or may not be a big issue to you if the site has a lot of traffic or if you use a keepalive solution.  The overhead is probably not very noticeable in a modern server anyway.  The true SQL Server engine will keep the file open all the time of course.

Carlos

 
 
New Post
3/21/2008 5:50 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

please also have a look at this blog post from Shawn Mehaffie: http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryID/1202/Default.aspx

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/21/2008 7:09 AM
 
David Toohey


Joined: 1/30/2007
Posts: 690

Thanks for that Carlos. I had seen some mention of it before and will just have to see how it affects us and deal with it then.

Sebastian, Thanks... I did look at that blog post, and I have an unresolved thread here relating to it.

The problem I am having (outlined in the thread) is bringing a SQL instance from SQL Server to SQL Express... can get it working (Integrated Security only) but without any users at all able to log in.

Cheers
 
New Post
3/21/2008 7:18 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

if the site is showing up but users cannot login, the issue is not  cause by the database, but by authentication, make sure, that the machine key in your web.config hasn't been changed, if you tried to access your database w/o valid connection string, the installer shows up and alters the machinekey. Another problem can be a damaged cookie in your browser.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 2 of 3
Previous123Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...SQL Express - File v Database?SQL Express - File v Database?


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