You are on page 1of 21

Microsoft SQL Server 2012 Licensing Guide

April 2012

Contents
Overview......................................................................................................................................................................................................3 SQL Server 2012 Editions ......................................................................................................................................................................4 SQL Server 2012 Licensing Models....................................................................................................................................................4 Core-Based Licensing ..............................................................................................................................................................5 Server+CAL Licensing .............................................................................................................................................................7 Licensing SQL Server 2012 in a Virtualized Environment .........................................................................................................8 Licensing Individual Virtual Machines ..............................................................................................................................8 Licensing for Maximum Virtualization............................................................................................................................10 Advanced Licensing Scenarios and Detailed Examples............................................................................................................10 Licensing SQL Server for High Availability ...................................................................................................................11 Licensing SQL Server for Non-production Use ...........................................................................................................12 Licensing SQL Server in a Multiplexed Application Environment ........................................................................13 Licensing SQL Server for Application Mobility ............................................................................................................14 Licensing SQL Server Appliances ......................................................................................................................................15 Additional Product Information........................................................................................................................................................15 Upgrades, Downgrades and Step-Ups ...........................................................................................................................15 SQL Server 2012 Migration Options for Software Assurance Customers..........................................................17 Software Assurance Benefits...............................................................................................................................................20 Additional Product Licensing Resources ........................................................................................................................21

2

This guide does not supersede or replace any of the legal documentation covering SQL Server 2012 use rights. Specific product license terms are defined in the product Software License Terms—or in the case of Microsoft Volume Licensing—in the Microsoft Volume Licensing agreement under which the software was acquired and/or the Microsoft Volume Licensing Product Use Rights (PUR). Customers with questions about differences between this material and the agreements should contact their reseller or Microsoft account manager. MICROSOFT MAKES NO WARRANTIES. Microsoft software is licensed not sold. see the Microsoft Product List. All rights reserved. For eligibility criteria and current benefit program rules. © 2012 Microsoft Corporation. EXPRESS OR IMPLIED. Eligibility for Software Assurance benefits varies by offering and region and is subject to change. Microsoft provides this material solely for informational and marketing purposes. Customers should refer to their agreements for a full understanding of their rights and obligations under Microsoft’s Volume Licensing programs. The value and benefit gained through use of Microsoft software and services may vary by customer. Microsoft does not set final prices or payment terms for licenses acquired through resellers. Program specifications and business rules are subject to change. This licensing guide is not a legal use rights document. IN THIS SUMMARY. 3 . The Terms and Conditions of your Volume License Agreement and the Terms and Conditions under which any specific Software Assurance benefits are offered will take precedence in the case of any conflict with the information provided here.Overview This Licensing Guide is for people who want to gain a basic understanding of how Microsoft® SQL Server® 2012 database software is licensed through Microsoft Volume Licensing programs. This document is for informational purposes only. Final prices and payment terms are determined by agreement between the customer and its reseller.

The Business Intelligence Edition includes all Standard Edition capabilities. 4 . Master Data Services) Self-service Business Intelligence (Power View. SQL Server 2012 Capabilities Licensing Options Windows Server Core Edition Support Basic High Availability Basic OLTP Basic Reporting & Analytics Programmability & Developer Tools (T-SQL. along with the SQL Server 2008 R2 Parallel Data Warehouse and Parallel Data Warehouse for Developers Editions. and the Developer. The Datacenter Edition has been retired. The new editions are offered in a straightforward.microsoft.110). ● Business Intelligence Edition. which is based on the users or devices accessing the product.com/sqlserver/en/us/sql-2012-editions. partitioning) AlwaysOn High Availability StreamInsight SQL Server 2012 Editions Standard Core-Based or Server+CAL Business Intelligence Server+CAL Enterprise Core-Based Basic Basic Advanced This table shows a comparison of key capabilities across the main SQL Server 2012 editions With SQL Server 2012. plus all BI capabilities included in the Enterprise Edition. Transparent Data Encryption) Data Warehousing (ColumnStore Index. Policy-Based Management) Enterprise Data Mgmt. visit: http://www. provides premium corporate and self-service business intelligence (BI). visit: http://msdn. advanced analytics) Advanced Security (Advanced auditing. FileTable) Manageability (Management Studio. that reflected the computing power used and a Server plus Client Access License (Server+CAL) licensing model. tiered model that creates greater consistency across the product editions.aspx SQL Server 2012 Licensing Models Prior to the release of SQL Server 2012. The Workgroup and Small Business Editions have also been retired. PowerPivot for SPS) Corporate Business Intelligence (Semantic model.microsoft. The Enterprise Edition includes all the capabilities available in SQL Server 2012. performance and price requirements of organizations and individuals: ● Enterprise Edition is ideal for mission critical applications and large scale data warehousing.  For general information on each of the SQL Server 2012 editions. with all capabilities now available in SQL Server 2012 Enterprise Edition. reporting and analytics capabilities. CLR. (Data Quality Services. features and licensing. ● Standard Edition delivers basic database. SQL Server 2008 R2 and earlier software versions were licensed through Microsoft Volume Licensing programs using one of two software licensing models: a Per Processor licensing model. compression.com/en-us/library/ms143287(v=sql. a new offering.aspx  For detailed product specifications and a full feature by feature comparison of the SQL Server 2012 editions.SQL Server 2012 Editions SQL Server 2012 is offered in three main editions to accommodate the unique feature. Express and Compact Editions continue to be available. data types. the Web Edition is offered only under a Microsoft Services Provider License Agreement (SPLA).

In the new computing-power based license model for SQL Server 2012. Licensing Options Server+CAL Core-based Requirements SQL Server 2012 Editions Enterprise Business Intelligence Standard Description High-end datacenter. With the Per Core model. customers do not need to purchase additional client access licenses (CALs) to access the SQL Server software. the Per Core model allows access for an unlimited number of users or devices to connect from either inside or outside an organization’s firewall. Unlike the Server+CAL licensing model. Some processors have two cores. Microsoft continues to offer customers a variety of licensing options aligned with how customers typically purchase specific workloads. each containing six physical cores Physical Server Physical Processor Physical Core Hardware Thread Physical Operating System Environment A server is a physical hardware system capable of running server software. For detailed definitions of these and other key licensing terms. some four. for customers who cannot count users or require premium database capabilities. However. please refer to the Microsoft Volume Licensing PUR 5 . regardless of whether solutions are deployed on physical servers on-premise. A hardware thread is either a physical core or a hyper-thread in a physical processor. A hardware partition or blade is considered to be a separate physical hardware system.With SQL Server 2012. and so on. The number of core licenses needed depends on whether customers are licensing the physical server or individual virtual operating system environments (OSEs). or in virtual or cloud environments. Core-based licensing gives customers a more precise measure of computing power and a more consistent licensing metric. A processor is generally a physical chip that resides in a physical socket of the hardware partition and contains one or more cores. the measure of computing power is shifting from physical processors to cores. data warehousing and BI capabilities Enterprise BI and high scale analytics Basic database and BI capabilities SQL Server CALs required SQL Server CALs required when licensing Server+CAL This table compares the licensing options for each of the main SQL Server 2012 editions Core-Based Licensing Under the new Per Core licensing model. A physical operating system environment (OSE) is configured to run directly on a physical hardware system and is all or part of an operating system instance. Physical Processors Physical Server Physical Cores This figure depicts a physical server with two physical processors. each server running SQL Server 2012 software or any of its components (such as Reporting Services or Integration Services) must be assigned an appropriate number of SQL Server 2012 core licenses. Figure 3 shows an example of two physical processors with six cores each. The Server+CAL licensing model provides the option to license users and/or devices and then have low cost access to incremental SQL Server deployments. Each physical processor contains smaller processing units called physical cores. the way Microsoft licenses SQL Server for computing power is changing. some six or eight.

75 4 4 2 2 * This is an example of the core factor table and how it is used to calculate core license requirements. 62XX Series Processors with 6 or more cores Single-Core Processors Single-Core Processors Dual-Core Processors Dual-Core Processors Core Factor Core Factor 1 1 0. 42XX. systems that integrate with external-facing workloads (even if external data goes through one or more other systems).How to License SQL Server 2012 Using the Per Core Licensing Model When running SQL Server in a physical OSE. Purchase the appropriate number of core licenses required for the server. For details on how to license virtual OSEs using the Per Core model. so customers must divide the number of licenses required by two to determine the actual number of line items (licensing SKUs) to order. Multiply the number of cores by the appropriate core factor to determine the total number of licenses required for the server. ● Deploying Internet or extranet workloads. Count the total number of physical cores for each server. 41XX. Core licenses are sold in packs of two. ● Implementing centralized deployments that span a large number of direct and/or indirect users/devices. 32XX. 62XX Series Processors with 6 or more cores AMD Processors 31XX. Note: The core factor used depends on the processor type deployed. ● The total licensing costs are lower than those incurred using the Server+CAL licensing model. or when the number of users/devices cannot be counted easily. 42XX. 2. all physical cores on the server must be licensed.microsoft. including how to determine and use the appropriate core factor when licensing SQL Server 2012 under the Per Core model. 2 Intel Xeon 6-core processors 2 Intel Xeon 6-core processors x x = = Number of core licenses required: Number of core licenses required: 12 12 1 1 12 12 (total cores on the server) (total cores on the server) (core factor from the table below) (core factor from the table below) core licenses required core licenses required (cores sold in 2-core packs) (cores sold in 2-core packs) Purchase 6 “2-Pack” SKUs of core licenses Purchase 6 “2-Pack” SKUs of core licenses SQL Server Core Factor Table* SQL Server Core Factor Table* Processor Type Processor Type All processors not mentioned below All processors not mentioned below AMD Processors 31XX. refer to the Licensing SQL Server 2012 for Virtual Environments section of this guide.75 0. 32XX. 61XX. visit: http://go. 3.com/fwlink/?LinkID=229882 The Per Core licensing model is appropriate when: ● Deploying the SQL Server 2012 Enterprise Edition. customers must: 1. 6 . 61XX. 41XX. To determine and acquire the correct number of core licenses needed. Core factors are subject to change and customers can find the most recent version of the core factor table at the link below. Â For more information on the SQL Server 2012 Core Factor Table.

refer to the Additional Product Information section of this guide. For more detailed information on this topic. For details on how to license SQL Server in a multiplexed application environment. Note: The use of hardware or software that reduces the number of devices or users that directly access or use the software (multiplexing/pooling) does not reduce the number of CALs required. ● Deploying SQL Server Standard Edition in scenarios where customers can easily count users/devices and the total licensing costs are lower than using the Per Core licensing model. regardless of the platform (32-bit. To access a licensed SQL Server. Each server license allows customers to run any number of SQL Server instances in an OSE. a user CAL or device CAL can be used. Once customers have purchased the necessary CALs.Server+CAL Licensing When licensing SQL Server software under the Server+CAL model. Hardware partitions and blades are considered to be separate servers for licensing purposes and SQL Server software licenses cannot be assigned to more than one server at any time. Note: Devices not operated by humans require device CALs. only low cost server licenses need to be purchased for new server system deployments. ● Accessing “legacy” Enterprise Edition Servers in the Server+CAL licensing model. either physical or virtual. While version specific. each operating system environment (OSE) running SQL Server 2012 software or any of its components must have a SQL Server 2012 server license assigned to the physical server hosting the OSE. Note: Running SQL Server software on different hardware partitions or blades requires separate software licenses. 64-bit or IA64) or product edition. 7 . to access a server running SQL Server 2012 software. customers purchase a server license for each server and a client access license (CAL) for each device (Device CAL) and/or user (User CAL) accessing SQL Server or any of its components. Server License Licenses the server on which SQL Server software or any of its components is running Device CAL Licenses a device accessing or using the services or functionality of SQL Server or any of its components OR User CAL Licenses a person accessing or using the services or functionality of SQL Server or any of its components This figure illustrates the licenses used in the Server+CAL licensing model How to License SQL Server 2012 Using the Server+CAL Licensing Model Under the Server+CAL licensing model. each user or device must have a SQL Server CAL that is the same version or newer than the SQL Server software version being accessed. ● Accessing multiple SQL Server databases and/or planning to scale out the use of SQL Server by adding new servers over time. each SQL Server 2012 CAL provides access to any number of current and/or prior version licensed SQL Server instances in a customer’s organization. The Server+CAL licensing model is appropriate when: ● Deploying the SQL Server Business Intelligence Edition. For human operated devices such as PCs or hand-held terminals. For example. it is a license granting users and devices access to the SQL Server software. A CAL is not software. even when connecting to SQL Server indirectly. a user needs a SQL Server 2012 CAL. refer to the Advanced Licensing Scenarios section of this guide. including legacy SQL Server Workgroup and SQL Server for Small Business edition servers.

Virtual Machine with Virtual Cores Hypervisor This figure depicts two virtual machines. When deploying SQL Server 2012 software in virtualized environments. Maximum virtualization can be achieved by licensing the entire physical server with Enterprise Edition core licenses and covering those licenses with Software Assurance (SA). or to license for maximum virtualization in highly virtualized. With SQL Server 2012. For licensing purposes.Licensing SQL Server 2012 in a Virtualized Environment Microsoft SQL Server is increasingly being deployed in virtualized environments. To license individual VMs using the Per Core model. subject to a four core license minimum per VM. SQL Server 2012 offers expanded virtualization rights. How to License Individual Virtual Machines Using the Per Core Licensing Model Similar to the Per Core licensing model in physical OSEs. core factors do not apply. When deploying databases in virtual environments that require just a fraction of a physical server. When licensing individual VMs. For more information on licensing for application mobility. 8 . which enable running instances of SQL Server concurrently in separate virtual OSEs (or virtual machines). virtual CPU. customers must purchase a core license for each v-core (or virtual processor. virtual thread) allocated to the VM. Note: Licensing individual VMs is the only licensing option available for SQL Server 2012 Standard Edition customers who are running the software in a virtualized environment under the Per Core model. options and benefits to provide greater flexibility for customers deploying in virtual environments. refer to the Advanced Licensing Scenarios section of this guide. customers have the choice to license either individual virtual machines as needed. each containing two virtual cores Licensing Individual Virtual Machines As customers consolidate existing workloads and refresh hardware. private cloud. Microsoft provides support for license mobility as an exclusive SA benefit available for all SQL Server editions. a v-core maps to a hardware thread. or dynamic environments. they may find that a SQL Server instance uses only a fraction of available system computing power. all virtual cores (v-cores) supporting virtual OSEs that are running instances of SQL Server 2012 software must be licensed accordingly. savings can be achieved by licensing individual virtual machines (VMs).

) How to License Individual Virtual Machines Using the Server+CAL Licensing Model To license individual VMs using the Server+CAL model (available for SQL Server 2012 Standard and Business Intelligence editions only) customers simply purchase one server license for each VM running SQL Server software.1 2 License the virtual cores in each virtual machine There is a minimum of 4 core licenses required for each virtual machine VM #1 VM #2 VM #3 VM with 2 v-cores 4 core licenses required VM with 4 v-cores 4 core licenses required VM with 6 v-cores 6 core licenses required This figure illustrates the licensing requirements for three different virtual machines under the Per Core licensing model Additional licenses are required when: ● A single hardware thread is supporting multiple virtual cores. please refer to the Advanced Licensing Scenarios section of this guide. regardless of the number of virtual processors allocated to the VM. (A core license allows a single v-core to be supported by a single hardware thread. For details on how to license individual VMs with legacy SQL Server Enterprise Edition server licenses. regardless of a virtual or physical deployment.) ● Multiple hardware threads are supporting a single virtual core. 1 2 License each virtual machine with a server license License each user or device with a CAL VM #1 VM #2 With SQL Server 2012 Business Intelligence Edition 1 server license required With SQL Server 2012 Business Intelligence Edition 1 server license required 3 Client Access Licenses required This figure shows an example of licensing virtual machines under the Server+CAL licensing model 9 . (A core license is required for each v-core. requires a SQL Server 2012 CAL. Note: Each user or device accessing SQL Server 2012 software.

With the addition of Software Assurance (SA) coverage on all Enterprise Edition core licenses (for a fully licensed server) customers’ use rights are expanded to allow any number of instances of the software to run in any number of OSEs (physical or virtual). Licensing for maximum virtualization can be an ideal solution when: ● Deploying SQL Server private cloud scenarios with high VM density. This valuable SA benefit enables customers to deploy an unlimited number of VMs to handle dynamic workloads and fully utilize hardware computing capacity. customers that have licensed all physical cores on the server can run an unlimited number of instances of the software in a number of OSEs (physical and/or virtual) equal to the number of core licenses assigned to the server. a four processor server with four cores per processor—fully licensed with sixteen core licenses—can run SQL Server software in up to sixteen VMs. For detailed licensing terms and additional licensing guidance applicable to more specific software deployment scenarios. Note: This benefit ends when SA coverage expires. Customers who have licensed all the physical cores on the server and want to run SQL Server 2012 software in more VMs than are permitted can assign additional core licenses to the licensed server. 10 .Licensing for Maximum Virtualization With the SQL Server 2012 Enterprise Edition. regardless of the number of virtual cores allocated to each VM. a customer wanting to run the SQL Server Enterprise Edition in eighteen VMs would simply acquire and assign eighteen core licenses to that server. ● Hyper-threading is being used. For example. so in the previous example. Each additional core license allows deployment of SQL Server software in an additional VM. refer to the Microsoft Volume Licensing PUR. 1 1 2 Fully license the server with SQL Server 2012 Enterprise Edition core licenses and Software Assurance Deploy an unlimited number of virtual machines 2 What you License All physical cores in the server What you Deploy Unlimited VMs VM #6 VM #5 VM #4 VM #3 VM #2 VM #1 What to Buy 12 SQL Server 2012 Enterprise Edition core licenses + SA Shown is an example of licensing for unlimited VMs with Enterprise Edition core licenses and SA (assuming a core factor of 1) Advanced Licensing Scenarios and Detailed Examples This section introduces a few advanced SQL Server 2012 licensing scenarios to help illustrate how customers can apply some of the key licensing principals covered in this guide. ● Using dynamic provisioning and de-provisioning of VM resources.

Active Passive 12 core licenses required No additional licenses required Active Active 12 core licenses required 12 core licenses required Total of 24 core licenses required This figure shows an example of licensing active and passive secondary SQL Server 2012 databases with a core factor of 1 Failover Basics For each properly licensed instance of SQL Server. This way. then it must be licensed for SQL Server. recovered and continued by another server. when the failover server takes over. database mirroring and two-node failover clustering. or performing any “work” such as additional backups being made from secondary servers. 11 . All editions of SQL Server 2012 provide basic high availability features including backup log shipping. ● The secondary server used for failover support does not need to be separately licensed for SQL Server as long as it is truly passive. ● When licensing SQL Server 2012 under the Per Core model. This passive failover instance can run on a server other than the licensed server. it is adequately licensed. A passive SQL Server instance is one that is not serving SQL Server data to clients or running active SQL Server workloads. If it is serving data. it cannot require more core licenses than the licensed primary system. ● Primary server licenses include support for one secondary server only. Note: The rights to run a passive instance of SQL Server for temporary support are not transferable to other licensed servers for purposes of providing multiple passive secondary servers to a single primary server. its processing will be picked up. and any additional secondary servers must be licensed for SQL Server. active (readable) secondary servers and support for multi-site failover clustering. such as reports to clients running active SQL Server workloads. customers can run a supporting passive instance in a separate OSE for temporary support. the number of core licenses must be based on the server that requires the higher number of licenses. Advanced (AlwaysOn) high availability features in SQL Server 2012 Enterprise Edition include enhanced support for multiple. For a passive instance of SQL Server to be properly licensed.Licensing SQL Server for High Availability SQL Server software can be configured so that if one server fails.

test or demonstration purposes. ● Before using SQL Server software under the Developer Tools model. Customers cannot use the software in a production environment and any test data that was used for design. develop. reporting and backup workloads due to better balancing of workloads across instances.Los Angeles (Secondary) Passive Boston (Primary) Active Passive Secondary Instance No additional licenses required Dallas (Secondary) 12 core licenses required Passive TOTAL of 24 core licenses required Additional Passive Secondary Instance 12 core licenses required This figure shows an example of licensing SQL Server 2012 when using multiple passive secondary databases with a core factor of 1 AlwaysOn Availability Groups New for the SQL Server 2012 Enterprise Edition. One license is required for each person that accesses or uses the software. Licensing SQL Server for Non-production Use The SQL Server 2012 Developer Edition is a full-function version of SQL Server software—with all the features and capabilities of the Enterprise Edition—licensed under the Developer Tools model. test or demonstration purposes. when the servers used for failover purposes are no longer truly passive—they must be fully licensed accordingly. The ability to use secondary servers for more than just passive failover support can improve the performance of primary. When using SQL Server software for development. and all licensed users can use copies to design. ● Once licensed. development or test purposes must be removed prior to deploying the software for production use. customers can install the SQL Server 2012 Developer Edition software. customers must assign one license to each user accessing the software. test and/or demonstrate programs. which is a “per user” model. helping to provide better return on hardware investment. because it allows customers to run the software on multiple devices (for testing purposes. This is significant. As long as only licensed users have access to the software. 12 . for example) without having to license each non-production server system. customers can install any number of copies of the software on any number of servers that are used exclusively for development. AlwaysOn Availability Groups enable customers to configure multiple databases that will failover as a unit. with support for up to four active secondary servers and two synchronous secondary servers. Note: When secondary servers are actively used to support these additional workload scenarios—that is. only the users are licensed and a corresponding license for the actual server systems running SQL Server software is not required.

services. files.MSDN Subscriptions Customers can also choose to license SQL Server software for non-production use through certain MSDN subscription offerings. ● Multiplexing does not reduce the number of Microsoft licenses required. MSDN subscriptions are licensed on a per-user basis and the software cannot be used in a production environment. Â For more information on MSDN Subscriptions that include SQL Server software. or view data from a SQL Server database through a pooling device (such as the CRM Server in the figure above). For example. When licensing SQL Server software under the Server+CAL licensing model. Users are required to have the appropriate licenses.com Licensing SQL Server in a Multiplexed Application Environment “Multiplexing” refers to the use of hardware or software to pool connections. or functionality does not affect the number of CALs required. or view data from a SQL Server database.microsoft. ● Any user or device that accesses the server. Similar to the standalone SQL Server Developer Edition. Premium and Ultimate subscription levels. Without Multiplexing Licensed in the Server+CAL model Users directly accessing SQL Server With Multiplexing User CALs required CRM Users accessing SQL Server through another application This figure illustrates the licenses used in the Server+CAL licensing model via multiplexing SQL Server CALs are required for users or devices that directly input into. Similarly. the receiving employee does not require a CAL (as long as the report does not access a server running SQL Server in some way). 13 . users and devices that indirectly access SQL Server data through another application or hardware device require SQL Server CALs. ● The number of tiers of hardware or software between the SQL Server and the user or devices that ultimately use its data. if an employee sends a Microsoft Office Excel® version of a report to another employee. ● Manual transfer of data from employee to employee does not require a CAL for the receiving employee. visit: http://msdn. This includes users who view data through web-based applications or enter information into a database through an intermediary product. Multiplexing can also include reducing the number of devices or users SQL Server directly manages. reroute information. regardless of their direct or indirect connection to SQL Server. or reduce the number of devices or users that directly access or use SQL Server. query. including the Visual Studio Professional. data or content provided by the server that is made available through an automated process requires a SQL Server CAL. SQL Server CALs are required for users or devices that input data into. query.

With SA. these rules do not change. they can only be reassigned to another server in another server farm. core licenses are being reassigned within the same server farm through License Mobility 14 . With multiplexing. A given data center may only be part of one server farm. Likewise. licenses can be reassigned within the same server farm at any time VM VM SA Benefit Server 1 Server 2 In this figure. customers can re-assign SQL Server licenses to different servers within a server farm as often as needed. however. » » A server farm may consist of up to two data centers located in time zones that are within four hours of one another and/or with the European Union (EU) and/or European Free Trade Association (EFTA). recipient users do not require a SQL Server CAL. recipient users do not require a SQL Server CAL. or to a non-private cloud. Note: License Mobility relates directly to the reassignment of software licenses only. License Mobility is available for licenses under both the Per Core and Server+CAL license models. Customers can also reassign licenses to third party shared servers. but if these users print the data. Â For more details on how multiplexing affects the licensing of SQL Server 2012 products under the Server+CAL model.When users actively send SQL Server data by email or other messaging technology. ● All SQL Server licenses with active SA can be reassigned to another server within the server farm as often as needed. and they cannot be reassigned to a third party web hoster or non-private cloud. the paper distribution of data does not require SQL Server CALs for the recipients of the paper report. License Mobility can benefit customers who license individual virtual machines (VMs) and then want to reassign those licenses to different VMs within a server farm—as workloads move dynamically—or to VMs in cloud environments. once every 90 days. ● SQL Server licenses that are not covered with active SA can only be reassigned to a different server within a server farm once every 90 days. With this SA benefit. Users who receive data directly or indirectly from SQL Server require CALs.docx Licensing SQL Server for Application Mobility License Mobility is a use right that is available for all editions of SQL Server 2012 software licenses with active Software Assurance (SA) coverage.com/download/8/7/3/8733d036-92b0-4cb8-8912-3b6ab966b8b2/ multiplexing. download the Volume Licensing Brief at: http://download. at any time.microsoft.

visit: http://www. 15 . By deploying an appliance instead of building a solution.aspx Additional Product Information Upgrades.microsoft.com/licensing/software-assurance/license-mobility. dramatically accelerate time to value. pre-tuned and optimized for SQL Server. customers can help reduce investment costs.com/sqlserver/en/us/solutions-technologies/appliances. and enable IT resources to focus on other priorities. Appliance offerings optimized for the SQL Server Parallel Data Warehouse and other editions of SQL Server software include: ● Dell Parallel Data Warehouse Appliance ● HP Enterprise Database Consolidation Appliance ● HP Enterprise Data Warehouse Appliance ● HP Business Decision Appliance ● HP Business Data Warehouse Appliance Note: While SQL Server appliances sold by hardware partners are delivered pre-installed with SQL Server software. customers must acquire the necessary software licenses through a Microsoft Volume Licensing agreement before actually deploying the appliance for use. Downgrades and Step-Ups When licensing SQL Server 2012 software. licenses can be reassigned to third party or the cloud cloud VM VM SA Benefit 3rd Party Shared Server In this figure.With SA.  For more information on the complete portfolio of available appliance offerings for SQL Server. licenses can be reassigned to a thirdaparty hoster hoster or the at any time With SA.asp Licensing SQL Server Appliances Microsoft has partnered with leading hardware providers to offer an array of appliance-based offerings that are pre-configured. visit: http://www. several deployment options are available to support a variety of customer upgrade scenarios. core licenses are reassigned to a 3rd party shared server through License Mobility  For more information on how to use License Mobility to extend the value SQL Servers licenses.microsoft.

SQL Server 2012 use rights apply. In cases where prior version editions have been discontinued. In some cases. rights to deploy prior versions of product editions other than the edition currently licensed may also be allowed. Existing SQL Server 2008 R2 software licenses covered by SA are automatically upgraded to the corresponding SQL Server 2012 edition. 16 . the SQL Server 2012 upgrade path may be to another product edition. Software Upgrade Path for SQL Server 2008 R2 SQL Server 2008 R2 Enterprise Edition processor licenses Datacenter Edition processor licenses Enterprise Edition server licenses Standard Edition processor licenses Standard Edition server licenses Workgroup Edition processor licenses Web Edition processor licenses (non-SPLA) Workgroup Edition server licenses SQL Server for Small Business server licenses Upgrade to SQL Server 2012 Enterprise Edition core licenses Enterprise Edition server licenses (subject to 20-core limit) Standard Edition core licenses Standard Edition server licenses Standard Edition core licenses Standard Edition server licenses This table shows upgrade options available to customers with SQL Server licenses. ● Cross Edition Rights are available for certain SQL Server products only and allow customers to deploy an alternate (usually lower) edition in place of the currently licensed edition. Software Deployment Options for SQL Server 2012 Customers Licensed for: SQL Server 2012 Standard Edition Server Can Choose to Deploy: Software Edition SQL Server Standard Server SQL Server Workgroup SQL Server for Small Business SQL Server Standard Core SQL Server Web (non-SPLA only) SQL Server Workgroup SQL Server Business Intelligence SQL Server Standard Server SQL Server Enterprise Core SQL Server Business Intelligence SQL Server Standard Core SQL Server Datacenter Software Version 2012 or earlier 2008 R2 or earlier 2008 R2 or earlier 2012 or earlier 2008 R2 or earlier 2008 R2 or earlier 2012 2012 or earlier 2012 or earlier 2012 2012 or earlier 2008 R2 or earlier SQL Server 2012 Standard Edition Core SQL Server 2012 Business Intelligence Edition SQL Server 2012 Enterprise Edition Core This table shows deployment options available to customers with SQL Server licenses.● Version Upgrade Rights are offered as a Software Assurance (SA) benefit for qualified licenses and allow customers access to upgrade their deployments released at no additional cost. the product use rights for the currently licensed version and edition still apply. SQL Server cross edition rights can be combined with the version downgrade rights available for all products offered under a Volume Licensing agreement that allow customers to deploy prior versions of the software in place of the currently licensed version. SQL Server 2012 use rights apply. Note: When using version downgrade or cross edition deployment rights.

During Current Agreement Term: During the current term of SA coverage (effective on or before April 1. upgrade to and use the equivalent edition of SQL Server 2012 core-based software (in place of the licensed SQL Server 2008 R2 edition). 2012). Renewing Processor Licenses into Cores: The number of core licenses a customer is eligible to renew is based on the edition of SQL Server currently licensed and the number of cores in use when SA coverage expires: Renewing Processor Licenses into Core Licenses at the End of the SA Term Qualified perpetual license under SA as of April 1st. the lower edition license must be covered by SA. Customers with active SA coverage on qualifying SQL Server 2008 R2 processor licenses (as of April 1 2012) will be eligible to run SQL Server 2012 during their agreement term under processor use rights. SQL Server 2012 Migration Options for Software Assurance Customers To facilitate a smooth transition to the new SQL Server 2012 product edition and licensing model changes. 2012 SQL Server Datacenter Edition processor license SQL Server Enterprise Edition processor license SQL Server Standard Edition processor license SQL Server Workgroup Edition processor licenses SQL Server Web Edition (non-SPLA) processor licenses Eligible to renew into minimum number of cores 8 SQL Server Enterprise Edition core licenses 4 SQL Server Enterprise Edition core licenses 4 SQL Server Standard Edition core licenses 4 SQL Server Standard Edition core licenses 4 SQL Server Standard Edition core licenses This table shows the renewal of SQL Server licenses by edition 17 . To be eligible to step-up to a higher edition. They will also be able to renew into core licenses at their first subsequent SA expiration. for a given deployment. 2012 can also continue to acquire additional SQL Server 2008 R2 processor licenses—and upgrade those licenses to SQL Server 2012—through the end of their enrolment. Â For full details on the migration options and additional license grants available to current SA customers with eligible SQL Server 2008 R2 licenses.● Edition Step-Ups are offered as a Software Assurance (SA) benefit in certain Volume Licensing programs only and allow customers to move from a lower product edition. subject to current SQL Server 2008 R2 processor license product use rights. customers who are licensing SQL Server under the processor licensing model can. SQL Server 2012 Standard Edition server licenses can step-up to the SQL Server 2012 Business Intelligence Edition and SQL Server 2012 Standard Edition core licenses can step-up to the SQL Server 2012 Enterprise Edition. refer to the Microsoft Product List for Volume Licensing at: http://www. Customers with Enterprise Agreements effective on or before April 1. SQL Server Workgroup and (non-SPLA) Web Edition customers can run the SQL Server 2012 Standard Edition corebased software.aspx#tab=2 For SQL Server Processor Licenses with Software Assurance SQL Server 2008 R2 is the last version of SQL Server software to be licensed under the Per Processor licensing model. Step-ups between licensing models are not allowed. SQL Server Datacenter Edition customers can run the SQL Server 2012 Enterprise Edition core-based software.com/licensing/about-licensing/product-licensing.microsoft. Microsoft is offering several migration options to help customers who have invested in Software Assurance benefits to protect their current software investments.

SA coverage must be renewed based on the number of core licenses required to license all of the physical cores in the processor. visit: http://www.) As part of an SA renewal. the total number of processor licenses assigned to a given server cannot exceed the total number of physical processors in the server. (See the Microsoft Product List for Volume Licensing for full details and restrictions. a SQL Server 2008 R2 processor license is exchanged for SQL Server 2012 core licenses at SA renewal For Customers Who Do Not Renew Software Assurance Benefits Customers with perpetual use rights who choose not to renew SA coverage on SQL Server 2008 R2 processor licenses can continue to run SQL Server 2012 core-based software (including prior versions). 18 . Note: Customers who do not renew SA coverage for their existing processor licenses are no longer eligible for SA-only benefits such as unlimited virtualization and License Mobility rights.microsoft.aspx?displaylang=en&id=7826 Processor license migration path at SA renewal Renew SA 6-core processor 6-core processor 1 Enterprise Edition processor license 6 Enterprise Edition core licenses with SA In this figure. refer to the Software Assurance Benefits section of this guide. ● To exchange a SQL Server processor license for core licenses. For more information on the MAP Toolkit.) These Restrictions Apply: When processor licenses are renewed into core licenses. customers can exchange eligible processor licenses into an appropriate number of core licenses based on the above inventory and eligibility criteria.com/download/en/details. For more information on these and other benefits. ● To be eligible for more than the minimum exchange. Customers that do not maintain a record will receive a core equivalence for only the minimum number of core licenses noted for each edition in the figure above  Customers are encouraged to use the Microsoft Assessment and Planning (MAP) Toolkit or other equivalent software to acquire their record of configuration.If the number of core licenses required exceeds the minimum eligibility defined above. ● An inventory performed by the end of the first SA term ending after April 1. 2012 must be recorded to demonstrate core license needs. customers must follow SQL Server 2008 R2 use rights. subject to the following restrictions: ● When running SQL Server 2008 R2 software. they are exchanged. This exchange process supports customers’ eligibility to renew into a number of cores based on actual need at the time of renewal. the customer can take an inventory to document their actual core license needs. (Core license needs are equivalent to the cores in a physical processor multiplied by the core factor for that processor.

for customers running SQL Server 2008 R2 version software. customers must record an inventory of the actual number of cores in use to document core license needs. 19 . ● SQL Server 2012 Enterprise Edition software licensed under the Server+CAL model is intended and physically limited to only run on servers with a total of twenty cores or less: » There are now two versions of SQL Server 2012 Enterprise Edition software: a server-based version and a core-based version. Note: As stated above. 2012.● When running SQL Server 2012 software. including License Mobility rights and access to future releases. customers who upgrade to SQL Server 2012 core-based software will receive a fixed (perpetual) “core equivalence” value for each existing SQL Server 2008 R2 processor license with expiring SA. ● This core equivalence value is equal to either: » » The minimum number of core licenses defined in the license renewal section above. ● The total number of processor licenses eligible to receive more than the minimum core equivalency cannot exceed the total number of physical processors in the licensed server. Processor license migration path when not renewing SA Exit SA 6-core processor 6-core processor 1 Enterprise Edition processor license 1 Enterprise Edition processor license with a 6-core license equivalence In this figure. As stated above. ● Processor licenses with fixed core equivalence values can be combined with SQL Server 2012 core licenses of the same edition to support deployment on hardware that requires additional core licenses. 2012. customers who do not renew SA coverage for their existing SQL Server 2012 processor licenses are no longer eligible for SA-only benefits. Customers must run the software version for which they are licensed. Current customers with active SA coverage for existing SQL Server 2008 R2 Enterprise Edition server licenses should consider the following when transitioning to SQL Server 2012: ● SQL Server 2012 Enterprise Edition server licenses will be available on price lists through June 30. customers must follow SQL Server 2012 use rights. Microsoft will no longer offer the SQL Server Enterprise Edition under the Server+CAL license model. ● After their current term expires. subject to the additional restrictions listed below. multiplied by the applicable core factor for that processor type. or The actual number of cores in a physical processor. SA coverage can be renewed and maintained on SQL Server Enterprise Edition server licenses to provide continued access to SA benefits. These Restrictions Apply: For purposes of calculating on-going use rights. Enterprise Agreement (EA) and Enrollment for Application Platform (EAP) customers with active agreements on this date can continue purchasing new licenses until the end of their current agreement term. a processor license is retained when migrating to SQL Server 2012 without SA renewal SQL Server Enterprise Edition Customers Licensed Under the Server+CAL Model As of July 1.

SA benefits—including 24x7 support. As hardware capacity and licensing needs expand. Note: When reassigning a server license. Note: Each group of four VMs is subject to a 20-thread technical limit. A per instance technical limit is also enforced. all VMs associated with that server license (up to four per license) must move to another server together. licenses for different software versions cannot be 20 . customers licensed under the Server+CAL model can retain access to the latest product enhancements and advanced capabilities of the Enterprise Edition. that OSE is only permitted to access a maximum of twenty physical cores. ● If needed.» For customers running SQL Server 2012 Enterprise Edition server-based software instances in a physical environment. deployment planning services. The four VMs can use a maximum of 20 virtual cores of computing power. each set of VMs associated with a single server license (up to four per server license) can only access up to twenty hardware threads of combined power at any time. » ● Existing SQL Server 2012 Enterprise Edition server licenses continue to have tremendous value. ● SQL Server Enterprise Edition server licenses—with or without SA coverage—do not have unlimited virtualization rights. customers can assign additional SQL Server Enterprise Edition server licenses to a physical server to license additional VMs on that server. there are no programmatic conversions to core licenses. Using these benefits can help customers improve productivity and help IT efficiently deploy and manage SQL Server software. As such. Additional Considerations When Licensing Virtual Environments: Each SQL Server 2012 Enterprise Edition server license allows customers the ability to run instances of the software in up to four VMs on the licensed server. Software licenses and use rights are version specific and as such. Software Assurance Benefits Software Assurance (SA) for Volume Licensing helps boost IT productivity by enabling customers to get the most from Microsoft software products. and the latest software releases and unique technologies—are combined in one cost-effective program. and with the availability of ongoing SA coverage. This applies to new SQL Server 2012 deployments. as well as all SQL 2008 R2 deployments. user and technical training. For customers running SQL Server 2012 Enterprise Edition server licenses in virtual environments. ● License Mobility rights are allowed for SQL Server 2012 Enterprise Edition server licenses with active SA coverage only. SQL Server customers with SA coverage can enjoy the benefit of adding incremental licenses without regard to the software version licensed. 1 Enterprise Edition server license Maximum of 20 virtual cores per 4 VMs This figure depicts the deployment of four virtual machines with an Enterprise Edition server license.

aspx  For SQL Server Product Use Rights. download the Software Dependency Guide at: http://download. including what is new with this version. competitive comparisons and more.com/licensing/software-assurance/default. Note: All licenses must be covered with SA and product use rights do not change when using downgrade rights to deploy prior software versions.com/sqlserver/en/us/get-sql-server/licensing.microsoft. without the need to track or otherwise reassign covered licenses based on software version alone.  For more information on the full set of Software Assurance benefits available to help customers deploy. including new version features. SQL Server customers with active SA coverage for their SQL Server 2012 software licenses also enjoy these additional benefits: Software Assurance Benefits Overview Benefit Unlimited Virtualization License Mobility in Server Farm License Mobility through SA Cold Back Ups Special Migration Offers Additional Benefits for EAP Customers Description Allows customers to run any number of instances of SQL Server 2012 Enterprise Edition software in an unlimited number of VMs. SA customers licensed under the core licensing model (for example) can easily combine current version core licenses with future version core licenses. visit: http://www.microsoft.combined when licensing a single operating system environment.microsoft. and maximize their SQL Server Volume Licensing purchases. Enrollment for Application Platform (EAP) customers may also be eligible to receive unlimited phone hours for problem resolution support This table provides an overview of the benefits of Software Assurance.com/licensing/about-licensing/product-licensing. visit: http://www. visit: http://www.aspx 21 . Applicable under the core licensing model only. edition comparisons. please visit the following websites:  For detailed SQL Server product licensing information.com/download/3/D/4/3D42BDC2-6725-4B29-B75A-A5B04179958B/ Software_Dependency_Guide.microsoft. including additional terms and conditions that may apply.aspx  For a list of dependent licenses required for SQL Server under the terms of Volume Licensing programs. manage. Product List details.com/sqlserver/en/us/default. Refer to the Volume Licensing PUR and Product List for more details on these benefits and additional license grants available to SQL Server customers with SA. benchmarks. Allows reassignment of SQL Server 2012 licenses within a server farm more than once every 90 days Allows license reassignment of SQL Server 2012 to third party shared servers Allows backup instances of SQL Server 2012 software for temporary use in a server dedicated to disaster recovery Provides license grants and additional use terms for SQL Server 2008 R2 migrating to SQL Server 2012 product editions and license models In addition to the benefits noted above.microsoft.docx  To download a current copy of this SQL Server 2012 Licensing Guide and to get more information on how to acquire SQL Server software licenses. licensing briefs and other information on Microsoft Volume Licensing topics.aspx Additional Product Licensing Resources For more information about licensing SQL Server 2012. As a benefit of having access to—and therefore always being licensed for—the latest version of SQL Server software. visit: http://www.