فا
MSLicenseHub
Licensing hub

SQL Server

Microsoft's relational database engine. Licensed per physical core (4-core minimum per instance) or under the Server + CAL model for smaller deployments.

Also known as: MS SQL, SQL Server Standard, SQL Server Enterprise

Last reviewed by MSLicenseHub Licensing Desk on 2026-07-20.

At a glance

Licensing model
Per-core (4-core minimum) OR Server + CAL
Related entities
Software Assurance · Always On AG · Passive secondary rights · Enterprise edition · Standard edition

Compare options

SQL Server: Per-Core vs Server + CAL
AttributePer-CoreServer + CAL
Minimum purchase4 cores per instance1 server licence + 1 CAL per user/device
User/device limitUnlimitedCounted — each needs a CAL
Public/anonymous usersAllowedNot allowed
EditionsStandard, EnterpriseStandard only
Passive secondary1 free with active SA1 free with active SA
Best forWeb apps, BI, large user countsSmall internal apps with known users
Per-Core scales with hardware and is required for internet-facing or unknown-user workloads. Server + CAL is cheaper at small scale when every user/device can be identified.

In-depth articles

💰
8 Common Azure Hybrid Benefit Mistakes (and How to Avoid Them)

The Azure Hybrid Benefit is one of Microsoft’s most powerful cost-saving mechanisms, allowing you to leverage

Frequently asked questions

When is Software Assurance worth paying for?

Software Assurance (SA) adds roughly 25–29% per year on top of a perpetual Volume License. It is worth it when you actually use the benefits:

  • Version upgrades — the biggest benefit. Without SA, every major upgrade is a fresh purchase.
  • License Mobility — needed to run server workloads (SQL Server, SharePoint) on Azure or AWS using your existing license.
  • Azure Hybrid Benefit for Windows Server and SQL — saves roughly 40% on Azure VM and SQL DB pricing.
  • Training vouchers, planning services, 24/7 problem-resolution support.

SA is rarely worth it for desktop apps you do not plan to upgrade. It almost always pays for itself on Windows Server, SQL Server and Exchange Server in 3 years.

Full answer →
Can I use SQL Server Developer Edition in production?

No. Developer Edition is feature-equivalent to Enterprise but the license restricts use to development, testing and demonstration — never production workloads. The moment a real customer or business process depends on the data, you are out of compliance.

Microsoft enforces this in audits, and converting a Developer install to production after the fact is not a defense. If you need Enterprise features in production, license Enterprise. If Standard is enough, license Standard. For free production use with hard limits, SQL Server Express is the only legitimate path.

Full answer →
How does Windows Server core licensing work?

Windows Server 2019, 2022 and SE are licensed per physical core, sold in 2-core packs. The minimum is 16 cores per server — even if your hardware has fewer, you license to that floor.

Two more rules. Every processor must be licensed for at least 8 cores. The whole server is licensed even if Windows Server runs in only one VM — you do not get to license a slice. In virtualized environments, Standard gives you 2 VM rights per fully licensed server (stackable), Datacenter gives you unlimited VM rights.

Full answer →

Other licensing hubs

Windows ServerMicrosoft 365Office (perpetual)CSP (Cloud Solution Provider)