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?
Thanks.
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?
Thanks.
ASKER
Are you serious?!
YES, AND Verified
ASKER
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.
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.
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.
ASKER
Goodness Gracious, Banthor...I will certainly keep this in mind. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THanks.
SQL Express is designed to Fail Silently when under a significant load.
This is by design.