Tom Franz, Integrity DataWhile at Microsoft Convergence 2015, I had a customer ask me a good question…“Do self-service users need a SQL CAL (client access license) to use the new employee self-service functionality?”  The answer to this is: “maybe.” SQL CAL’s currently cost about $150 each. The cost of a self-service user for Microsoft Dynamics® GP is set to $60 per named user. But, if self-service users require a SQL CAL, that advertised cost is more than tripled.

For clarity, if users login to Dynamics GP with the traditional “rich” client or via terminal services, they will need a SQL CAL, however, if they use web client to access Dynamics GP, a SQL CAL is not required because technically they are accessing the system via a system account. That system account requires a SQL CAL, but the users do not.

Why is this important?

The answer to this is probably apparent now that we know that there is an additional per user cost when accessing Dynamics GP outside of web client. When planning the use of this new self-service functionality, you will want to consider the costs and plan accordingly.


UPDATE: We received the following additional clarification on this sometimes confusing topic:

Microsoft SQL Server Runtime Licensing
Question: Would you clarify SQL Runtime Licensing and how it works with Microsoft Dynamics GP?

  • Server Licenses AND CALs or Core Licenses
    • Each Server Licenses allows you to deploy the software on one physical or virtual machine
    • Each CAL grants one user or one device (but not both) the right to access the software
    • SQL CALs are not “Concurrent” – not ever – Jamais – 从来没有 – Aldrig – Nunca – ابدأ
    • Each user accessing GP directly or indirectly via are GP client or via Business Portal or via Management Reporter or via any other mode must be licensed with a SQL CAL
  • Runtime – What’s that about?
    • Runtime is not simply SQL at a cheaper price for the great Dynamics partners
    • Runtime is a VL program for Unified Solutions which offers lower prices for restricted rights:
    • Only for use with the Unified ERP -> e.g. NOT Microsoft Dynamics CRM
    • No License Mobility -> May not be installed on a VM in a Data Center (this includes Microsoft Azure)
    • No BREP Reenrollment -> Customers falling off BREP need to (re)license upgrades

Detailed Information on SQL Server Runtime can be found on PartnerSource here.


by Tom Franz, Product Manager at Integrity Data