SQL Server 2017 · licensing decision diagram, not a product screenshot
For SQL Server per-core licensing, check the four-core minimum per physical processor or individually licensed VM. Standard may use Server + CAL; multiplexing does not remove CAL requirements. Validate passive-replica and mobility rights separately.
Record the exact edition, version, quantity, agreement and support date. Obtain written confirmation of delivery, refund and support terms; a perpetual licence is not a lifetime support guarantee.
On this page
Editions covered
—
Edition matrix with feature differences and the right audience.
In-depth sections
3
Channels, activation, audit, modern management & more.
FAQs answered
4
Common questions buyers and IT admins ask before purchase.
Words of reference
0.3k
Edition and deployment guidance; verify current rights against official sources.
Deep dive
SQL Server 2017 — what to actually know
SQL Server 2017 shipped in October 2017 and was a landmark release: the first SQL Server engine to run on Linux (Red Hat, SUSE, Ubuntu) and inside Docker containers, with effectively identical T-SQL surface area as the Windows build. It introduced adaptive query processing, graph data support (nodes and edges as first-class table types), Python integration in Machine Learning Services (R was already in 2016), resumable online index rebuilds and automatic database tuning. Mainstream support ended 11 October 2022; extended support runs to 12 October 2027.
01
Editions and Linux specifics
Same edition stack as 2019: Enterprise, Standard, Web, Developer, Express. On Linux, the installer is a package (rpm / deb) and the service runs under systemd. Feature parity with the Windows build is high but not total — Filestream, distributed transactions across instances, and System Center management agents are Windows-only. The Docker image is officially supported for production on Linux hosts; for Windows hosts Microsoft recommends the native Windows installer.
02
Licensing
Per-core (Enterprise; Standard) or Server+CAL (Standard). Linux deployments are licensed the same way as Windows deployments — the operating system underneath does not change the SQL Server licence. Containers are licensed per physical core of the host when running on a host with unlimited virtualisation rights, otherwise per allocated vCore.
03
Support and upgrade path
Mainstream support ended October 2022. Extended support continues through 12 October 2027, with security patches but no new features. Direct in-place upgrade is supported to SQL Server 2019, 2022 and 2025. Customers running on Linux should plan a parallel upgrade of the underlying distribution at the same time, since RHEL/SUSE versions supported by 2017 are themselves moving out of support.
By channel
Where to buy this product
Confirm that the exact SKU is available in the proposed channel and region. A channel name does not establish entitlement or guarantee a lower price.
Evidence to request
Exact product, edition, version and licence quantity.
Order, invoice and applicable agreement or subscription record.
Ownership in your organisation's account, where applicable.
Written reassignment, renewal and support conditions.
OEM is supplied only pre-installed by hardware manufacturers, never sold as a standalone licence.
Retail / FPPIndividuals & small teams
Boxed or ESD keys, transferable, registered to a Microsoft account.
Monthly / annual seats, managed through partner or admin center.
OEM is not a buying channel for end users. OEM keys are supplied pre-installed by hardware manufacturers and are not sold standalone — choose Retail, Volume or CSP instead.
Support timeline
Lifecycle phases to plan against
SQL Server is the most expensive product Microsoft sells per core. Edition, core count and licensing model (per-core vs Server+CAL) have life-changing cost implications — model them before you buy.
Phase 1
Exact product
Identify
Record the release, edition and servicing channel of SQL Server 2017; family names alone do not establish support dates.
Phase 2
Official lifecycle
Verify
Look up the exact product in Microsoft's lifecycle directory. Fixed and Modern Lifecycle policies differ; not every release has extended support.
Phase 3
Deployment
Plan
Confirm supported operating systems, application dependencies and upgrade rights before deployment.
Phase 4
End of support
Migrate
A perpetual licence can remain valid after support ends, but it does not guarantee security updates. Check any ESU programme separately.
Purchase preparation
What to include in a SQL Server 2017 quote request
Edition and model
Exact version and edition; Per Core or eligible Server + CAL model.
Deployment
Physical processors and cores, or vCPUs per individually licensed VM.
Access
Users and devices, including indirect access when CALs apply.
Resilience
Active and passive replicas, HA/DR use and existing coverage.
These are planning inputs, not a licence calculation. Confirm the final quantity and use rights against the exact version and agreement.
Compare like-for-like quotations
Match product, edition, version, quantity and perpetual or subscription terms.
Confirm total cost, renewal conditions and the evidence of ownership supplied.
Obtain written delivery, refund and support conditions before payment.
The small set of decisions that determine whether you overpay, fail an audit, or land in the right place.
DO
License every physical core on every server that runs SQL, with the 4-core-per-physical-processor or individually licensed VM minimum and 2-pack increments.
DON'T
License only one VM's worth of cores when the underlying host can re-schedule the VM to any other host — that is unlicensed mobility.
DO
Use Developer Edition for every non-production environment — it is feature-equivalent to Enterprise and free.
DON'T
Carry SQL Server 2022 Express limits into SQL Server 2025: verify the exact release matrix before sizing production workloads.
DO
Document qualifying HA and disaster-recovery rights, locations and permitted passive maintenance activities under the applicable subscription or Software Assurance terms.
DON'T
Assume every replica is covered: application queries and active reporting can require separate licensing; validate each failover scenario.
DO
Consider Azure SQL Managed Instance or Azure SQL Database for new workloads — licensing collapses into the service cost.
DON'T
Buy Enterprise cores for a workload that fits comfortably in Standard — the price gap is large and Standard now covers most mid-market needs.
Typical deployments
How buyers actually use SQL Server 2017
Illustrative planning scenarios, not customer case studies. Check the exact product rights and deployment requirements.
Scenario 1
Line-of-business ERP
Standard per-core on the active node, passive HA secondary covered by SA, regular backups to Azure Blob. Choose the edition against the exact ERP requirements and release-specific feature limits.
Scenario 2
Data warehouse / BI
Enterprise per-core for columnstore at scale and advanced security. Consider Microsoft Fabric or Azure Synapse for greenfield analytics rather than scaling SQL Server vertically.
Scenario 3
ISV embedding SQL
Either bundle Express (with its caps) for free distribution, or buy SQL through the ISV royalty programme; never silently ship Developer Edition in a commercial product.
Cost optimisation
Where the savings actually live
Compare entitlement, deployment and renewal costs; savings depend on your workload and written quotation.
💰
Standard wins for most mid-market apps
Verify the edition limits for the exact SQL Server release. Features such as TDE, partitioning and in-memory OLTP are not universally Enterprise-only; compare official edition matrices before paying for Enterprise.
📊
Free passive secondary
Qualifying subscription or Software Assurance rights can cover passive HA and disaster-recovery deployments. Validate the allowed topology and activities before counting a replica as covered.
🎯
Azure SQL for elastic workloads
Variable workloads (dev/test, reporting bursts, multi-tenant SaaS) collapse total cost in Azure SQL serverless or elastic pools versus statically licensed cores.
Counterfeit & risk
Red flags when buying second-hand
These warning signs require further verification; activation alone cannot establish licence ownership.
⚠ 01
Standalone OEM key sold below market
OEM keys are distributed only pre-installed on hardware and stay bound to that device for life. A separately sold OEM key is not an eligible standalone purchase; request documented rights through an appropriate channel.
⚠ 02
Lifetime key with no invoice or Microsoft 365 admin center volume licensing record
Request applicable order and agreement records, such as Microsoft Store purchases, CSP subscription records or volume licensing details in the Microsoft 365 admin center. Activation alone is not proof of entitlement.
⚠ 03
Key works once, then 'not genuine' after the next cumulative update
Activation failures can have several causes, including key eligibility, activation counts, connectivity and hardware changes. Check the error through official Microsoft guidance; it does not by itself prove counterfeiting.
⚠ 04
Seller refuses to put the entitlement in your tenant
For tenant-based subscriptions, confirm your organisation controls the tenant and can read its subscription records. Retail and on-premises entitlements use different records; not every licence is assigned through a tenant.
Acronyms
Licensing terms used on this page
Quick definitions — the full glossary lives at /en/glossary if you need to dig deeper.
CSP
Cloud Solution Provider — Microsoft's primary indirect channel for subscriptions and cloud services.
Microsoft 365 admin center volume licensing
Volume licensing administration — agreements, keys and downloads are now managed in the Microsoft 365 admin center.
MAK
Multiple Activation Key — a Volume Licensing key with a finite activation count, used for isolated machines.
KMS
Key Management Service — an on-premises activation host that activates clients on a 180-day re-check cycle.
EA
Enterprise Agreement — Microsoft's largest commitment-based volume contract, typically a 3-year term with annual true-ups.
SA
Software Assurance — the upgrade-and-benefits add-on to Volume Licensing; required for new version rights and several mobility scenarios.
Only with security updates. Mainstream support ended 11 October 2022; extended support (security updates only) continues until 12 October 2027. Plan the upgrade before that date — after it, the only path to patches is a paid Extended Security Updates (ESU) programme where Microsoft offers one.
Is SQL Server 2017 on Linux still supported?+
Yes — until 12 October 2027 under extended support. New Linux distributions added after 2017 may not be officially supported even if the engine runs; check the Microsoft compatibility matrix.
Where can I legitimately buy a license?+
Through Microsoft's Retail channel (where the SKU is still sold), an authorised Cloud Solution Provider (CSP), or a Volume Licensing partner (MPSA, Enterprise Agreement, Open Value, Server & Cloud Enrollment). OEM keys are distributed only pre-installed by hardware manufacturers and stay bound to that device for life — they are not sold to end users as standalone products. For end-of-sale products, second-user (transferred) Volume Licensing through a documented chain of custody is the only legitimate secondary market.
What gets checked in a Microsoft licensing audit?+
Auditors map every installed copy to a proof of purchase (VLSC record, CSP invoice, sealed Retail packaging), verify edition alignment, and confirm CAL counts cover the maximum number of authenticated users or devices during the audit window. Older products are audited the same way as current ones — being out of mainstream support does not waive the licensing obligation.