Avatar of John Account
John Account asked on

SQL Server Express and dashCommerce Setup

I'm trying to setup dashCommerce on my dedicated server, of which I already had SQL Server Express Installed; however, I"m not sure if I had installed it with Advance Services or not. So I need Expert help in this area:
1. How can I determine if Advance Services is installed?
2. If it is installed, how can I change Authentication Mode from Windows Authentication Mode to Mixed Mode?
3. If I should uninstall the SQL Express Server 2005 and reinstall it with Advance Services, will everything fall back into place okay with all the existing websites on my dedicated server using .mdf databases in their respective App_Data folders?

Microsoft DevelopmentMicrosoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
John Account

8/22/2022 - Mon

Do not use SQL Express for anything other than Development.
SQL Express is designed to Fail Silently when under a significant load.
This is by design.
John Account

Are you serious?!

YES, AND Verified
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
John Account

Really?---who's verified that?
So...what you're suggesting, Banthor, is not to use SQL Server Express under a significant load? Can you define approx. how significant that load will be once SQL Server Express begins to silently fail? Thanks.

Someone had once told me that SQL Server Express could handle a significant amount of traffic, and that, unless I"m building a huge datastore, it should be fine for even heavy loads. But I am certainly open to what you have to say regarding this matter, Banthor.

While testing SQL Express for use in bedside monitors
We verified that when at an excess of 10 simultanous "active" spids there was a 10% fail rate.
The connection was closed without an error.
this was visible in Gaps in a Heart monitor -
So you can see we had to move on to another data store.

There is always the nature of the use, and the nature of the data.
SQL Express does perform well,
But it's intended purpose is development
and as a Local Machine/Distributed data store for more complex applications.
anything else is beyond the scope of the product.

John Account

Goodness Gracious, Banthor...I will certainly keep this in mind. Thanks.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Faizan Sarwar

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
John Account