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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard
Previous
 
Next
New Post
3/4/2010 11:46 AM
 
Lars, It is my personal opinion after having many frustrated clients. Full blown SQL is far easier to manage if you need to do something. Express always caused headaches.

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
3/4/2010 12:05 PM
 

I have to say that I always recommend a full server version for any production work too, but we're running our intranet on SQL Express.  The reason is that I didn't have a SQL 2005/8 server I could create an instance on and DNN 5 wouldn't run on our SQL 2000 server.  With a few hundred users we're not having any issues, other than me cursing everytime I have to manage the server.  Unfortunately, the real world also has to deal with costs.

Jeff

 
New Post
3/4/2010 12:16 PM
 

I have never had any problems with the new express tools available. There are reasons for standard or web edition but a lot of sites could manage with the express edition.

 
New Post
3/4/2010 12:25 PM
 
Jeff, managing the server (express) was always the issue I and customers ran into. Once the site was up and running, assuming the instance of SQLExpress was configured in the default mode, things ran fine. But as soon as you wanted to connect to the DB then there were issues, sometimes the site wouldn't connect, sometimes the management tools wouldn't connect. I understand real world costs definitely dictate what is available, and SQL express can definitely help to keep those costs down.

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
3/4/2010 1:30 PM
 

SQL Server Express can be run as a windows service, just like the standard edition. It will llisten on the same tcp port as the standard edition. All tools that can connect to a standard edition can be connected to a express instance. There is no difference on how the service operates or how tools connect between the standard and express editions. Even the database images (files) can be moved between the standard and express editions.

Sounds like you have been using it as a file based database or the compact edition. The express edition is practically the same as the standard edition, but with some limitations on database size and what kind of load it can handle, If your customers site is within the limits, a standard edition is a waste of your customers money.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard


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