Nov 21, 2014 Hi All, I tried to buy and download the Microsoft SQL Server 2014 Developer Edition for studying purposes, but it turned out that this specialized edition is not available in my region - Middle East. The Express edition is available free of charge for all regions, but it lacks the more advanced. Hi, You have to contact your local Microsoft agents. Developer Edition is free. As of March 31, 2016 Microsoft SQL Server Developer Edition is now free for SQL Server 2014 and up for Visual Studio Dev essential members (which is free as well). For all editions, see How to buy SQL Server. If you want to explore SQL Server, you can download SQL Server Evaluation Edition for 180 days, and then. Jul 12, 2016 Microsoft SQL Server 2014 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2014 to SP2. This service pack contains up to and including SQL Server 2014 SP1 Cumulative Update 7 (CU7).
-->
This topic provides details of features supported by the different editions of SQL Server 2014.
NOTE: SQL Server is available in an Evaluation edition for a 180-day trial period. For more information, see the SQL Server Trial Software Web Site.
NOTE: For features supported by Evaluation and Developer editions see the SQL Server Enterprise feature set.
To navigate to the table for a SQL Server technology, click on its link:
Cross-Box Scale Limits
1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, see Compute Capacity Limits by Edition of SQL Server.
High Availability
1For more information on installing SQL Server 2014 on Server Core, see Install SQL Server 2014 on Server Core.
2This feature is only available for 64-bit SQL Server.
Scalability and Performance
1 This feature is only available for 64-bit SQL Server.
Security
Replication
Management Tools
2 SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.
3 Tuning enabled only on Standard edition features.
RDBMS Manageability
1 For more information, see Considerations for Installing SQL Server Using SysPrep.
2 This feature is only available for 64-bit SQL Server.
Development Tools
1 This feature is not available for 64-bit version of Standard edition.
Programmability
Integration Services
Integration Services - Advanced Adapters
Integration Services - Advanced Transforms
Master Data Services
Note
Data Warehouse
Analysis Services
BI Semantic Model (Multidimensional)
1The LastChild semi-additive measure is supported in standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.
BI Semantic Model (Tabular)
PowerPivot for SharePoint
Data Mining
Reporting ServicesReporting Services Features
1For more information on the supported datasources in SQL Server 2014 Reporting Services (SSRS), see Data Sources Supported by Reporting Services (SSRS).
2Requires Reporting Services in SharePoint mode. For more information, see Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013).
Report Server Database Server Edition Requirements
When creating a report server database, not all editions of SQL Server can be used to host the database. The following table shows you which editions of the Database Engine you can use for specific editions of Reporting Services.
Business Intelligence Clients
The following software client applications are available on the Microsoft Downloads center and are provided to assist you with creating business intelligence documents that run on a SQL Server instance. When you host these documents in a server environment, use an edition of SQL Server that is supported for that document type. The following table identifies which SQL Server edition contains the server features required to host the documents created in these client applications.
Note
Spatial and Location Services
Additional Database Services
Other Components
See Also
Product Specifications for SQL Server 2014 -->
Installation for SQL Server 2014 Quick-Start Installation of SQL Server 2014
APPLIES TO: SQL Server (Windows only) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
The article lists the minimum hardware and software requirements to install and run SQL Server on the Windows operating system.
SQL Server 2017 (14.x) introduced support for SQL Server on Linux. For information, see Hardware and Software Requirements for SQL Server on Linux.
Try it out:
The following considerations apply to all editions:
Hardware and Software Requirements
The following requirements apply to all installations:
![]() Sql 2014 Management Studio Download
Note
Running SQL Server on a virtual machine will be slower than running natively because of the overhead of virtualization.
Important
There are additional hardware and software requirements for the PolyBase feature. For more information, see Get started with PolyBase.
Processor, Memory, and Operating System Requirements
The following memory and processor requirements apply to all editions of SQL Server:
Ms Sql 2014 Developer Edition Download
Note
Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.
* The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement. For information about installing DQS, see Install Data Quality Services.
WOW64 Support:
WOW64 (Windows 32-bit on Windows 64-bit) is a feature of 64-bit editions of Windows that enables 32-bit applications to run natively in 32-bit mode. Applications function in 32-bit mode, even though the underlying operating system is a 64-bit operating system. WOW64 is not supported for SQL Server installations. However, Management Tools are supported in WOW64.
Server Core Support:
Installing SQL Server 2019 on Server Core mode is supported by the following editions of Windows Server:
Installing SQL Server 2016 and 2017 on Server Core mode is supported by the following editions of Windows Server:
For more information on installing SQL Server on Server Core, see Install SQL Server on Server Core.
Features Supported on 32-bit Client Operating Systems
Windows client operating systems, for example Windows 10 and Windows 8.1 are available as 32-bit or 64-bit architectures. All SQL Server features are supported on 64-bit client operating systems. On supported 32-bit client operating systems Microsoft supports the following features:
Windows Server 2008 R2 and later server operating systems are not available as 32-bit architectures. All supported server operating systems are only available as 64-bit. All features are supported on 64-bit server operating systems.
OS Compatibility
The following table shows which editions of SQL Server 2019 are compatible with which versions of Windows:
The following table shows which editions of SQL Server 2016 and 2017 are compatible with which versions of Windows:
Note
Exceptions to the operating system support noted in this section are the following Business Intelligence features for SQL Server 2016 (13.x) and earlier, which can be installed on Windows Server 2008 R2 SP1 or later:
Cross-Language Support
For more information about cross-language support and considerations for installing SQL Server in localized languages, see Local Language Versions in SQL Server.
Hard Disk Space Requirements
During installation of SQL Server, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.
Actual hard disk space requirements depend on your system configuration and the features that you decide to install. The following table provides disk space requirements for SQL Server components.
*The disk space requirement for downloaded Books Online content is 200 MB.
Storage Types for Data Files
The supported storage types for data files are:
Installing SQL Server on a Domain Controller
For security reasons, we recommend that you do not install SQL Server on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:
See Also
Planning a SQL Server Installation
Security Considerations for a SQL Server Installation Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |