SQL Server 2014

SQL Server 2014 delivers mission-critical performance across all workloads with in-memory technologies built in, faster insights from any data with familiar tools like Excel, and a platform for hybrid cloud that enables organizations to easily build, deploy, and manage solutions that span on-premises and cloud.
Licensing editions FAQ

SQL Server 2014 will provide mission-critical performance, with in-memory built in across all workloads with greater scale and availability, all backed by enterprise-grade mission-critical support. It offers a complete business intelligence solution that delivers faster insights from any data, big and small, using familiar tools like Excel in Office and Office 365, with access to business insights on mobile devices. Plus, SQL Server 2014 will enable new hybrid cloud solutions, with an easy onramp and a complete and consistent data platform from on-premises to cloud.

There will be three main editions: Enterprise, Business Intelligence, and Standard.

  1. Enterprise for mission critical applications and data warehousing
  2. Business Intelligence for premium corporate and self-service business intelligence capabilities
  3. Standard for core database capabilities, reporting, and analytics

Enterprise, Business Intelligence, and Standard will be the main editions. The Web Edition will be offered only to hosters through the Services Provider License Agreement (SPLA). Developer and Express editions will also continue to be distributed without changes in licensing or pricing. We also offer the new Analytics Platform System appliance which includes SQL Server Parallel Data Warehouse as a component.

There are two licensing updates for SQL Server 2014 that are applicable to high-availability and business intelligence scenarios.
  1. For new SQL Server 2014 licenses, a passive secondary instance is permitted only on a license covered by Software Assurance.
  2. SQL Server 2014 Business Intelligence comes with relaxed multiplexing rules for “pooled” data sources. The CAL requirement is waived for those data sources.

The CAL waiver for SQL Server Business Intelligence applies immediately to both the 2014 and 2012 versions. Other licensing changes will take effect when SQL Server 2014 is generally available. If you have licenses for prior versions with active Software Assurance, refer to the Product List for additional information.

SQL Server 2014 will provide a variety of virtualization and cloud benefits that will help you save money on database licensing and retain flexibility in your database deployments. With SQL Server 2014, you can:

  • License individual virtual machines (VM), and when licensing per core, buy core licenses only for the virtual cores assigned to the VM.
  • License for high VM density by buying Enterprise Edition core licenses and Software Assurance for all the physical cores on the server (or server farm) and deploying an unlimited number of VMs on the licensed hardware. Without Software Assurance , VM density is limited to one VM per Enterprise Edition core license.
  • License for VM mobility across private and public clouds. VM license mobility is a Software Assurance benefit. Without Software Assurance, licenses can be moved from one server to another only once every 90 days.

Enterprise Edition includes the full capabilities of SQL Server 2014, so if you want to license a Business Intelligence Server on a per core basis, you can do so by buying Enterprise Edition. Enterprise Edition will be the preferred way to license advanced SQL Server Business Intelligence capabilities when users are uncountable (for example, external-facing workloads) or when the number of users is very high.

Yes. With SQL Server 2014, a single CAL provides access to all the server editions.

No. All licenses under Software Assurance will be able to upgrade to SQL Server 2014 at no additional cost.

Licenses purchased with Software Assurance will upgrade to SQL Server 2014 at no additional cost. If you are an Enterprise Agreement/Enrollment for Application Platform customer, you can continue buying processor licenses until your next renewal (after general availability of SQL Server 2012 ). At that time, processor licenses will be exchanged for core-based licenses sufficient to cover the cores in use by processor-licensed databases (minimum of four core licenses per processor for Standard and Enterprise editions, and minimum of eight Enterprise Edition core licenses per processor for Datacenter) . Please refer to the Product List for further migration path details.

You can perform a “self-inventory” of your environment at the end of the Software Assurance term that will provide the basis for the core licenses you will own and for which you are eligible to renew Software Assurance. We will provide access to the Microsoft Assessment and Planning (MAP) Toolkit as one way to help track and document deployments. This tool can help you plan the transition from processor-based licenses to core-based licenses by counting both processors and cores across your deployments. If you are not able to document your SQL Server deployments, we will exchange processors based on a standard conversion ratio. We encourage you to work with your Microsoft or Partner representative to determine an optimal transition plan.

No. Enterprise Edition is no longer available in the Server + CAL model for SQL Server 2014.

Yes. All existing licenses of the Enterprise Edition in the Server + CAL licensing model with Software Assurance can be upgraded to SQL Server 2014, and Software Assurance can be maintained to provide access to future software updates. These licenses will continue under the Server + CAL licensing model.

Existing Enterprise Edition licenses in the Server + CAL licensing model that are upgraded to SQL Server 2014 and beyond will be limited to server deployments with 20 or fewer cores. This 20-core limit applies only to SQL Server 2014 Enterprise Edition Server licenses in the Server + CAL model and will still require the appropriate number/versions of SQL Server CALs for access.

Related resources

(PDF, 1.26 MB)
Download detailed information about licensing SQL Server 2014.

Get details on how to evaluate, purchase, and deploy SQL Server 2014.

(PDF, 531 KB)
Read an overview of licensing information for SQL Server 2014.

(PDF, 485 KB)
Download definitions of key terms related to server licensing and learn the basics of the per core licensing model.

Download information about licensing models for using Microsoft server products with virtualization technologies.

Related links