Enterprise data platform · Perpetual licence
Microsoft SQL Server 2017 Enterprise
Mission-critical performance, advanced security and enterprise business intelligence—with expert licensing guidance and free remote support included.
- SSL-secured checkout
- Digital fulfilment
- Established Microsoft partner channel
- Global customer service
Perpetual licensing
Use the purchased release without recurring subscription renewal, subject to the supplied licence terms.
Secured transaction
SSL-protected checkout with payment and order verification before fulfilment.
Expert remote support
Free guidance for download, installation and initial activation.
Lifecycle transparency
Plan production use with the support timeline in view
SQL Server 2017 left mainstream support on 11 October 2022 and remains in Microsoft extended support until 12 October 2027. Extended support focuses on security updates. Organisations should evaluate their long-term upgrade path before deployment.
Expert overview
Enterprise capability for established SQL Server estates
SQL Server 2017 Enterprise is Microsoft’s premium 14.x database edition. It introduced production support across Windows, Linux and containers while adding adaptive query processing, graph data, Python integration, resumable online index rebuilds and advanced availability options.
Adaptive query performance
Adaptive joins, memory-grant feedback and interleaved execution help the engine respond to changing runtime conditions.
Enterprise unlocks the full 2017 adaptive-query set.Advanced availability
Full Always On Availability Groups support up to eight secondary replicas, including two synchronous secondaries.
Beyond Standard edition’s Basic Availability Groups.Enterprise protection
Combine TDE, Always Encrypted, row-level security, masking, auditing and encrypted backups.
TDE and EKM are Enterprise differentiators in 2017.Machine learning
Run Python and R analytics close to governed data for advanced scoring and statistical workloads.
Advanced integration can use Enterprise-scale resources.Graph and modern data
Use node and edge tables, JSON, temporal tables and modern T-SQL functions.
Useful for connected data without leaving T-SQL.Cross-platform
Deploy the engine on supported Windows Server or Linux distributions and use containers.
The first production SQL Server release for Linux.
Performance and availability
Keep critical workloads responsive while the estate changes
Enterprise edition is valuable where maintenance, unpredictable query behaviour and recovery time have direct business impact.
- Adaptive joins and memory feedback
- Resource Governor workload controls
- Online and resumable index maintenance
- Full Always On Availability Groups
Layered data protection
Security controls at storage, column and row level
Build defence in depth with encryption, least-privilege access, selective exposure and audit evidence.
- Transparent Data Encryption for files and backups
- Always Encrypted for selected sensitive values
- Row-level security and dynamic data masking
- Server and database audit capabilities
In-depth expert opinion
Where SQL Server 2017 Enterprise still makes strategic sense
Application certification first
A version-bound application, regulated validation package or vendor contract can justify matching the certified 2017 platform. Document the dependency and the exit plan.
Enterprise value is operational
Full availability groups, online operations, governance, TDE and unrestricted engine scale are the strongest reasons to choose Enterprise.
Lifecycle risk must be costed
Extended support ends in October 2027. Include discovery, testing, migration, rollback and staff capacity in the purchase decision.
Licensing explained
Buy the right core quantity before installation
Licence requirements depend on physical and virtual cores, cluster design, mobility and Software Assurance.
Edition comparison
SQL Server 2017 Enterprise vs Standard
| Capability | Enterprise | Standard |
|---|---|---|
| Maximum engine compute | Operating-system maximum | Lesser of 4 sockets or 24 cores |
| Maximum buffer-pool memory | Operating-system maximum | 128 GB |
| Maximum database size | 524 PB | 524 PB |
| Columnstore segment cache | Operating-system maximum | 32 GB |
| Always On Availability Groups | Full; up to 8 secondary replicas | No |
| Basic Availability Groups | Not applicable | 2 replicas; 1 database |
| Online index create and rebuild | Yes | No |
| Resource Governor | Yes | No |
| Automatic tuning | Yes | No |
| Transparent Data Encryption | Yes | No |
| Advanced R and Python integration | Yes | No |
| Compression and partitioning | Yes | Yes |
Feature limits are for SQL Server 2017. Verify platform, patch and agreement-specific conditions.
Previous and latest releases
SQL Server version comparison
SQL Server 2016
Query Store, Always Encrypted, row-level security and mature in-memory processing.
Extended support ended 14 Jul 2026SQL Server 2017
Linux, containers, adaptive queries, graph data and Python integration.
Extended support ends 12 Oct 2027SQL Server 2019
Intelligent Query Processing, UTF-8, ADR and expanded PolyBase.
Extended support ends 8 Jan 2030SQL Server 2022
Azure SQL MI link, ledger, contained AGs and Query Store enhancements.
Extended support ends 11 Jan 2033SQL Server 2025
Vector functions, AI integration, enhanced availability and Fabric connectivity.
Extended support ends 6 Jan 2036System requirements
Installation minimums and production planning
x64 at 1.4 GHz minimum
2.0 GHz or faster recommended; size cores and NUMA for actual workload demand.
1 GB setup minimum
At least 4 GB recommended; enterprise production commonly requires substantially more.
6 GB available minimum
Data, logs, tempdb, backups, patching and growth need separate capacity.
Supported Windows Server
Enterprise is not supported on Windows 10 or Windows 11 client editions.
Supported x64 distribution
Use a supported RHEL, SUSE or Ubuntu release and verify feature parity.
.NET Framework 4.6 dependency
Use a supported 4.x release such as .NET Framework 4.8 on Windows.
Frequently asked questions
Answers for technical and commercial buyers
Is SQL Server 2017 Enterprise a perpetual licence?
The purchased release can be licensed with perpetual use rights. Edition, core quantity, transfer rights and Software Assurance must match the written quotation and Product Terms.
Does the licence expire?
Perpetual use rights do not expire for the licensed release. Microsoft extended support ends on 12 October 2027.
How is a new Enterprise deployment licensed?
Enterprise is normally licensed per core. Count physical cores for a physical server or virtual cores for each VM. Minimum core rules apply.
Can I buy Enterprise under Server + CAL?
Enterprise Server + CAL is not available for new agreements. Some organisations may hold historical entitlements; documentary proof is required.
Does Enterprise include unlimited virtual machines?
Not automatically. Unlimited virtualisation generally requires all physical cores to be licensed for Enterprise plus active Software Assurance or qualifying subscription rights.
Can SQL Server 2017 Enterprise run on Linux?
Yes, on supported Linux distributions. Review feature parity because some services and management components differ from Windows.
Can Enterprise be installed on Windows 11?
Microsoft’s operating-system matrix does not support Enterprise edition on Windows client editions. Use supported Windows Server or Linux.
Are SQL Server CALs required?
CALs are not required for a correctly licensed per-core Enterprise workload.
Is free remote support included?
Yes, for download, installation and initial activation. Architecture, migration and performance engineering may need a separate service scope.
Should I buy SQL Server 2017 or a newer version?
Choose 2017 for application certification or estate consistency. For a new system, SQL Server 2022 or 2025 normally offers a longer support runway.
How is the product delivered?
Electronic fulfilment follows payment and order verification. Order communication identifies the supplied download and licence information.
How do I confirm the correct licence quantity?
Provide physical processor/core counts, VM and vCPU counts, cluster design, mobility needs and Software Assurance requirements for review.
Purchase with clarity
Get SQL Server 2017 Enterprise with expert support included
Confirm the licensing model, complete SSL-secured checkout and receive digital fulfilment after order verification.
View purchase options →- Genuine supply assurance
- Encrypted checkout
- Digital fulfilment
- Free remote support
