Microsoft SQL Server licensing for banks and capital markets. Server plus CAL math, core licensing on regulated estates, Big Data Cluster, Azure SQL MI, and the audit traps unique to financial services.
Banks operate the densest SQL Server estates we see across any vertical. Regulatory reporting drives system count. Trading systems drive CPU count. Branch networks drive instance count. The audit math on a top ten bank can run into the hundreds of millions of dollars.
The single most common audit finding in banking SQL is the active passive boundary. Microsoft offers free failover licensing under Software Assurance but the rules are narrow.
| Configuration | Free? | Notes |
|---|---|---|
| One primary, one passive replica | Yes | With SA on primary. Standard active passive. |
| One primary, two passive replicas | No | Second replica needs full licensing. |
| One primary, one read intent replica | No | Read intent is active. Full licensing required. |
| Distributed Availability Group across regions | Partial | One free passive on the target region. Others paid. |
| Active active two node cluster | No | Both nodes serve workload. Full licensing on both. |
| Failover Cluster Instance (FCI) one active | Yes | One active node is licensed. Passive node is free with SA. |
Banks often deploy active active SQL Server pairs for trading systems. The configuration is licensed correctly at deploy time. Over time, the passive side accumulates read intent traffic from a reporting team. The audit finds the read intent flag and converts the passive license to active.
This single pattern accounts for roughly 30 percent of SQL Server audit findings in banking estates across our deal database.
Microsoft retired SQL Server Big Data Clusters in 2025. The retirement removed BDC from the price list. It did not remove deployed BDC instances from customer estates.
Each SQL Server pod in the BDC is a SQL Server instance requiring core licensing. A small BDC with 12 compute pods at 4 vCPU each requires 48 Enterprise Edition cores. List price runs 350,000 dollars plus Software Assurance. Most banking estates carry at least one dormant BDC deployment.
Azure SQL Managed Instance is the natural cloud target for banking SQL Server workloads. It carries near full compatibility with on premises SQL Server, supports Always On, and qualifies for Azure Hybrid Benefit on the licensing side.
| License posture | Azure SQL MI cost vCore hour | Notes |
|---|---|---|
| License Included | Full Azure rate | Microsoft licenses bundled inside the per vCore rate. |
| Azure Hybrid Benefit Standard Edition | Up to 30 percent off | SA on existing Standard core licenses qualifies. |
| Azure Hybrid Benefit Enterprise Edition | Up to 55 percent off | SA on existing Enterprise core licenses qualifies. |
| Three year reserved capacity, AHB applied | Up to 80 percent off | Stack reservation discount on top of AHB. |
The cleanest cloud migration is the one that funds itself. Banks have enough dormant on premises SQL licensing to subsidize a 50 percent move to Azure SQL MI before any new spend.
Banks run extreme HA, DR, and regulatory reporting requirements that drive a denser SQL Server estate than any other vertical. Active passive failover counts free. Always On Availability Groups change the math. Regulatory reporting databases often hold the dormant audit exposure.
Yes for non internet facing workloads. Banks often qualify for Server plus CAL on internal teller systems, branch reporting servers, and back office finance. External web banking workloads must run on core licensing. The split must be documented.
Active passive failover within the same farm is free under Software Assurance. Active active across two nodes requires full licensing on both nodes. Always On read replicas require full licensing on every replica. Geographically separated failover requires SA on both sides.
Big Data Cluster bundles SQL Server, Spark, and HDFS in a Kubernetes deployment. Microsoft retired Big Data Cluster in 2025 but customers still hold deployments. Each pod in the cluster is a SQL Server instance that needs core licensing. The retirement notice did not change the audit math.
Yes for greenfield workloads. Azure SQL MI is licensed per vCore per hour on the Azure rate card. The customer can apply Azure Hybrid Benefit using existing SQL Server licenses with Software Assurance. The simplification only works if the on premises license inventory is clean.
We run the buyer side process end to end with full regulatory fluency. We model the active passive boundary, audit the core license inventory, surface dormant Big Data Cluster deployments, and benchmark Azure SQL MI options. We are not a Microsoft partner.
Banks pay more on SQL Server than any other vertical. The audit math is opaque. The cleanup pays for the cloud move.
A buyer side reference on Microsoft EA renewal. Discount benchmarks, true up tactics, M365 right sizing, and the Azure commit conversation.
Independent. Buyer side. Written for CIOs, CFOs, and procurement leaders carrying Microsoft contracts. No vendor influence. No sales kickback.
Open the white paper in your browser. Corporate email only.
Open the Paper →Independent. Buyer side. Banking regulatory fluent. We have run 500 enterprise engagements.
Buyer side Microsoft insight for regulated industries. Read in five minutes.
Once a month. Audit patterns, renewal benchmarks, vendor commercial signals across Oracle, Microsoft, SAP, Salesforce, IBM, Broadcom, AWS, Google Cloud, ServiceNow, Workday, Cisco, and the GenAI vendors. No follow up sales pressure.
Free providers (Gmail, Yahoo, Outlook) cannot subscribe. Work email only. Unsubscribe in one click.