Service Packs and Updates

Upgrades and Service Packs

Source: //www.digipas.com/files/photos-firmware/software-btn1.png

One of the things that I always check on client servers is that they are running the latest service packs, for both SQL Server and for the Windows OS itself. Now, sometimes I know what the latest service pack is – but other times I don’t. Therefore, I end up spending more time than I would like looking up the latest service pack. Therefore, I’m making a list of service packs here, along with download links (as I find them – navigating Microsoft’s Download Center isn’t exactly a piece of cake). I tried to get the download links for both 32-bit and 64-bit architectures, where applicable. Hopefully, you can use this chart also.

If you have a link to any that I have missed, please leave me a comment so that I can update this! I’d appreciate your help.



Windows Update Rollups

Windows Version(s) Date Update Prerequisites
10,2016 2017-11-02 OS Build 14393.1797 none
8.1, 2012R2 2017-10-17 October 2017 Monthly Rollup April 2014 Update Rollup
Service Stack Update
8 2017-10-17 October 2017 Monthly Rollup none
2012 2017-10-17 October 2017 Monthly Rollup none
7, 2008R2 2017-10-17 October 2017 Monthly Rollup SP1
Servicing Stack Update

Monthly Rollups are not cumulative. Update rollups explained.

Reference: Windows 10 and Windows Server 2016 Update History
Reference: Windows 8.1 and Windows Server 2012R2 Update History
Reference: Windows Server 2012 Update History
Reference: Windows 7 SP1 & Windows Server 2008R2 Update History
Reference: Current Windows Server 2012/R2 & Windows 8 / 8.1 Update Rollups
Back to Contents

Windows Server Versions

Operating System RTM SP1 SP2 SP3 SP4
Windows 2016 10.0.14393
Windows 2012 R2 6.3.9200
Windows 2012 6.2.9200
Windows 2008 R2 6.1.7600.16385 6.1.7601
Windows 2008 6.0.6000 6.0.6001
32-bit, 64-bit
6.0.6002
32-bit, 64-bit
Windows 2003 R2 5.2.3790.1180 5.2.3790.?
32-bit, 64-bit
Windows 2003 5.2.3790 5.2.3790.1180
32-bit, 64-bit
5.2.3790.?
32-bit, 64-bit
Windows 2000 5.00.2195 32-bit

Back to Contents

Windows (non-server) Versions

Operating System RTM SP1 SP2 SP3 SP4
Windows 10 10.0.10240
Windows 8.1 6.3.9200 6.3.9600
32-bit, 64-bit
Windows 8 6.2.9200
Windows 7 6.1.7600 6.1.7601
Windows Vista 6.0.6000 6.0.6001
32-bit, 64-bit
6.0.6002
32-bit, 64-bit
Windows XP x64 5.2.2600 5.2.2600.1105 5.2.2600.2180
Windows XP 5.1.2600 5.1.2600.1105 5.1.2600.2180 5.1.2600.5512
Windows 2000 5.00.2195 32-bit

Back to Contents

SQL Server Versions

Version RTM SP1 SP2 SP3 SP4
SQL Server 2017
Latest CU
EOMS: 2022-10-11
14.0.1000.169
CU9
14.0.3030.27
Service Packs will not be released, only CUs.
See Modern Service Model for SQL Server.
Latest Windows CU, Latest Linux CU
SQL Server 2016
Latest CU
EOMS: 2021-07-13
13.0.1601.5
CU8
13.0.2216.0
13.0.4001.0
CU10
13.0.4514.0
13.0.5026.0
CU2
13.0.5153.0
SQL Server 2014
Latest CU
EOMS: 2019-07-09
12.0.2000.8
CU14
12.00.2569
12.0.4100.1
CU13
12.00.4522
12.0.5000.0
CU12
12.0.5589.7
SQL Server 2012
EOMS: 2017-07-11
11.0.2100.60
CU11
11.00.2424
11.0.3000.0
CU16
11.00.3492
11.0.5058.0
CU16
11.00.5678
Latest CU
11.0.6020.0
CU10
11.0.6607.3
Latest CU
11.0.7001.0
CUs not planned
SQL Server 2008 R2
EOMS: 2014-07-08
10.50.1600.1
CU14
10.50.1817
10.50.2500.0
CU13
10.50.2876
10.50.4000.0
CU13
10.50.4319
10.50.6000.34
CUs not planned
SQL Server 2008
EOMS: 2014-07-08
10.0.1600.22
CU10
10.00.1835
10.0.2531.0
CU16
10.00.2850
10.0.4000.0
CU11
10.00.4333
10.0.5500.0
CU17
10.00.5861
10.0.6000.29
CUs not planned
SQL Server 2005
EOMS: 2011-04-12
9.0.1399.06 9.0.2047 9.0.3042
CU17
9.00.3356
9.0.4035
CU15
9.00.4325
9.0.5000
CU3
9.00.5266
SQL Server 2000
EOMS: 2008-04-08
8.0.194 8.0.384 8.0.532 8.0.760 8.0.2039
SQL Server 7
EOMS: 2005-12-31
7.0.623 7.0.699 7.0.842 7.0.961 7.0.1063

EOMS is “End of Mainstream Support”.
Reference: Update Center for Microsoft SQL Server
Reference: SQL Server Release Services Blog
Reference: SQL Server Lifecycle
Back to Contents

SQL Server Tools

Tool Latest Download
SQL Server Data Tools (SSDT) Latest SSDT Release
SQL Server Migration Assistant (SSMA) Latest SSMA Release
SQL Server Management Studio (SSMS) Latest SSMS Release
Keberos Configuration Manager for SQL Server Latest Release
SQL Operations Studio (SOS) Latest SOS Release
mssql-cli (SQL Server command line client) Latest Release
SQL Setup Tools Latest Release

Reference: SQL Server Release Services Blog
Back to Contents

Microsoft System Center Management Packs for SQL Server

Item 2008/R2 2012 2014 2016 2017+
Database Engine (7.0.7.0) Link Link Link Link
Replication (6.7.31.0) Link Link Link Link Link
7.0.0.0
Analysis Server (7.0.7.0) Link Link Link Link
Reporting Services (7.0.7.0)
(Native Mode)
Link Link Link Link
Dashboards (7.0.7.0) Link
Azure SQL Database (7.0.4.0) Link

Reference: SQL Server Release Services Blog
Back to Contents

SQL Server sample databases


Back to Contents