SQL Licencing

  • I have been spending the last few days Familiarising myself with the latest version of SQL Server.

    My question relates to user and device CALS. Let’s say I had a company with 20 users/devices.

    I have 4 sql server 2017 standard installations on different servers. Would I need to purchase 20 licences for each individual sql server?

    So in theory 80 user CALs so each user can access the individual servers or is it like a windows server licensing and that as long as I have 20 users cals (lasted version with software assurance) that user can access any sql environment I have on my estate even if it is a earlier standard version?

    Cheers

  • Andrew.weckermann - Tuesday, April 10, 2018 2:38 PM

    I have been spending the last few days Familiarising myself with the latest version of SQL Server. My question relates to user and device CALS. Let’s say I had a company with 20 users/devices.I have 4 sql server 2017 standard installations on different servers. Would I need to purchase 20 licences for each individual sql server? So in theory 80 user CALs so each user can access the individual servers or is it like a windows server licensing and that as long as I have 20 users cals (lasted version with software assurance) that user can access any sql environment I have on my estate even if it is a earlier standard version?Cheers

    IIRC the device/user cal allows a single user or device to connect to multiple servers.  If you have 20 users and 4 servers you would only need 20 user cal's.

  • This was removed by the editor as SPAM

  • Lynn is correct. Each user needs a CAL. They can access all the servers.

    20 users, 4 (or 5, or 6, or  7 ) instances - Need 20 CALs

    30 users, 20 access 4 instances, 10 access those 4 + 1 other instance. Need 30 CALs.

    30 users, 20 access 4 instances.  8 access a different instance. 2 don't access SQL - 28 CALs.

  • If the SQL Server instance is a backend of a publicly available web site you won't be able to use CAL licenses. Only processors license is applicable in this case. My 1 penny.

    There is official explanation on CAL licensing from Microsoft - https://www.microsoft.com/en-us/licensing/product-licensing/client-access-license.aspx

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply