SQL Server licensing has a reputation for being confusing, and it’s earned. There are several editions, two licensing models, minimums per processor and per virtual machine, and price differences that run into tens of thousands of dollars. The good news is that for most small and mid-sized businesses the decision comes down to two or three questions.
The short version: at Microsoft’s list prices, a SQL Server 2022 Standard license costs $3,945 per two-core pack, or $989 per server plus $230 for each user or device. Enterprise costs $15,123 per two-core pack. Developer and Express are free. The rest of this guide explains which of those numbers applies to you and how to add them up, using Microsoft’s own pricing and edition documentation.
The SQL Server 2022 editions and prices
| Edition | Microsoft price (open, no level) | Licensing | Who it’s for |
|---|---|---|---|
| Enterprise | $15,123 per 2-core pack | Per core | Large, mission-critical databases |
| Standard (per core) | $3,945 per 2-core pack | Per core | Business apps with many or unknown users |
| Standard (server) | $989 per server | Server + CAL | Small teams with a known number of users |
| Standard CAL | $230 per user or device | Used with the server license | |
| Developer | Free | Per user | Development and testing only |
| Express | Free | None | Small apps and databases up to 10 GB |
| Web | Through hosting partners | Hosting only | Public websites run by hosting providers |
Prices are Microsoft’s published estimated retail prices for SQL Server 2022 in US dollars. Your actual price depends on the channel and agreement.
How much does a SQL Server license cost? Worked examples
The list price only becomes a budget once you multiply it by your cores or users. These examples use the prices above.
| Scenario | Best-fit model | Calculation | List cost |
|---|---|---|---|
| 4-core virtual machine, 10 users | Standard, Server + CAL | $989 + 10 × $230 | $3,289 |
| 4-core virtual machine, 40 users | Standard, per core | 2 packs × $3,945 | $7,890 |
| 8-core server, 25 users | Standard, Server + CAL | $989 + 25 × $230 | $6,739 |
| 8-core server behind a public website | Standard, per core | 4 packs × $3,945 | $15,780 |
| 16-core server, Standard | Standard, per core | 8 packs × $3,945 | $31,560 |
| 16-core server, Enterprise | Enterprise, per core | 8 packs × $15,123 | $120,984 |
Two break-even points are worth remembering. On a four-core server or VM, Server + CAL is cheaper than per core up to 30 users. On eight cores, it stays cheaper up to 64 users. Past those numbers, or whenever you can’t count the users, license by core.
Per core vs Server + CAL
SQL Server Standard can be licensed in two ways, and choosing the right one can save a lot.
Per core
You license every core the SQL Server instance can use, and you don’t count users at all. Microsoft sells core licenses in 2-core packs, with a minimum of four core licenses per physical processor, or per virtual machine if you license VMs individually. A small server with one 8-core processor needs 8 core licenses, which is four 2-core packs.
Per core is the only option for Enterprise edition, and it’s the right choice for Standard when users are hard to count: public-facing websites, customer portals, or hundreds of internal users.
Server + CAL
You buy one server license per SQL Server, then a Client Access License for every user or device that uses it, directly or through an application. It’s only available for Standard edition.
For a small office with 10 to 20 known users, Server + CAL is often far cheaper than per core. Run the numbers at Microsoft’s prices: one server ($989) plus 15 CALs ($230 each) comes to about $4,439, while a 4-core minimum on per-core licensing is two packs, or $7,890.
The common mistake is undercounting. Users who reach SQL Server through a web app, a reporting tool or another server still need CALs. That rule is called multiplexing, and it doesn’t let you off the hook.
What you have to count before you buy
- Cores. Physical cores in the server, or virtual cores assigned to the VM. The minimum is four per processor or per VM, even if the machine has fewer.
- Users and devices. Everyone and everything that touches the data, including people who only use an application that sits in front of the database.
- Servers. In the Server + CAL model, each operating system environment running SQL Server needs its own server license. One set of CALs covers access to all of your licensed SQL Servers of that version or earlier.
- Standby servers. A passive failover replica is free only if the primary is covered by Software Assurance or a subscription. Without that, the standby needs its own license.
- Test and development machines. These can run Developer edition at no cost, as long as no production data is served from them.
- The operating system. SQL Server licenses do not include Windows Server. That is a separate license with its own CALs.
Standard vs Enterprise: what the extra money buys
Microsoft’s edition documentation sets these limits for SQL Server 2022:
| Standard | Enterprise | |
|---|---|---|
| Compute per instance | Lesser of 4 sockets or 24 cores | Operating system maximum |
| Buffer pool memory per instance | 128 GB | Operating system maximum |
| Columnstore segment cache | 32 GB | Unlimited |
| Licensing | Per core or Server + CAL | Per core only |
Beyond scale, Enterprise unlocks the high-end features: full Always On availability groups with multiple readable secondaries (Standard only has basic two-replica groups for one database each), online index rebuilds, advanced partitioning and performance features, and unlimited virtualization when you license every core on the host with Software Assurance.
For a typical line-of-business application, such as accounting, ERP, CRM or an internal web app with a database under a few hundred gigabytes, Standard is plenty. Enterprise earns its price on large data warehouses, high-transaction systems and setups that can’t tolerate downtime.
The free editions
- Developer has every Enterprise feature, free, but only for development and testing. It can’t run production workloads.
- Express is free for production but limited to 10 GB per database, 1,410 MB of buffer pool memory and the lesser of one socket or four cores. It’s fine for small apps, point-of-sale systems and prototypes.
A common path is Express for a new app, then Standard once the database passes 10 GB or performance starts to matter.
Virtual machines and containers
When SQL Server runs in a VM, you can license the VM’s virtual cores (minimum four per VM) instead of the whole host. That’s usually the cheapest route for one or two SQL VMs on a larger host. To run many SQL VMs on one host, licensing every physical core with Enterprise plus Software Assurance gives you unlimited virtualization. Remember that the Windows Server underneath needs its own license too. See our Windows Server 2025 licensing guide.
One-time license, subscription or pay-as-you-go
SQL Server can be bought three ways, and the edition rules above are the same for all of them.
- A perpetual license is a one-time purchase. You own the right to run that version indefinitely. Software Assurance is an optional yearly add-on that brings new-version rights, free passive failover servers and license mobility.
- A subscription through a Microsoft partner runs for one or three years and includes the Software Assurance benefits while it is active.
- Pay-as-you-go arrived with SQL Server 2022: connect your on-premises server to Azure Arc and pay monthly for the cores you use. It suits seasonal or temporary workloads.
For a database that runs year after year on the same hardware, the one-time license is usually the cheapest over time.
Support dates, and where SQL Server 2025 fits
| Version | Mainstream support ends | Extended support ends |
|---|---|---|
| SQL Server 2016 | Ended | Ended July 14, 2026 |
| SQL Server 2017 | Ended | October 12, 2027 |
| SQL Server 2019 | Ended | January 8, 2030 |
| SQL Server 2022 | January 11, 2028 | January 11, 2033 |
SQL Server 2022 has more than six years of security updates left, which is why it remains the safe default for a new installation. If you are still on SQL Server 2016, it is now out of support.
SQL Server 2025 is the newer release. Microsoft’s documentation for it raises the Standard edition limits to the lesser of 4 sockets or 32 cores and a 256 GB buffer pool, lifts the Express database limit to 50 GB, and no longer lists a Web edition. The licensing models are the same. Check Microsoft’s current pricing page before budgeting for 2025, because list prices differ by version.
Buying SQL Server 2022
We carry SQL Server 2022 Standard and SQL Server 2022 Enterprise keys, delivered by email with the official download link. Kymakers is operated by Makers Unity LLC. If you’re not sure which edition or licensing model fits your server, ask us before you buy and tell us your core count and number of users. We’d rather you buy the right license once. After purchase, our SQL Server 2022 Standard installation guide covers download, setup and entering the key.
Related guides
Building or upgrading the server underneath? Start with Windows Server 2019 vs 2022 vs 2025 and Windows Server CALs explained. Developers working against SQL Server will also want the right IDE, so see Visual Studio 2026 editions compared. All our database and server licenses are on the SQL Server page.
SQL Server licensing: FAQ
How is SQL Server 2022 licensed?
Per core (Enterprise and Standard) or Server + CAL (Standard only). Developer and Express are free.
How much does a SQL Server 2022 Standard license cost?
At Microsoft’s list prices, $3,945 per two-core pack, or $989 per server plus $230 per user or device CAL. A four-core server therefore costs $7,890 under per-core licensing, or $989 plus CALs under Server + CAL.
What’s the minimum number of core licenses?
Four per physical processor, or four per virtual machine when licensing VMs individually. Core licenses are sold in 2-core packs.
Do I need CALs with per-core licensing?
No. Per-core licensing covers unlimited users. CALs only apply to the Server + CAL model.
Is SQL Server a one-time purchase?
It can be. A perpetual license is paid once and does not expire. Subscriptions and pay-as-you-go billing through Azure Arc are alternatives.
Do I need Software Assurance?
No. It is optional. It is worth considering if you want rights to new versions, a free passive failover server or unlimited virtualization with Enterprise.
Does SQL Server include a Windows Server license?
No. Windows Server and its CALs are licensed separately.
What’s the database size limit in SQL Server Express?
10 GB per database in SQL Server 2022.
Can I use SQL Server Developer edition in production?
No. Developer is licensed for development and testing only.
Is Standard edition enough for my business?
For most small and mid-sized workloads, yes. Standard handles up to 24 cores and 128 GB of buffer pool memory per instance.




