MICROSOFT PARTNER

SQL Server 2025 Licensing Explained: Core Licensing, CALs and Editions

SQL Server 2025 licensing guide comparing core licensing, CALs and editions

SQL Server 2025 licensing becomes much easier to understand once you separate three decisions that are often mixed together:

edition -> licensing model -> required quantity

First decide whether the workload belongs on SQL Server 2025 Standard or Enterprise. Then determine which licensing model is available and appropriate. Only after that should you calculate how many licenses or core packs the deployment requires.

At a high level, SQL Server 2025 uses two important commercial licensing approaches:

  • Per Core licensing for SQL Server 2025 Standard and Enterprise
  • Server + CAL licensing for SQL Server 2025 Standard

Enterprise should not be treated as a Server + CAL option for a new SQL Server 2025 deployment.

Virtual machines add another layer because licensing a VM and licensing the underlying physical server are different approaches, and some virtualization, mobility and failover rights depend on Software Assurance, subscription status or other licensing conditions.

That makes one principle especially important:

Do not choose a Wholsalekeys product simply because its page says 2 Core, 16 Core, Standard or Enterprise. First establish what your architecture actually requires.

Table of Contents

SQL Server 2025 Licensing at a Glance

The differences that matter most are not every item in the feature matrix. They are the changes that affect capacity, development, workload management and upgrade planning.

DecisionSQL Server 2025 StandardSQL Server 2025 Enterprise
Per Core licensingYesYes
Server + CAL licensingYesNo for current new licensing scenarios
User/device counting required under Per CoreNoNo
CALs required under Server + CALYesNot applicable as a current new Enterprise model
Core packs relevantYes when using Per CoreYes
Physical server licensingPossiblePossible
VM licensingPossible, subject to applicable rulesPossible, subject to applicable rules
Virtualization benefitsDepend on licensing conditions and entitlementsNew capability does not remove migration risk
Best first questionCore or Server + CAL?How will the required cores/virtualization be licensed?

This is why licensing begins with architecture rather than shopping cart quantity.

Step 1 - Choose Standard or Enterprise Before You Calculate Licenses

Licensing cannot be separated completely from edition selection.

SQL Server 2025 Standard and Enterprise are designed for different workload requirements, and the licensing options available to each edition are not identical.

SQL Server 2025 Standard

Standard is the more flexible edition from a licensing-model perspective because it can be licensed using either:

Per Core

or

Server + CAL

That choice can matter substantially.

A server used by a controlled number of known employees may create a very different licensing question from a public-facing application accessed by thousands of unpredictable users.

SQL Server 2025 Enterprise

For current new SQL Server 2025 Enterprise deployments, the relevant licensing model is Per Core.

That means the licensing calculation centers on the compute architecture rather than counting individual users or devices accessing SQL Server.

Enterprise should therefore be chosen because the architecture requires its capabilities, scale or relevant deployment rights, not simply because an organization would prefer to avoid CAL counting.

If edition selection is still unresolved, read our SQL Server 2025 Standard vs Enterprise guide first. Licensing becomes much easier once that decision has been narrowed down.

What Is SQL Server 2025 Per Core Licensing?

Per Core licensing licenses the compute resources running SQL Server rather than licensing each individual person or device that accesses it.

This can be attractive when access is:

  • broad
  • external
  • public-facing
  • difficult to count
  • constantly changing
  • spread across many users and devices

The central advantage is that you do not need a SQL Server CAL for every accessing user or device under the Per Core model.

Core packs are units of licensing

SQL Server core licenses are commonly packaged in multi-core units, including 2-core packs.

That distinction is important.

A product labeled “2 Core” should not be interpreted as:

“Buy one package and every SQL Server installation is licensed.”

It means the product represents a quantity of core licensing that contributes toward the deployment’s calculated requirement.

The infrastructure determines how many cores must be licensed. The product pack is then used to satisfy that requirement.

Minimum-core rules still matter

Core licensing is not always as simple as counting whatever number appears in a virtual-machine settings screen or server specification.

Minimum licensing requirements can apply depending on whether you are licensing physical infrastructure or individual virtual machines.

That means a very small VM should not automatically be assumed to require only one core license simply because it has one virtual processor configured.

Before purchasing, verify:

  • physical or virtual deployment
  • processors and cores involved
  • minimum-core requirements
  • edition
  • number of SQL Server workloads
  • whether any Software Assurance or subscription-dependent rights are part of the design

This is why the safest sequence is calculate first, purchase second.

What Is SQL Server 2025 Server + CAL Licensing?

Server + CAL approaches the problem differently.

Instead of primarily licensing the processor cores, the organization licenses the SQL Server and then licenses the users or devices that access it according to the applicable rules.

For SQL Server 2025, this option applies to Standard Edition.

What is a SQL Server CAL?

CAL stands for Client Access License.

Conceptually, there are two access patterns to understand:

User CAL: associated with a user who accesses SQL Server.

Device CAL: associated with a device used to access SQL Server.

The appropriate choice depends on how people actually work.

When a User CAL concept tends to make sense

Imagine an employee who uses:

  • an office desktop
  • a company laptop
  • a tablet

If the licensing analysis is based on named users, counting that person may be more logical than independently counting every device the employee uses.

When a Device CAL concept tends to make sense

Now imagine a warehouse with a smaller number of shared terminals used by many employees across several shifts.

The access pattern is completely different.

A device-oriented model may deserve investigation because many workers are accessing SQL Server through a smaller set of shared machines.

The correct choice should be based on the real access pattern and the applicable license terms rather than a blanket statement that User CALs or Device CALs are always cheaper.

SQL Server 2025 Core vs CAL Licensing

The simplest distinction is this:

Per Core: license the relevant compute resources.

Server + CAL: license SQL Server Standard plus the users or devices that need access.

Consider the business implications.

EnvironmentModel worth investigating firstReason
25 known employees accessing one internal SQL applicationServer + CAL or Per CoreAccess is countable, so both deserve comparison
Public website backed by SQL ServerPer CoreExternal users may be numerous or unpredictable
Business application accessed by thousands of employeesPer Core deserves strong considerationCAL counting can become operationally complex
Small office with known usersServer + CAL may be practicalUser population can be clearly defined
Shared-device warehouseServer + CAL with Device CAL analysisDevices may be more predictable than individual users
Enterprise Edition deploymentPer CoreServer + CAL is not the current new Enterprise licensing model
Highly virtualized SQL estateDetailed Per Core analysisVM and physical-host licensing architecture becomes important

This table identifies what to investigate. It does not substitute for a final licensing calculation

User CAL vs Device CAL: Think About Access Patterns

Choosing between User and Device CAL concepts should not be based only on employee headcount.

Ask who accesses SQL Server and how they access it.

Example: office employees with multiple devices

Suppose 30 employees each have:

  • a desktop computer
  • a laptop
  • occasional mobile access

The number of devices could exceed the number of people considerably.

A user-oriented access model may therefore deserve investigation.

Example: factory floor with shared terminals

Suppose 90 employees rotate through 15 fixed workstations across several shifts.

The number of people is much larger than the number of access devices.

A device-oriented licensing analysis may make more sense.

Example: mixed workforce

Now consider:

  • 20 office staff
  • 25 warehouse staff
  • contractors
  • shared warehouse terminals
  • managers working remotely

This is no longer a simple headcount exercise.

Map the actual access paths before deciding which licensing approach fits.

Do Indirect Users Still Matter?

One of the most dangerous assumptions in Server + CAL planning is:

“The user never connects directly to SQL Server, so the user does not count.”

Modern applications often place other software between users and the database.

For example:

User -> web application -> application server -> SQL Server

or:

Employee -> ERP system -> middleware -> SQL Server

A middle application does not automatically make underlying SQL Server access disappear from the licensing analysis.

This area is often described as indirect access or multiplexing and should be checked carefully against the applicable licensing terms.

Do not design a CAL strategy around the assumption that pooling connections through one service account converts many users into one SQL Server user.

Physical SQL Server Licensing vs Virtual Machine Licensing

Virtualization is where SQL Server licensing can become considerably more architectural.

There are two very different questions:

  1. Are you licensing individual virtual machines?
  2. Are you licensing the physical server that hosts the SQL workloads?

Those approaches should not be mixed casually.

Licensing individual SQL Server VMs

Imagine a virtualization host running several VMs, but only one VM contains SQL Server.

Licensing the SQL workload at VM level may be an approach to investigate.

The calculation depends on the virtual cores assigned and the applicable minimum licensing rules.

Adding more virtual CPU to the SQL VM can therefore affect licensing requirements.

That is an architectural consideration, not merely a performance setting.

Licensing physical infrastructure

In more heavily consolidated environments, organizations may evaluate licensing SQL Server at the physical-host level instead.

This becomes particularly important when SQL Server Enterprise, virtualization density and rights associated with certain licensing programs are involved.

However, phrases such as “unlimited virtualization” should never be assumed merely because the product is Enterprise Edition.

Those benefits can depend on additional licensing conditions.

Software Assurance and Subscription Rights Must Be Treated Separately

A SQL Server product license and additional licensing-program benefits are not necessarily the same thing.

Some Microsoft licensing rights associated with areas such as:

  • virtualization
  • VM reassignment
  • mobility
  • failover
  • hybrid use
  • physical-host virtualization

may depend on Software Assurance, subscription licensing or other specific conditions.

SQL Server 2025 Licensing Scenario 1 - Small Internal Business Application

Consider a fictional company with:

  • SQL Server 2025 Standard
  • one internal business application
  • one server
  • 18 employees who use the system
  • no public or customer access
  • predictable user population

The organization has two licensing approaches worth evaluating.

Option A - Server + CAL

Because Standard supports Server + CAL licensing and the user population is known, Server + CAL deserves consideration.

The company would need to determine which users or devices require access and choose the appropriate CAL structure.

Option B - Per Core

The same Standard deployment could instead use Per Core licensing.

In that case the analysis moves away from employee counting and toward the compute resources running SQL Server

What must be confirmed

Before choosing, confirm:

  • exact Standard licensing model being purchased
  • number and type of users/devices requiring access
  • indirect application access
  • physical or virtual SQL Server deployment
  • required licensed core quantity if choosing Per Core
  • exact entitlements of the Wholsalekeys SKU

The important lesson is that Standard does not force this company into one licensing model.

The access pattern should drive the comparison.

SQL Server 2025 Licensing Scenario 2 - Customer-Facing Web Application

Consider a fictional online platform with:

  • SQL Server 2025 Standard
  • a customer-facing web application
  • thousands of potential users
  • new users appearing continuously
  • customers accessing from unpredictable devices

Trying to build the licensing model around counting individual customers or devices would create a very different operational problem from the previous scenario.

Per Core deserves investigation

Per Core licensing removes the need to license every individual accessing user or device under that model.

The organization instead determines the core licensing requirement of its SQL Server deployment.

For an internet-facing application, that can make the licensing architecture easier to manage.

What must be confirmed

Confirm:

  • Standard versus Enterprise technical requirements
  • physical versus virtual deployment
  • number of relevant cores
  • applicable minimum-core rules
  • scaling plans
  • high-availability design
  • exact rights included in the purchased license

Do not purchase a 2-core or 16-core pack until the actual core requirement has been calculated.

SQL Server 2025 Licensing Scenario 3 - SQL Server in a Virtual Machine

Consider a fictional infrastructure team running SQL Server 2025 Standard in a VM.

The VM is hosted on a larger virtualization server alongside many unrelated workloads.

The SQL administrator wants to increase the VM’s CPU allocation because application demand is growing.

That sounds like a routine infrastructure change.

From a licensing perspective, it deserves another look.

Virtual CPU allocation can affect licensing analysis

When SQL Server is licensed at the individual VM level under Per Core licensing, the virtual compute assigned to the SQL workload is part of the licensing calculation, subject to applicable minimums and conditions.

Increasing VM compute should therefore trigger both:

  • capacity review
  • licensing review

What must be confirmed

Before changing the environment, confirm:

  • VM-level versus physical-host licensing
  • number of virtual cores assigned
  • applicable minimum-core requirement
  • Standard or Enterprise edition
  • mobility requirements
  • whether any rights being relied upon require Software Assurance or subscription licensing
  • exact Wholsalekeys SKU entitlement

This prevents an infrastructure team from treating licensing as something that only matters during the original installation.

SQL Server 2025 Licensing Scenario 4 - Highly Virtualized Enterprise Environment

Now consider a fictional organization running:

  • SQL Server 2025 Enterprise
  • multiple SQL Server VMs
  • a virtualization cluster
  • mission-critical databases
  • VMs that may need to move between hosts
  • plans to increase SQL workload density

This is not simply:

number of SQL VMs x product price

The organization needs an architecture-level licensing review.

Questions to resolve

The team should determine whether its strategy involves:

  • licensing individual VMs
  • licensing physical hosts
  • maintaining Software Assurance or equivalent qualifying subscription benefits
  • VM mobility requirements
  • failover infrastructure
  • future VM density
  • host movement or cluster design

Only after those questions are answered should it calculate the required Enterprise core licensing.

What must be confirmed

Confirm:

  • exact physical server architecture
  • cores per relevant host
  • virtual SQL estate
  • VM movement requirements
  • high-availability design
  • Software Assurance or subscription status
  • virtualization rights being relied upon
  • exact Enterprise SKU rights

For this type of environment, Enterprise may make technical sense, but purchasing the correct number of core packs still requires an infrastructure-level licensing calculation.

How Do 2-Core and 16-Core SQL Server Products Fit Into the Calculation?

Wholsalekeys provides SQL Server 2025 products in different core quantities.

For Standard Per Core deployments, current product options include:

SQL Server 2025 Standard 2-Core License

and

SQL Server 2025 Standard 16-Core License

For Enterprise deployments:

SQL Server 2025 Enterprise 2-Core License

and

SQL Server 2025 Enterprise 16-Core License

The difference is licensing quantity, not a different SQL Server feature edition.

Example of pack planning

Suppose your completed licensing analysis determines that you need a particular number of licensed cores.

You can then use available core-pack sizes to fulfill that calculated quantity.

The wrong sequence is:

“A 16-core product looks convenient, so I’ll buy that and design the server around it.”

The correct sequence is:

“This architecture requires a validated amount of core licensing, so which available product quantities fulfill that requirement?”

That subtle distinction prevents both under-licensing and unnecessary purchasing.

Does Every Physical CPU Core Have to Be Licensed?

The answer depends on how the SQL Server environment is being licensed.

If the strategy is physical-server Per Core licensing, physical processor/core rules become central.

If the strategy is licensing an individual VM, the calculation follows the applicable virtualized deployment rules instead.

This is why hardware specifications alone cannot answer a SQL Server licensing question.

Two organizations can own identical servers but require different licensing analyses because one runs SQL Server directly on the physical operating system while the other runs a small SQL VM on a large virtualization host.

Does Every User Need a CAL?

Only when the chosen licensing model requires CALs.

Under Per Core licensing, individual SQL Server CALs are not required for every accessing user or device.

Under Standard Server + CAL licensing, the user/device access population becomes part of the licensing calculation.

If your organization is trying to decide between these models, count actual access patterns before comparing costs.

Do not base the calculation only on employee headcount.

SQL Server Licensing for External Users

External access is one reason Per Core licensing often deserves attention.

Imagine an SQL-backed application used by:

  • employees
  • customers
  • suppliers
  • contractors
  • website visitors

The number of users and devices may be difficult to predict and maintain accurately.

Per Core licensing avoids making every individual user/device the center of the licensing model.

That does not mean Per Core is automatically cheaper.

It means the licensing structure may better match the architecture.

SQL Server Licensing for Multiple Servers

Another common mistake is to calculate licensing for one SQL Server and assume the result applies to the whole environment.

Consider an architecture with:

Production SQL Server + reporting SQL Server + disaster-recovery server + test server

Those systems may not all have identical licensing treatment.

Edition, production use, passive/active behavior, development/test rights and Software Assurance or subscription entitlements can affect the analysis.

Do not assume the secondary server is “free” simply because it exists for recovery purposes.

Similarly, do not assume every server necessarily requires identical licensing without first checking its role and the applicable rights.

Development and Test Environments Need Their Own Review

Production licensing and non-production SQL Server usage should not be casually mixed.

SQL Server provides development-focused edition options intended for development and testing scenarios, while production workloads require appropriately licensed production editions.

A database containing test data does not automatically make an environment non-production.

Ask what the environment actually does.

If business users depend on it operationally, treat that distinction carefully.

SQL Server 2025 Licensing Decision Flow

Use this sequence before buying:

Question 1 - Which edition does the workload require?

If Standard satisfies the technical requirement, continue to Question 2.

If Enterprise functionality or scale is necessary, the licensing analysis moves to Per Core.

Question 2 - If Standard, is access realistically countable?

If the environment has a controlled number of known users or devices, evaluate Server + CAL alongside Per Core.

If access is broad or unpredictable, Per Core may be easier to manage.

Question 3 - Is SQL Server physical or virtual?

Document exactly where SQL Server executes.

Do not calculate core licensing until this is clear.

Question 4 - Are you licensing VMs or physical infrastructure?

This becomes particularly important in consolidated and Enterprise environments.

Question 5 - Are you relying on special virtualization or mobility rights?

If yes, verify whether those rights require Software Assurance, subscription licensing or another qualifying condition.

Question 6 - What quantity is actually required?

Only now should you convert the calculation into 2-core, 16-core or other appropriate product quantities.

Common SQL Server 2025 Licensing Mistakes

Mistake 1 - Choosing the product pack before the architecture

A 2-core or 16-core product is a purchasing unit.

It is not the licensing calculation itself.

Mistake 2 - Assuming Enterprise includes every virtualization benefit

Enterprise Edition and qualifying virtualization rights are related but separate questions.

Check the actual licensing conditions.

Mistake 3 - Assuming indirect application access eliminates CAL requirements

Middleware does not automatically turn many underlying users into a single licensed user.

Review indirect access carefully.

Mistake 4 - Counting employees instead of access

Not every licensing environment maps neatly to payroll headcount.

Understand who and what actually accesses SQL Server.

Mistake 5 - Assuming every Standard deployment should use Server + CAL

Standard gives you a choice.

Per Core can make more sense when access is difficult to count.

Mistake 6 - Assuming Per Core is always better for a large company

Company size alone does not determine the model.

Architecture and access patterns do.

Mistake 7 - Treating a VM CPU change as purely technical

Increasing virtual compute can have licensing consequences.

Include licensing review in infrastructure change management.

Mistake 8 - Assuming the store SKU includes Software Assurance

Never infer Software Assurance, subscription benefits, mobility rights, hybrid benefits or special failover rights unless the exact product includes them.

SQL Server 2025 Licensing Checklist Before You Buy

Before selecting a Wholsalekeys product, document:

  • SQL Server edition required
  • Standard or Enterprise
  • Per Core or Server + CAL where applicable
  • Physical or virtual deployment
  • Number of relevant cores
  • Applicable minimum-core rules
  • Number of SQL Server VMs
  • Number of physical hosts involved
  • User count if considering User CALs
  • Device count if considering Device CALs
  • Shared-device scenarios
  • External-user access
  • Indirect/multiplexed access
  • Failover architecture
  • VM mobility requirements
  • Software Assurance/subscription status where relevant
  • Exact SKU rights
  • Final required core-pack quantity

If several of those fields are still marked “unknown,” you are not yet at the product-selection stage.

FAQ

How is SQL Server 2025 licensed?

SQL Server 2025 Standard can be licensed using Per Core or Server + CAL models. SQL Server 2025 Enterprise uses Per Core licensing for current new licensing scenarios.

A 2-core product represents two cores of licensing quantity. It contributes toward the total licensing requirement calculated for the environment. It should not be treated as sufficient for every SQL Server installation simply because it is sold as one product.

Only when Standard is licensed under the Server + CAL model. Standard can also be licensed Per Core, in which case individual CALs are not required for each accessing user or device under that model.

Enterprise is licensed Per Core for current new licensing scenarios, so it is not purchased using the current Standard-style Server + CAL model.

Choose based on access patterns. A user-oriented model may suit employees using multiple devices, while a device-oriented model may deserve consideration when many people share a smaller number of devices.

Neither is universally better. Per Core can be practical for broad or unpredictable access, while Server + CAL can make sense for some Standard environments with controlled and countable users or devices.

Yes, but virtualized environments have specific licensing considerations. Confirm virtual core requirements, applicable minimums and any rights tied to Software Assurance or subscription licensing before calculating quantity.

Do not assume that simply from the Enterprise edition name. Virtualization rights can depend on how the physical server is licensed and on additional licensing conditions such as Software Assurance or qualifying subscriptions.

There is no single answer without knowing the edition, licensing model and deployment architecture. For Per Core licensing, determine the relevant core requirement. For Standard Server + CAL, determine the server licensing and applicable user/device access requirement.

Which SQL Server 2025 License Should You Buy?

The safest way to purchase SQL Server 2025 is to make three decisions in order:

1. Choose the edition.

Determine whether the workload belongs on Standard or Enterprise.

2. Choose the licensing model.

For Standard, compare Per Core with Server + CAL where appropriate.

For Enterprise, plan around Per Core licensing.

3. Calculate the quantity.

Determine physical or virtual licensing requirements, minimum core rules and any other conditions that affect your architecture.

Only then should you select the corresponding Wholsalekeys product.

For a Standard Per Core deployment, you can compare the SQL Server 2025 Standard 2-Core License and SQL Server 2025 Standard 16-Core License after calculating the required quantity.

If your workload needs Enterprise, calculate the architecture first and then compare the SQL Server 2025 Enterprise 2-Core License and SQL Server 2025 Enterprise 16-Core License.

For buyers still evaluating Standard more broadly, the SQL Server 2025 Standard product provides another relevant starting point.

The key rule is simple:

Do not buy a SQL Server license quantity and then try to make the infrastructure fit it. Design the environment, establish the licensing requirement, and then buy the quantity that matches.

Stay tuned to our blog for more insights and tips.

Recent posts

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *