Share via

Running SQL Server Express on Windows 11 with 10 client PCs

AndyJames 40 Reputation points
2023-08-10T10:50:22.9366667+00:00

Hi,

I'm setting up a machine that will be running a SQL Express 2019 server and having 10 client PCS.

I think I'm correct with this that Windows 10 or 11 will be fine for that number of devices connecting both to SQL and SMB shares, as from what I can see Windows 10/11 supports 20 connected devices for things like File and Print Sharing.

I've used this setup previously for very small 4 or 5 machine networks and it has been fine.

I don't particularly want to go down the router of Windows Server 2019/2022 as they don't need a DC.

I think I'm doing my usual of overthinking things and creating confusion in my mind.

So what I'm asking is: Will Windows 10 or 11 suffice for a 10 to 12 device network?

Windows for business Windows Client for IT Pros Networking Network connectivity and file sharing
Windows for business Windows Client for IT Pros User experience Other
SQL Server Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2023-08-10T11:04:15.35+00:00

    I can't see any real question here?

    Yes, SMB limit on Win 11 is 20 and SQL Server (Express) connection limit is 32,767

    https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.