Select Page

SQL Server 2014 Version Numbers

This page last updated May 16, 2017.

SQL Server 2014 Versions:

  • RTM (Release to Manufacturing) SQL Server 2014 – April 21, 2014 version 12.0.2342
  • SP1 (Service Pack 1) – May 15, 2015, Version 12.0.4100
    • SP1 – CU8 (Cumulative update 8) – Aug 16, 2016, Version 12.0.4468
  • SP2 (Service Pack 2) – July 11, 2016, version 12.0.5000
    • SP2 – CU1 (Cumulative Update 1) – August 26, 2016, Version 12.0.5511
    • SP2 – CU2 (Cumulative Update 2) – October 18, 2016, Version 12.0.5522
    • SP2 – CU3 (Cumulative Update 3) – December 27, 2016, Version 12.0.5538
    • SP2 – CU4 (Cumulative Update 4) – February 21, 2017, Version 12.0.5540
    • SP2 – CU5 (Cumulative Update 5) – April 17, 2017, Version 12.0.5546 (Download)

To get to the latest version you will want to install SP2 followed by SP2 – CU5.

Downloads

A quick way to check your version number is to just connect to the database in SSMS and the version number will be shown in the object explorer. All SQL Server 2014 versions start with 12.

SQL Server 2014 Version Numbers

 

You can also view this easily in Database Health Monitor from the Performance Dashboard.

SQL Server 2014 Version Numbers

Some new features introduced in SQL Server 2014

  • AlwaysOn Enhancements.
  • Buffer Pool Extension.
  • Updateable Columnstore Indexes.
  • Power View for Multidimensional Models.
  • Power BI for Office 365 Integration.
  • Storage I/O control.
  • SQL Server Data Tools for Business Intelligence.

SQL Server Updates list

Other Related Links