Need More CAL's?
Microsoft SQL Server 2019 | 1 Device Client Access License (CAL) | PN: 359-06865
$198.88
Microsoft SQL Server Standard 1 User CAL PN: 359-06866
$198.88
Microsoft SQL Server 2022 1 Device Client Access License (CAL) Retail CSP
$198.99
Microsoft SQL Server 2022 1 User Client Access License (CAL) Retail
$198.99
Microsoft SQL Server 2017 Standard | Retail License
FEATURES:
SQL Server 2017 Edition Comparison
Feature | SQL Server 2017 Express | SQL Server 2017 Standard - This Edition | SQL Server 2017 Enterprise |
---|---|---|---|
Maximum Compute Capacity (per instance) | Limited to lesser of 1 Socket or 4 Cores | Lesser of 4 Sockets or 24 Cores | OS Maximum |
Maximum Memory Utilization (per instance) | 1 GB for Database Engine, 352 MB for SQL Server Express with Advanced Services | 128 GB | OS Maximum |
High Availability | Not supported | Basic Availability Groups | AlwaysOn Availability Groups, multi-database failover, multiple synchronous replicas |
Online Operations | Not supported | Basic online operations | Advanced online operations including online index rebuilds |
Performance | Basic performance features | Standard performance features | Advanced performance features (In-Memory OLTP, Adaptive Query Processing, Advanced analytics) |
Security | Basic security features | Basic security features | Advanced security features (Always Encrypted, Row-level security, Dynamic data masking) |
Data Warehousing | Not supported | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning) |
Business Intelligence | Not supported | Basic BI capabilities | Advanced BI capabilities (Power BI Report Server, Advanced analytics) |
Data Mining | Not supported | Basic data mining | Advanced data mining |
Database Snapshot | Not supported | Not supported | Supported |
Enterprise Manageability | Basic management tools | Standard management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
Partitioning | Not supported | Not supported | Supported |
Data Compression | Not supported | Not supported | Supported |
Table and Index Partitioning | Not supported | Not supported | Supported |
Backup Compression | Not supported | Supported | Supported |
Audit | Not supported | Basic auditing | Advanced auditing (Server Audit Specification) |
Resource Governor | Not supported | Not supported | Supported |
Replication | Not supported | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
SQL Server Integration Services (SSIS) | Basic SSIS features | Standard SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
Master Data Services | Not supported | Not supported | Supported |
Data Quality Services | Not supported | Not supported | Supported |
Power BI Report Server | Not supported | Not supported | Supported |
PowerPivot for SharePoint | Not supported | Not supported | Supported |
Power View | Not supported | Not supported | Supported |
How to license SQL Server?
Licensing Models
- Core-based Licensing: Applies to the Enterprise Edition and offers unlimited Virtualization Rights when all physical cores are licensed.
- Server + CAL (Client Access License): Applies to the Standard Edition and requires a license for each server and a CAL for each user or device accessing the server.
Core-Based Licensing (Standard and Enterprise Editions)
+--------------------+ | SERVER | |--------------------| | Core 1 | Core 2 | | Core 3 | Core 4 | +--------------------+ | Minimum 4 Core Licenses per Processor |
- Core Licenses: Sold in packs of two. Each physical core must have a license.
- Minimum Requirement: A minimum of four core licenses per physical processor.
- Virtualization: With Software Assurance, allows for unlimited virtualization. This license is a retail pack with 2 cores without SA, so the virtualization will depend upon the number of vCPU's licensed.
- Looking for the SKU with Software Assurance? It can be purchased here
Server + CAL Licensing (Standard Edition)
- Server License: One license per server. - This edition
- CALs: One CAL per user or device accessing the server.
Virtualization and Containers
+----------------------------+ | HOST | +----------------------------+ | VM 1 | VM 2 | VM 3 | VM 4 | +----------------------------+ | Each VM must be licensed | +----------------------------+
- Enterprise Edition: Offers flexibility with virtualization, allowing for multiple VMs and containers.
- Standard Edition: Limited to a lower number of VMs and containers unless each VM is licensed individually.
Licensing for Specific Environments
- Non-production (Dev/Test): Developer Edition is free and provides the full feature set for development and testing purposes.
- High Availability: Passive secondary servers for failover are included in the licensing of the primary server.
Delivery, Returns & Tech Support:
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 7-day return policy on most licenses if unused/non-activated.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
Thank you for choosing ESS - Your #1 Software Dudes!!
What do I get with my purchase?
You receive a product key, download link and install instructions.
How do I get the download?
Most products are delivered digitally via email within 30 minutes of purchase.
What if I need help?
We provide installation support free with all purchases. Just reach out if you need help, we're here!
Other questions?
Give us a call or chat instantly.
Read over 1,000+ reviews that rated ESS 4.9/5 stars
Our customer feedback reflects unparalleled customer satisfaction. With a focus on delivering tailored IT and software solutions, ESS stands as a beacon of reliability and excellence in the industry. Experience their commitment to quality and efficiency firsthand for your business needs.
Our productsRetail (Full Package Product) vs. Open Value with Software Assurance (SA)
Criteria |
Retail (FPP) |
Open Value with Software Assurance (SA) |
---|---|---|
Pricing |
One-time purchase, typically higher cost upfront.
|
Spread out payments over a 2-3 year period. Discounts available for volume purchases.
|
License Type |
Perpetual license.
|
Non-perpetual if on subscription, or perpetual with Software Assurance.
|
Ownership |
Full ownership; no need for renewal.
|
Full ownership with perpetual licenses after payment period or must renew for non-perpetual.
|
Software Assurance (SA) Benefits |
Not included.
|
Includes SA benefits such as upgrade rights, support, training, and other services.
|
Upgrade Rights |
No automatic upgrade rights; requires repurchase for new versions.
|
Free upgrade to new versions during the agreement term (if SA is active).
|
Support |
Basic support may be included for a limited time. Additional support needs to be purchased.
|
Includes 24x7 support for critical issues, training vouchers, and consulting hours.
|
Flexibility |
Limited flexibility—tied to specific device or user.
|
Flexible licensing options, including user or device-based, and multi-device use.
|
Volume Discounts |
Please fill out custom quote form.
|
Volume discounts are available based on agreement size.
|
Renewal Options |
No renewal needed; the license is perpetual.
|
Optional renewal to continue receiving Software Assurance benefits.
|
Cloud Services |
Does not include cloud services integration.
|
Can be combined with cloud services like Microsoft 365.
|
License Transferability |
License can be transferred to a new device.
|
Transferable between devices or users with Software Assurance.
|
Product Availability |
Typically, for individual products (e.g., Office, Windows).
|
Available for a broad range of Microsoft products, including Windows, Office, and servers.
|