Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Table of contents Exit focus mode. Table of contents. Editions and supported features of SQL Server Note Although you can install an instance of SQL Server on a computer that is running IIS, this is typically done only for small Web sites that have a single server computer.

Submit and view feedback for This product This page. View all page feedback. In this article. The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization 1 , and end-to-end business intelligence – enabling high service levels for mission-critical workloads and end-user access to data insights.

SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premises and cloud – enabling effective database management with minimal IT resources.

SQL Server Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large-scale Web properties.

It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications. Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications.

SQL Server Express LocalDB is a lightweight version of Express that has all of its programmability features, runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites. SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to Hadoop and other heterogeneous data sources, and Machine Learning Services to run Python and R scripts with relational data.

Analysis Services includes the tools for creating and managing online analytical processing OLAP and data mining applications. Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications. Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data.

MDS can be configured to manage any domain products, customers, accounts and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data. Machine Learning Services In-Database supports distributed, scalable machine learning solutions using enterprise data sources. SQL Server Machine Learning Server Standalone supports deployment of distributed, scalable machine learning solutions on multiple platforms and using multiple enterprise data sources, including Linux and Hadoop.

Go behind the data. Expand all Collapse all. SQL Server news. Learn more. Read the report. Get to know Azure SQL. Feature availability Not supported Fully supported. View the new capabilities of SQL Server Play Play. Watch video. Watch now. SQL Server Building applications using graph data. SQL Features. Highest performing data warehouses Get support for small data marts to large enterprise data warehouses while reducing storage needs with enhanced data compression. Least vulnerable database Security and compliance Protect data at rest and in motion with a database that has had the least vulnerabilities of any major platform for six years running in the NIST vulnerabilities database National Institute of Standards and Technology, National Vulnerability Database, 17 Jan, Mission-critical availability High availability and disaster recovery Gain mission-critical uptime, fast failover, easy set-up and load balancing of readable secondaries with enhanced Always On in SQL Server — a unified solution for high availability and disaster recovery on Linux and Windows.

End-to-end mobile BI Corporate business intelligence Scale your business intelligence BI models, enrich your data, and ensure quality and accuracy with a complete BI solution.

End-to-end mobile BI on any device Gain insights and transform your business with modern, paginated reports and rich visualisations. Consistent Experience Now on Windows, Linux and Docker Develop once and deploy anywhere with our consistent experience from on-premises to cloud.

Consistent data platform from on-premises to cloud Get a consistent experience from on-premises to the cloud — letting you build and deploy hybrid solutions for managing your data investments. Available SQL Server editions. Enterprise Access mission-critical capabilities to achieve unparalleled scale, security, high availability and leading performance for your Tier 1 database, business intelligence and advanced analytics workloads.

Download the datasheet. Standard Find rich programming capabilities, security innovations and fast performance for mid-tier applications and data marts.

Express Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Developer Build, test and demonstrate applications in a non-production environment with this full-featured edition of SQL Server Other SQL Server editions. SQL Server Web edition Use a secured, cost-effective, highly scalable data platform for public websites — available to third-party hosting service providers only.

NET websites and Windows desktop applications with a free, embedded database app. Download the app. Simple pricing metrics Pay by processing power for mission-critical applications as well as business intelligence. Flexibility and innovation Cloud-optimised licensing with the ability to license virtual machines, and the flexibility to move from server to server, to hosters, or to the cloud, on the operating system of your choice. Industry-leading TCO Get outstanding value at any scale compared to all major vendors.

SQL Server pricing. How to buy SQL Server. Search solution providers. Contact your Microsoft account representative Call your account manager or contact your regional Microsoft office for further details.

Buy now. Get SQL Server help. Find SQL Server support. Follow us. Share this page. SQL Server SQL Server R2.

In-Memory Columnstore. Real-time operational analytics. Buffer Pool extension to SSD. Adaptive Query Processing [2]. Always On [2]. Basic Availability Groups.

Transparent data encryption [2]. Backup encryption support. Encryption at rest and in motion. Separation of duties. Backup to Azure. Disaster recovery to Microsoft Azure. Optimised virtual machine images in Azure gallery. Stretch Database. Management and programmability. Runs on Linux and Docker Containers. Temporal tables. JSON support. Graph data support. BI and analytics.

Integration services managed as a server. Tabular BI semantic model [2]. Master data services [2]. Data quality services [2]. End-to-end Mobile BI on any device.

SQL Server Enterprise. SQL Server Standard. SQL Server Express. SQL Server Developer. Maximum number of cores. Memory: Maximum buffer pool size per instance. Operating system max. Memory: Maximum Columnstore segment cache per instance.

Memory: Maximum memory-optimised data per database. Maximum database size. Production use rights. Unlimited virtualisation, a software assurance benefit. OLTP performance. Manageability: Management Studio, policy-based management. Advanced security: Always Encrypted Row-level security, data masking. Compliance reporting with SQL Server audit. Transparent data encryption.

Data integration. Advanced data integration: fuzzy grouping and look ups. Data warehousing. In-memory columnstore [3]. Adaptive Query Processing [6]. PolyBase [4], [ 5 ]. Business intelligence. Maximum memory utilised per instance of Analysis Services [5]. Maximum memory utilised per instance of Reporting Services [5]. Express with Advanced Services: 4 GB. Basic reporting and analytics [5]. Mobile reports and KPIs [5]. Advanced analytics.

Hybrid cloud. Stretch Database [5]. SQL Server editions. Ideal for…. Licensing model. Channel availability. Open no level price USD.

 
 

Editions and supported features – SQL Server | Microsoft Learn.

 

Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers. Take advantage of breakthrough scalability, performance and availability for mission-critical, intelligent applications and data warehouses. Protect data at rest and in motion with the least vulnerable database over the last seven years in the NIST vulnerabilities database.

Get the resources and information you need to start your SQL Server migration. Get the technical resources, documentation and code samples you need to support all areas of your data estate — from discovery and research to implementation and maintenance. Help your organisation improve cost-efficiency, agility and scalability by migrating to the cloud. Use this guide to help with planning and implementing your end-to-end database migration strategy, as well as tools to make your migration faster and easier.

SQL Server datasheet. SQL Server white paper. SQL Server on Linux white paper. SQL Server graph capabilities infographic. SQL Server features from to infographic. SQL Server Multiplatform becomes reality. Python in SQL Server enhanced in-database machine learning. View all. Transform your business with a unified data platform.

Why go anywhere else? Get record-breaking performance now on Windows and Linux. Get support for small data marts to large enterprise data warehouses while reducing storage needs with enhanced data compression. Scale to petabytes of data for enterprise-grade relational data warehousing — and integrate with non-relational sources like Hadoop.

Protect data at rest and in motion with a database that has had the least vulnerabilities of any major platform for six years running in the NIST vulnerabilities database National Institute of Standards and Technology, National Vulnerability Database, 17 Jan, High availability and disaster recovery.

Gain mission-critical uptime, fast failover, easy set-up and load balancing of readable secondaries with enhanced Always On in SQL Server — a unified solution for high availability and disaster recovery on Linux and Windows.

Plus, put an asynchronous replica in an Azure Virtual Machine for hybrid high availability. Corporate business intelligence.

Scale your business intelligence BI models, enrich your data, and ensure quality and accuracy with a complete BI solution. SQL Server Analysis Services help you build comprehensive, enterprise-scale analytic solutions — benefiting from the lightning-fast performance of in-memory built into the tabular model.

Reduce time to insights using direct querying against tabular and multi-dimensional models. Gain insights and transform your business with modern, paginated reports and rich visualisations. Now in SQL Server , manage and query graph data inside your relational database. In-database advanced analytics. Move beyond reactive and into predictive and prescriptive analytics by performing advanced analytics directly within the database. Combine in-memory columnstore and rowstore capabilities in SQL Server for real-time operational analytics — fast analytical processing right on your transactional data.

Open up new scenarios like real-time fraud detection without impacting your transactional performance. Now on Windows, Linux and Docker. Develop once and deploy anywhere with our consistent experience from on-premises to cloud. Now with support for Windows and Linux as well as Docker containers. Get a consistent experience from on-premises to the cloud — letting you build and deploy hybrid solutions for managing your data investments.

Apply industry-standard APIs across various platforms and download updated developer tools from Visual Studio to build next-generation web, enterprise, business intelligence and mobile applications. Access mission-critical capabilities to achieve unparalleled scale, security, high availability and leading performance for your Tier 1 database, business intelligence and advanced analytics workloads. Find rich programming capabilities, security innovations and fast performance for mid-tier applications and data marts.

Easily upgrade to the Enterprise edition without having to change any code. Build small, data-driven web and mobile applications up to 10 GB in size with this entry-level database. Available for free. Build, test and demonstrate applications in a non-production environment with this full-featured edition of SQL Server View the comprehensive feature comparison of SQL Server editions for feature details and limitations.

Basic high availability: two-node single database failover, non-readable secondary. Advanced high availability: Always On Availability Groups, multi-database failover, readable secondaries. Data marts and data warehousing: partitioning, data compression, change data capture, database snapshot. Basic corporate business intelligence: basic multi-dimensional models, basic tabular model, in-memory storage mode [5]. Advanced corporate business intelligence: advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining [5].

Basic Machine Learning integration: connectivity to open source Python and R, limited parallelism [5]. Use a secured, cost-effective, highly scalable data platform for public websites — available to third-party hosting service providers only. SQL Server licensing makes choosing the right edition simple and economical. Pay by processing power for mission-critical applications as well as business intelligence.

Add self-service BI on a per user basis. Cloud-optimised licensing with the ability to license virtual machines, and the flexibility to move from server to server, to hosters, or to the cloud, on the operating system of your choice. Get outstanding value at any scale compared to all major vendors.

The Enterprise edition offers all product features and capabilities with no costly add-ons required to run your most demanding applications. For sales questions, contact a Microsoft representative on in the United States or in Canada.

Comprehensive, mission-critical performance for demanding database and business intelligence requirements. Provides the highest service and performance levels for Tier-1 workloads. Core data management and business intelligence capabilities for non-critical workloads with minimal IT resources. Full-featured version of SQL Server software that allows developers to cost-effectively build, test and demonstrate applications based on SQL Server software.

Free download. Secure, cost effective and highly scalable data platform for public websites. Available to third-party software service providers only. Parallel data warehouse is part of the Microsoft Analytics Platform System. For your specific pricing, contact your Microsoft reseller. See the product use rights for details.

SQL Server Standard edition is available to buy online. Easily upgrade to Enterprise edition for comprehensive high-end datacentre capabilities. Get started with SQL Server Plan a SQL Server installation. Install SQL Server Gain expertise with SQL Server training and certification.

Explore SQL Server virtual labs. Quickly get started with code samples on GitHub. Visit the SQL Server migration forums. Learn more about SQL Server end of support. Download the Microsoft Assessment and Planning Toolkit. Read the SQL Server upgrade technical guide. Download the Data Migration Assistant. Contact Microsoft support. SQL Server documentation library. Ask a question in the SQL Server forums. SQL Server on Twitter. SQL Server on Facebook.

Try now Watch now. Your choice of language and platforms Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers.

Industry-leading performance Take advantage of breakthrough scalability, performance and availability for mission-critical, intelligent applications and data warehouses. Least vulnerable database Protect data at rest and in motion with the least vulnerable database over the last seven years in the NIST vulnerabilities database. Get the essential guide to data in the cloud.

Featured SQL Server resources. Get the kit. SQL Server technical eBooks Get the technical resources, documentation and code samples you need to support all areas of your data estate — from discovery and research to implementation and maintenance. Get the eBooks. Cloud Database Migration Simplified eBook Help your organisation improve cost-efficiency, agility and scalability by migrating to the cloud.

Download the eBook.

 

Microsoft Exchange Server – Wikipedia.Client Access Licenses (CAL) & Management Licenses | Microsoft Volume Licensing

 

How to buy SQL Server. Connect with a Microsoft solution provider Whether you’re evaluating business needs or ready to buy, a Microsoft certified solution provider will guide you every step of the way.

Search solution providers. Contact your Microsoft account representative Call your account manager or contact your regional Microsoft office for further details.

Buy now. Follow us. Share this page. Licensing model. Channel availability. Volume licensing, hosting. Standard – per core. Standard – server. Standard – CAL. Pacific Time to directly speak to a Microsoft licensing specialist.

Or you could get help from Volume Licensing Service Center support. If the answer is helpful, please click ” Accept Answer ” and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. File for a cloned Vertipaq data object conflicts with a master data object file.

Skip to main content. Find threads, tags, and users The editions are offered in a straightforward, tiered model that creates greater consistency across the product editions, features and licensing. Through a consistent programming interface across all editions, it is easier than ever for developers and partners to build and upgrade applications that take advantage of advanced performance, security, and data mart or data warehouse features — regardless of scale, from Express to Enterprise.

SQL Server is offered in two main editions to accommodate the unique feature, performance and price requirements of organizations and individuals:.

SQL Big Data Nodes are licenses assigned to worker nodes in big data environments, and are licensed under Enterprise Edition use rights.

Big Data Clusters make it easier for customers to manage a big data environment. SQL Server also brings expanded fail-over rights to Software Assurance customers supporting disaster recovery and high availability.

For details refer to the Product Terms site. There are two main editions: Enterprise and Standard. Enterprise and Standard are the two main editions. Developer and Express editions continue to be distributed without changes in licensing or pricing. SQL Server provides a variety of virtualization and cloud benefits that help you save money on database licensing and retain flexibility in your database deployments.

View all page feedback. Additional resources In this article. Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files. Read-only, mapped, or compressed drives are blocked during installation.

Minimum: x64 Processor: 1. SQL Server NET Framework 4. SQL Server setup automatically installs. NET Framework. You can also manually install. NET Framework from Microsoft. For more information, recommendations, and guidance about. Windows 8. Note: Support for.

 
 

SQL Server license/CAL – Microsoft Q&A

 
 

SQL Server licensing can be one of the more complicated topics to wrap your head around. How can you determine your business’s needs when you don’t understand the subject matter? Rest assured, ServerMania has deep knowledge in this area and this article will walk you through everything you need to know about SQL Server Licensing.

A variety of Microsoft products are used when deploying a server and their SQL Server products have proven incredibly popular as database server software. This article will outline what SQL Server is, what versions are available, and how each are licensed. First developed in with SQL Server 1.

It is typically leveraged by medium and large-sized enterprises to power any of their database storage and analysis requirements. The primary role of an SQL server is to store and retrieve data when requested by other software applications. Part of the complexity of this database software is the sheer number of other software applications it must communicate with.

There are usually two types of organizations that require Microsoft SQL Server, one with a limited number of users, such as a private network. For this type of customer, they offer a separate license for each device that accesses the network, usually, when there is a limited number of users. For businesses with a near-unlimited number of users such as a large organization that provides access to the public, Microsoft offers SQL Server licenses by the server and works as a catch-all license for all users as opposed to by the device.

This is referred to as the core licensing model. An SQL server can be used for a variety of functions and come in all kinds of sizes depending on the workload and function.

An SQL server also processes different kinds of data including data warehousing, big data clusters, financial data, and performs data analysis. Core-based licensing is the licensing model used by Microsoft and allows license for any device accessing the SQL Server. Under this license, each server that hosts SQL Server software on a physical server or operating system environment OSE will be granted a license for each core in the processor. An example of this could be a credit card company operating a server farm that must process thousands of transactions each minute.

Each time a device such as a point of purchase system requires access, they will have client access licenses that allow them to access the information on the server. SQL software licensing must be included with the purchase of a server and is a separate fee. As part of the services provider license agreement, you will need at least four core licenses for each physical processor on the server core licenses are sold in packs of two , as well as having all of the components within the server appropriately licensed.

You cannot use the license by spreading it out across components in multiple servers. For example, if you try to run the SQL server reporting services on another machine, you will violate the license agreement. With this, you will have a license assigned to the operating system, the physical server, the physical cores as well as an individual license for anyone accessing the server.

In November of Microsoft updated its Software Assurance benefits and now includes additional licensing in case of a failover event. Now Microsoft has strengthened the benefit, particularly when it comes to disaster recovery. A “failover event”, in general terms is when your server switches from one machine to another and is usually triggered by a loss of power, disk failure, cable error, memory exhaustion, or a virus attack.

In technical terms, it is when the secondary node does not receive a heartbeat packet from the primary node for a period of time that exceeds the dead interval set on the secondary. High Availability is a feature of a server system, which aims to ensure an agreed level of operational performance, usually uptime and often measured in SLA Service Level Agreement.

Microsoft offers a virtual buffet of SQL Servers that are available in multiple editions. Each edition carries differing features and targets different users. There are two primary editions, Mainstream and Specialized.

Aside from discontinued versions, each edition has a different version, they are:. Express and Developer are both free versions designed for very limited personal use, or for development testing. It is important to note that licenses are generally purchased with the purchase of a server.

There are two licensing models for SQL Server. It can either be licensed per server with a license required for every device that connects to the database server, or it can be licensed per core of the database server, with a minimum 4-core license required. Because of the complexity involved in understanding your licensing requirements, we strongly recommend that you speak with one of our trusted SQL licensing experts who will provide you with peace of mind by understanding exactly what you require.

ServerMania does not sell stand-alone SQL Server licenses, they are purchased in addition to the sale of a server. Contact us today to request your no-obligation expert server consultation and we’ll provide you with the right database hosting solution at the best value. If you are already a ServerMania customer, then you qualify for a stand-alone license for your server, should you require one.

Rob Rapiti. A single tenant, physical server allowing you full access to its resources. High-performance and highly-available infrastructure, delivering a reliable, secure, and scalable solution. Thanks for your comment! What is the price of ms sql express edition where space is unlimited. In free version the space is 10gb which is insufficient for me.

Kindly help for the same. Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page. Search for: Search. With this, you will have a license assigned to the operating system, the physical server, the physical cores as well as an individual license for anyone accessing the server Software Assurances, High Availability and Disaster Recovery A benefit of SQL Server licensing is Microsoft’s Software Assurance for high availability.

The following versions of SQL Server are available:. End of Mainstream Support. End of Extended Support. SQL Server Each pack comes with two core licenses, licenses must be purchased separately from the server. Product Name. Microsoft SQL Web – per 2 cores.

Microsoft SQL Standard – per 2 cores. Microsoft SQL Enterprise – per 2 cores. Windows Server Remote Desktop – per 2 cores. Order Your SQL Server Today Because of the complexity involved in understanding your licensing requirements, we strongly recommend that you speak with one of our trusted SQL licensing experts who will provide you with peace of mind by understanding exactly what you require. Rob is the Content Marketing Manager at Servermania. His goal is to help break down the often complex and technical aspects of IT into relatable, easy-to-understand information.

Browse Servers. Is it one time cost or annual? Close dialog. Session expired Please log in again.