If I install SQL Server Express 2017 on Windows Server 2016 Essentials, what is the maximum number of users that will be able to connect concurrently across the network to the SQL Server Express instance?
Is is unlimited or does the operating system's limits of 25 users / 50 devices then kick-in?
Also, how does the o/s count concurrent users? e.g. if we have 2 users on different computers connecting to the SQL Server service using the same SQL Server credentials, will the o/s count them as 1 user on 2 devices (hence we can, in theory, get 50 users connecting to the database), or will they be counted as 2 users on 2 devices?
Note that I am not a DB administrator nor a network specialist, just a developer trying to install my first server and trying to understand whether the o/s connection limitations per user only apply to built-in operating system services (like NTFS file sharing) or whether they also affect connections to 3rd party application services like SQL Server Express.
e.g. if I install SQL Server Express on a Windows 2016 server that has 5 user CAL only, will the limit on concurrent connections be the 32K (approximately) set by SQL Server Express or will it be the 5 connections limit set by Windows Server?