SQLTeam.com | Weblogs | Forums

Technical limitations when using Windows 10 as the Host OS for running Sql Server Standard edition

SQL Server 2014 Standard edition shows Windows 10 as compatible OS. SQL Server allows a maximum 32767 concurrent connections concurrent connections, but Windows 10 OS has a limit on concurrent connections for file & printer and the limit appears to be 20.
We checked the official FAQ at "http://download.microsoft.com/download/A/5/9/A599711B-6807-4757-B38D-1EE269F2F19B/FAQs-Product-Licensing.pdf".

Can I use Windows Pro or Enterprise like a "server" to host applications?
No. The Windows desktop operating system can't be used as a "server." Device connection is allowed only for certain purposes (such as File Services, Print Services, Internet Information Services, Internet Connection Sharing, and Telephony Services).

As mentioned in windows 10 license terms

Device connections.
You may allow up to 20 other devices to access the software installed on the licensed device for the purpose of using the following software features: file services, print services, Internet information services, and Internet connection sharing and telephony services on the licensed device. You may allow any number of devices to access the software on the licensed device to synchronize data between devices. This section does not mean, however, that you have the right to install the software, or use the primary function of the software (other than the features listed in this section), on any of these other devices."

The Device connections section mentions "You may allow any number of devices to access the software on the licensed device to synchronize data between devices."

Does this mean that the 20 concurrent connection limit of Windows 10 does not apply to SQL server that is hosted on it? Since it is TCP connection, I don’t think any technical limitation is there. But would it be allowed legally as well?

What is is the purpose of this device on which sql server needs to be installed? Why would you host applications on it? Can you please expound on your use case