I have installed SQL Server 2016 Standard Edition on one of my VM last week to use one of the HR Software for my employees. We have around 500 Employees who are using HR Software in daily basic for checking their payroll, attendance, etc..
I have created dedicated SQL Accounts called "HRUser" and DB Connection String is using this account for HR Software.
Now I am planning to license my SQL 2016 STD license and I am not sure what kind of License I should purchase.
Is that possible to purchase SQL STD 2016 Base License with 1 user CAL (because connection string is using "HRUser"account only)?
(or) Do I have to buy SQL STD 2016 Base License with 500 user CAL?
(or) what is the best way to license?
I would be appreciated if anyone of you could help me for licensing. Thanks in advance.
Answer by JohnM ·
Verify any licensing guidance with your licensing provider. They will be able to officially validate any advice.
You can license SQL Server either by core or by server + cals.
Per core, you either license just the VM and how many cores it has or you can license the entire virtual host server which would allow you to run unlimited number of SQL Servers (limited to physical server constraints). Either license manner provides you unlimited number of users connecting to SQL Server, although again, you are limited to the physical constraints. SQL Server will only handle up to ~32k connections so there is a limitation.
Per server+cal you have to have a server cal and then cals for every user who is accessing the SQL even if its through an application like HR software. If you add more users you would need to purchase additional cals.
Hope that helps.