Which SQL server edition I need

Question

0.00/5 (No votes)

See more:

HELLO ALL,
I AM BUILDING a windows application that connected to sql database to store and update data.
the application will be installed on 40 user's device,i am gonna to install the sql server in one device to allow other device to connect to this device.
my question is: which edition of sql server i need is the express edition (free) can support this scenario?

What I have tried:

i search on internet about all editions, no one tells how many devices the epress support

Posted 30-Mar-18 10:23am

Member 13199484

Updated 30-Mar-18 14:22pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2018-03-30T10:47:00

Solution 1

Express edition can support multiple client connections just like standard version. The limitations are mainly the database size maximum, ability to use processor cores, maximum memory size etc.

Have a look at SQL Server 2017—Editions | Microsoft[^]

Posted 30-Mar-18 10:47am

Wendelius

Dave Kreskowiak · Accepted Answer · 2018-03-30T14:23:00

Solution 2

The problem isn't so much the limitations of the SQL Server edition, but the edition of Windows you're going to install the SQL Server on.

You can not install SQL Server on Home editions of Windows.

Workstation editions of Windows (non-server) also have inbound connection limits. On Windows 10 Pro, it's 20 machines, and a single machine can have multiple connections to the server going to different services, not just SQL Server, so you're not going to get 20 different machines connected at the same time.

If you're going to have 40 clients connecting to the database, the SQL Server better be installed on a Server edition of Windows.

Posted 30-Mar-18 14:23pm

Dave Kreskowiak

Comments

PIEBALDconsult 31-Mar-18 0:09am

Ah, but put a Web Service between the client and database, and then what?

Dave Kreskowiak 31-Mar-18 10:24am

Inbound connection limit still applies to Windows, just not to SQL Server. Granted, with 40 clients (and only 5 using it at a time), it's very unlikely the limit will be hit considering the short time an HTTP request is actually connected.

But, if an app is actually useful, how often does an app stay limited to X number of machines?

[no name] 31-Mar-18 7:12am

You wrote "You can not install SQL Server on Home editions of Windows" but MS docs say somethinh different:

Hardware and Software Requirements for Installing SQL Server 2016 | Microsoft Docs[^]

Dave Kreskowiak 31-Mar-18 10:18am

That's new. Previous versions, talking Standard here, couldn't be installed on Home editions.

[no name] 31-Mar-18 10:23am

Just read the link again and it looks like it has changed with W10. So < W10 your answer is very right

Dave Kreskowiak 31-Mar-18 10:25am

I haven't looked at the requirements myself in, probably, 6 years.

Frankly, I thought the Home editions were useless marketing bullshit anyway.

[no name] 31-Mar-18 10:27am

"Frankly, I thought the Home editions were useless marketing bullshit anyway"
Agree :-)

Member 13199484 31-Mar-18 8:56am

you are right, acctually i am not planning to get 20 device connected at the same time, my application is small and the maximum users will use it at the same time less than 5.

Dave Kreskowiak 31-Mar-18 10:21am

Yeah, watch how long it takes to violate that little rule.

No app stays "limited to only X users at a time".

An app I wrote at work is now going to be deployed to about 8,000 new machines on top of the 16,000 it's already on.

PIEBALDconsult 31-Mar-18 10:27am

Be sure to not leave the connections open when not in use. Open-use-close.
And/or provide a Web Service that the clients connect to.

Member 13199484 31-Mar-18 10:31am

i will insure that Open-Use-Close.
for web-service i will study the possibility of that