Editorial photograph of a database team reviewing Microsoft SQL Server core licensing
Microsoft · SQL Server · Licensing

SQL Server licensing decoded. The 2026 buyer guide to the core, the CAL, and the cloud edition.

Core based licensing, Server plus CAL, Software Assurance, virtualization rights, BYOL to Azure, and the buyer side moves that hold the renewal honest.

Contact Us Microsoft Practice
500+Enterprise clients
$2B+Under advisory
Industry Recognized
500+ Enterprise Clients
$2B+ Under Advisory
11 Vendor Practices
100% Buyer Side Independent

Microsoft SQL Server is licensed two ways, with two metric units, four editions, and a Software Assurance overlay that determines where the rights actually sit. The 2026 buyer view starts with the edition choice and ends with a clean Software Assurance posture.

Key takeaways

  • SQL Server 2022 has four editions: Enterprise, Standard, Web, and Developer. Each carries different feature sets and different license models.
  • Core based licensing applies to Enterprise and to Standard. The minimum is four cores per physical processor or per virtual machine.
  • Server plus CAL licensing is available for Standard edition only. It pencils for small estates with high server to user ratio.
  • Software Assurance is the overlay that grants version upgrades, license mobility, virtualization rights, and the cloud BYOL benefit. Without SA, the rights stop at the contract signature.
  • Virtualization rights depend on edition and on SA. Enterprise plus SA grants unlimited virtualization on a fully licensed host. Standard requires per VM licensing.
  • BYOL to Azure is enabled by Azure Hybrid Benefit, which requires active Software Assurance or a SQL subscription license.
  • Audit traps cluster around virtual machine sprawl, passive failover misconfiguration, and the Developer edition slipping into production.
  • Buyer side moves: edition rationalization, core count audit, Software Assurance retention case, virtualization rights restructure, Azure Hybrid Benefit posture, and the multi year cap.

Microsoft SQL Server is the relational database product that anchors most enterprise Microsoft estates. The licensing model is one of the more nuanced in the Microsoft portfolio because the edition choice, the metric model, and the Software Assurance overlay each move the math.

This guide covers SQL Server 2022 licensing for the 2026 renewal cycle, the core based and Server plus CAL metric models, Software Assurance posture, virtualization rights, Azure Hybrid Benefit, and the audit posture that holds the renewal clean.

Read the related Microsoft knowledge hub, the Microsoft advisory practice, and the Microsoft EA renewal playbook for the wider 2026 leverage framework.

SQL Server editions and rights

Enterprise edition

Enterprise is the top tier with the full feature set: unlimited cores, advanced security, AlwaysOn availability groups, advanced analytics, and in memory OLTP.

Enterprise is the right answer for the mission critical workload that needs the full availability and analytics feature set. The list rate is roughly four times Standard.

Standard edition

Standard is the volume tier. It supports up to twenty four cores per instance, basic availability groups, and the common feature set used by most enterprise applications.

Standard is the correct answer for the majority of the estate. Procurement teams routinely buy Enterprise for workloads that have no need for the advanced feature set.

Web and Developer editions

Web edition is the hosting service provider edition, licensed only through the Services Provider License Agreement. It is rarely seen outside of hosted environments.

Developer edition is the free edition with the full Enterprise feature set, restricted to development and test use. The audit trap is the Developer edition that drifts into production.

Core based licensing model

Physical core licensing

Core based licensing requires one core license per physical processor core on the host. The minimum is four cores per physical processor.

Core licenses are sold in two core packs. A typical sixteen core server requires eight two core packs at the edition rate.

Virtual machine licensing

A virtual machine on Standard or Enterprise edition can be licensed by the virtual core count. The minimum is four virtual cores per VM.

Virtual cores must align to physical cores including hyper threading. A virtual machine sized at three virtual cores still licenses at the four core minimum.

Indicative core pricing

  • Enterprise edition. Around 14,256 United States dollars per two core pack at list.
  • Standard edition. Around 3,717 United States dollars per two core pack at list.
  • Enterprise CAL combination. Server license plus per user or per device CAL, available for legacy estates only.
  • Software Assurance uplift. Around twenty five percent of the license price per year, paid annually.

SQL Server 2022 edition comparison at a glance

Edition Metric Min cores Virtualization Indicative list per 2 core pack
EnterpriseCore basedFour per VM or processorUnlimited with SA on full hostAround 14,256 USD
Standard coreCore basedFour per VM or processorPer VM licenseAround 3,717 USD
Standard Server CALServer plus CALN or APer VM licenseAround 931 USD plus CALs
WebSPLA onlyHoster onlyHoster managedHoster rate
DeveloperFree non productionNoneNon production onlyZero

Server plus CAL model

When Server plus CAL pencils

Server plus CAL is available for Standard edition only. The model fits estates with a small named user pool against a Standard edition server.

The break even sits around twenty five named users per Standard edition server. Above that, core based pricing wins on the same workload.

Mixed model traps

Mixing Server plus CAL with core based across the same estate creates a documentation burden. The audit teams require evidence for each license model on each server.

Procurement should standardize on one model across the SQL Server estate. The exception is the legacy departmental application that genuinely sits at low user count.

Software Assurance rights

What Software Assurance grants

  • Version upgrades. The new version of SQL Server at no incremental license cost.
  • License mobility. The ability to move licenses across server hardware on demand.
  • Virtualization rights. Unlimited VM density on a fully licensed Enterprise host.
  • Azure Hybrid Benefit. The ability to bring SQL Server licenses to Azure SQL Database, Managed Instance, or VMs.
  • Failover server rights. A passive failover instance at no additional license cost, provided the configuration meets the documented criteria.

Software Assurance renewal decision

Software Assurance is renewed annually at roughly twenty five percent of the underlying license cost. The renewal is the moment to test the retention case.

The case for retention is the version upgrade right, the virtualization rights for VM heavy estates, and the Azure Hybrid Benefit for any cloud migration. The case to drop is the static workload with no cloud trajectory.

Virtualization rights and density

Enterprise plus Software Assurance

Enterprise edition with active Software Assurance unlocks unlimited virtualization on a fully licensed host. Every physical core is licensed, and an unlimited number of SQL Server VMs can run on the host.

The right move for VM dense workloads is to license the host fully under Enterprise plus SA and consolidate the SQL footprint onto the licensed hosts.

Standard edition virtualization

Standard edition does not unlock unlimited virtualization. Each VM is licensed individually at the four virtual core minimum.

On a VM dense Standard edition workload, the per VM cost compounds quickly. The Enterprise plus SA host model often wins above four to six SQL VMs per host.

Database administrators reviewing a SQL Server licensing report on a wall display in a boardroom
SQL Server renewals are won and lost on edition rationalization and the Software Assurance retention case. Independent oversight surfaces both before the contract closes.
We inventoried our SQL Server estate ahead of the EA renewal. Forty two percent of our Enterprise edition cores carried workloads that ran cleanly on Standard. Redress structured the rationalization, the virtualization restructure, and the Azure Hybrid Benefit posture. The combined renewal landed nineteen percent under the prior year baseline.

Azure Hybrid Benefit

Azure Hybrid Benefit eligibility

Azure Hybrid Benefit allows SQL Server core licenses with active Software Assurance to be applied to Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.

The benefit reduces the pay as you go Azure SQL rate to the base compute rate, saving roughly fifty five percent on the equivalent license included rate.

Conversion ratios

Enterprise core licenses convert to four vCores of Azure SQL Database General Purpose tier, or one vCore of Business Critical tier per core.

Standard core licenses convert to one vCore of Azure SQL Database General Purpose tier per core. The Business Critical conversion requires the Enterprise license stack.

Audit traps to watch

Virtual machine sprawl

VM sprawl is the most common audit finding. A SQL Server VM that runs on a host without the right edition and SA stack triggers a full host license requirement on the audit.

Document every SQL Server VM with its host, edition, and SA status before any Microsoft engagement that could open an audit conversation.

Passive failover misconfiguration

Passive failover servers carry strict configuration requirements to qualify for the no cost license. The auditors check the configuration before granting the benefit.

Any active workload on the failover, including read replicas, breaks the no cost benefit. The license then applies to the failover at full rate.

Developer edition drift

Developer edition is free for non production use only. Audit finds the Developer instance carrying production traffic on a regular cadence.

Run a monthly scan that flags Developer edition instances on production networks. The remediation is to upgrade to a licensed edition before the audit lands.

Buyer side moves at renewal

Top seven moves

  • Edition audit. Inventory every SQL Server instance and confirm the edition matches the workload need.
  • Core count reconciliation. Pull the SQL Server license report and reconcile against the production host core count.
  • Software Assurance retention case. Document the version upgrade, virtualization, and Azure Hybrid Benefit value before deciding to drop SA.
  • VM density restructure. Move VM dense workloads to fully licensed Enterprise plus SA hosts.
  • Azure Hybrid Benefit posture. Apply the benefit to every eligible Azure SQL workload.
  • Developer edition scan. Monthly scan for Developer instances on production networks.
  • Multi year cap. Negotiate the uplift cap in writing on the order form.

Operating moves between renewals

The mid term operating discipline is where the structural cost discipline lives. Quarterly SQL inventory reconciliation, the VM sprawl audit, and the Azure Hybrid Benefit utilization review keep the estate clean.

Read the related Microsoft EA renewal playbook for the cross product framework.

Suggested reading

What to do next

  1. Inventory every SQL Server instance with edition, core count, and host configuration.
  2. Identify Enterprise edition cores running workloads that fit Standard edition.
  3. Document the Software Assurance retention case across version, virtualization, and cloud value.
  4. Restructure VM dense workloads onto fully licensed Enterprise plus SA hosts.
  5. Apply Azure Hybrid Benefit to every eligible Azure SQL workload.
  6. Run the monthly Developer edition scan against production networks.
  7. Negotiate the uplift cap in writing on the order form before signing.
  8. Engage the Microsoft advisory practice for the joint renewal posture.

Frequently asked questions

How is SQL Server 2022 licensed?

SQL Server 2022 is licensed by the core for Enterprise and Standard editions, or by Server plus CAL for Standard edition only. The core based model requires a minimum of four cores per physical processor or per virtual machine.

What does an Enterprise core license cost?

A SQL Server 2022 Enterprise two core pack lists at around 14,256 United States dollars. Standard two core pack lists at around 3,717 dollars. Software Assurance adds roughly twenty five percent of the license rate per year.

Do we need Software Assurance?

Software Assurance grants version upgrades, license mobility, virtualization rights, the Azure Hybrid Benefit, and passive failover rights. The retention case is strong for VM dense estates and for any cloud trajectory. Static workloads with no upgrade plan can drop SA.

What is the Azure Hybrid Benefit?

Azure Hybrid Benefit applies on premises SQL Server licenses with active Software Assurance to Azure SQL Database, Managed Instance, or VMs. The benefit reduces the pay as you go rate by roughly fifty five percent.

How does virtualization licensing work?

Enterprise plus Software Assurance grants unlimited VM density on a fully licensed host. Standard edition requires per VM licensing at the four virtual core minimum. Mixed model estates carry a documentation burden at audit.

Can Developer edition run in production?

No. Developer edition is licensed for development and test use only. A Developer instance carrying production workload triggers a full edition license requirement on audit.

What is the passive failover benefit?

An active SQL Server license with Software Assurance grants one passive failover instance at no incremental cost, provided the failover meets the documented configuration criteria. Any active workload on the failover, including read replicas, breaks the benefit.

How do we benchmark a SQL Server renewal?

Pull the SQL Server license report from System Center, reconcile against the production host inventory, and compare against the Microsoft EA renewal playbook benchmarks. The Redress Microsoft practice runs the joint audit on every engagement.

Microsoft EA Renewal Playbook

The full microsoft ea renewal playbook framework from the Microsoft Practice.

Microsoft renewal posture, EA framework, SQL Server licensing, M365 SKU framework, Copilot framework, SPLA hosting, and the buyer side moves across the full Microsoft estate.

Used across more than five hundred enterprise engagements. Independent. Buyer side. Built for procurement leaders running the next renewal cycle.

No spam. We will only email you about this download. Privacy.
Run the Microsoft 365 license optimizer against your estate in under five minutes.
Open the Tool →
4
Min cores per instance
25%
SA annual rate
55%
AHB cloud saving
19%
Typical renewal saving
100%
Buyer Side

Our SQL Server licensing was a black box. Forty percent of our Enterprise cores carried workloads that ran fine on Standard. The advisory restructured the edition mix, locked the virtualization rights, and applied Azure Hybrid Benefit to the cloud footprint. The EA renewal landed nineteen percent under our prior baseline.

Director of Database Operations
Global insurance group
Deep Library

More on this topic.

Microsoft Practice →
Microsoft EA renewal playbook
Microsoft · Playbook
Microsoft EA Renewal Playbook
The full Microsoft EA renewal framework for 2026.
22 min read
Microsoft knowledge hub
Microsoft · Hub
Microsoft Knowledge Hub
The full Microsoft intelligence library across SQL, M365, and Azure.
28 min read
M365 license optimizer
Microsoft · Tool
M365 License Optimizer
Interactive seat optimization calculator across the Microsoft estate.
5 min read
Microsoft CSP knowledge hub
Microsoft · Hub
Microsoft CSP Knowledge Hub
The buyer side hub on Microsoft CSP, NCE, and partner economics.
24 min read
Microsoft advisory practice
Microsoft · Practice
Microsoft Advisory Practice
Independent buyer side Microsoft advisory across the full estate.
14 min read
Editorial boardroom interior

The advisor your vendors do not want.

500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.

Microsoft intelligence, monthly.

SQL Server edition moves, Software Assurance posture, Azure Hybrid Benefit framework, and the wider Microsoft leverage signals across the practice.