SQL No-SA SQL Server License Calculator & Estimator 2025 2022 2019 August 15, 202537 views0 By IG Share Share Navigating SQL Server perpetual licensing without Software Assurance (SA) can be complex and costly if not planned correctly. This tool is designed to simplify the process. Use our interactive estimator to calculate your license requirements for various on-premises and cloud scenarios, including Per Core licensing for physical hosts, Server+CAL for virtual machines, container deployments, and high availability/disaster recovery setups. Get a clear picture of your licensing needs and understand the specific limitations and options when migrating to Azure without the Hybrid Benefit. SQL Server (No-SA) Licensing Options Estimator SQL Server (No-SA) Licensing Estimator Plan deployments when your SQL Server perpetual licenses do not include Software Assurance (SA). This tool computes license counts and clearly flags what’s not permitted without SA. For guidance only—validate against current Product Terms. No SA mode locked Reset Export Summary (JSON) Edition & Model Edition Enterprise Standard Enterprise for high-end needs; Standard for core database capabilities. Licensing model Per Core Server + CAL (Std only) 'Per Core' for performance; 'Server+CAL' for a known number of users (Standard only). Host Hardware (for Per Core) Physical processors Number of CPU sockets on the server motherboard. Total physical cores Total cores across all physical processors. Rule: license all physical cores; min 4 core licenses per processor. Optional Pricing Core — Enterprise Your cost per Enterprise core license. Core — Standard Your cost per Standard core license. Server (Std) Your cost for one Standard Server license. CAL Your cost for a single Client Access License. Physical Host — Per Core Core licenses required — Sold in 2-packs ⇒ — Est. cost — using current per-core input Enterprise max-virtualization (No-SA rule) If you fully license all physical cores with Enterprise (no SA), you may run up to as many VMs/containers as the number of core licenses assigned on that server. It is not unlimited without SA. Planned VMs on this host How many SQL virtual machines will run here. Max VMs/containers allowed — Note: License reassignment follows the 90-day rule without SA. Virtualization Choices (No-SA) Option Allowed w/o SA? How to estimate Per-VM (vCore) licensing ❌ Not allowed Requires SA/subscription Host fully licensed (Enterprise) ✅ Yes Use Physical Host card Server+CAL for VMs (Standard) ✅ Yes Use box below VMs via Server+CAL (Standard) Number of SQL VMs (Std) Each VM needs a Standard Server license. CAL type User CALs Device CALs License per user or per device. CAL count Total unique users or devices needing access. Std server licenses — CALs — Est. cost — Containers (No-SA) Containers to run Total number of SQL Server containers. vCores per container Rule: min 4 core licenses per container. Path Allowed? Licenses computed Per-container via Per Core✅ Yes— cores (— × 2-packs) Per-container via Server+CAL (Std)✅ Yes— Server licenses + CALs Enterprise host fully licensed✅ Yes— containers max Unlimited containers in a VM❌ NoRequires SA Est. cost (Per-container via Per Core) — HA/DR Impact (No-SA) Without SA there are no “free” passive replicas. Any installed secondary (HA or DR), even if passive, must be fully licensed to the level of the primary. Primary core requirement Core license count of the production server. Number of replicas (HA+DR) Total passive servers for failover/DR. Extra cores needed— 2-packs— Est. cost— SQL Server Software Assurance (SA) Benefits Checker Software Assurance Benefits Checker Quickly see the key benefits and limitations of SQL Server licensing based on your Software Assurance (SA) status. Do you have active Software Assurance? Yes No Migration to Azure (No-SA) Key Limitation: Without Software Assurance (SA), you cannot use the Azure Hybrid Benefit. This means you cannot bring your existing perpetual licenses to Azure to get a discount on pay-as-you-go rates. Your primary options for running SQL Server in Azure without SA are: 1. Azure Virtual Machines (Pay-as-you-go) You deploy an Azure VM using a marketplace image that includes the SQL Server license. The cost of the license is built into the hourly price of the virtual machine. You pay for what you use, but at the full rate. 2. Azure SQL Managed Instance or Azure SQL Database (PaaS) These are fully managed Platform-as-a-Service (PaaS) offerings. The SQL Server license is always included in the service's pricing. This simplifies licensing but is a different operational model than running SQL Server on a VM. Summary What you CAN do without SA License all physical cores (min 4 per processor). On Enterprise hosts: run VMs/containers ≤ core licenses assigned. Use Server+CAL with Standard for VMs/containers. License individual containers with Per Core (min 4 cores each). What is NOT available without SA Per-VM (vCore) licensing and license mobility. Unlimited virtualization/containers. “Free” passive HA/DR replicas. Azure Hybrid Benefit & Power BI Report Server. Disclaimer: The Questions and Answers provided on https://gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
Azure SQL Server 2025 Upgrade & Backwards Compatibility Guide Steps The release of SQL Server 2025 is more than a version bump—it’s a strategic leap ...
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server Even though it’s flashy and glamorous being a Data Engineer these days, it comes with ...
Azure Azure SQL Managed Instance General Purpose vs Business Critical In this article, I will try to compare the Azure SQL Managed Instance General Purpose ...
Azure Azure SQL DTU to vCore Migration Steps for PAAS Databases on Cloud In this article, we are going to talk about Azure SQL DTU to vCore Migration. ...
Azure How To Change Azure SQL DB MAXDOP Settings Using T-SQL Command In this article, we are going to discuss how to change Azure SQL db MAXDOP ...
Azure Azure SQL Standard vs Premium Specification Comparison & Differences In this article, we will be comparing Azure SQL Standard vs Premium service tiers. We ...
Azure Azure SQL Database vCores vs DTU Feature Comparison In this article, we are going to compare Azure SQL Database vCores vs DTU pricing ...
Azure How To Do Azure AD Authentication with SSIS in VM Running SQL Server Can you do Azure AD Authentication with SSIS running in a Virtual Machine on the cloud? ...
SQL Server Unable to create databases in SQL Server Management Studio 2016 For Dynamic 365 While working on the “Bring Your Own Database to Azure” functionality in Microsoft Dynamics 365 ...
Azure SQL Server Analysis Services Performance Tuning on Azure Virtual Machines In this post, we will be covering SQL Server Analysis Services (SSAS) Performance tuning best practices ...
Azure Azure SQL Data Sync Limitations Pricing and Alternatives Before we talk about the Azure SQL Data Sync Limitations, we will need to understand ...
Azure How To Do Point In Time Restore of Azure SQL Databases From Backups If you have your Databases hosted on Microsoft’s Azure cloud service, you can breathe easy. ...