Cumulative Update 6 for SQL Server 2014 SP2

Applies to: SQL Server 2014 StandardSQL Server 2014 DeveloperSQL Server 2014 Enterprise Core More

Cumulative Update 6 (CU6) for Microsoft SQL Server 2014 Service Pack 2 (SP2) was also released as a SQL Server Security Bulletin on 8/8/2017 (KB 4036996). See CVE-2017-8516 for more information. Because of this, you may already have CU6 installed as part of that security bulletin release, and installation of this CU is unnecessary. If you do try to install CU6 after CVE-2017-8516, you may receive the following message:

There are no SQL Server instances or shared features that can be updated on this computer


This indicates that CU6 is already installed and no further action is required.

Note The package name for CU6, "SQLServer2014SP2-KB4019094-<x86/x64>.exe", contains the CVE-2017-8516 KB number (4036996), not the CU6 KB number (4019094). This can be ignored as a single package services both release channels.

This article describes cumulative update package 6 (build number: 12.0.5553.0) for SQL Server 2014 SP2. This update contains fixes that were released after the release of SQL Server 2014 SP2.

Cumulative update

Cumulative updates (CU) are now available at the Microsoft Download Center.

Only the most recent CU that was released for SQL Server 2014 SP2 is available at the Download Center.
 
  • Each new CU contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • Microsoft recommends ongoing, proactive installation of CUs as they become available:
     
    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.
  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2014 service pack.

How to obtain this cumulative update package


The following update is available from the Microsoft Download Center:


If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note After future cumulative updates are released for SQL Server 2016, this CU can be located and downloaded from the Microsoft Windows Update Catalog. However, Microsoft recommends that you install the latest cumulative update available.

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
10029673 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Reporting Services
10015186 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed SQL service
9876152 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Analysis Services
9882155 4018930 Update adds the "CLR strict security" feature to SQL Server 2016 SQL service
10029654 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server Always-On Availability Groups High Availability
10033527 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server SQL service
9994693 4019285 FIX: Error when you execute DBCC CLONEDATABASE on an "Always Encrypted" enabled database in SQL Server 2014 or 2016 SQL service
10088753 4022935 FIX: Fails to resume a suspended availability database after a write error in SQL Server 2014 High Availability
10162137 4023926 FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server 2014 SQL service
9848021 4023679 FIX: Timeout error when you backup a large database to URL in SQL Server 2014 SQL service
10190672 4024184 FIX: Access violation occurs when you execute a query to retrieve data from a clustered columnstore index in SQL Server 2014 SQL service
9845314 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Reporting Services
10029686 4019048 FIX: SSAS crashes when you retrieve KPIs as hidden members by using schema rowsets in SQL Server Analysis Services
9840513 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Management Tools
9923473 3213683 FIX: Unable to rebuild the partition online for a table that contains a computed partitioning column in SQL Server 2014 or 2016 SQL performance
10029682 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server 2012 or 2014 High Availability
9847676 4021469 FIX: An assertion occurs when you run a query that performs join operations by using MERGE JOIN in SQL Server 2014 SQL performance
10048664 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 Integration Services
9813870 4013208 FIX: "Partition cannot contain column segments of different data versions" error when you process data on a partition in SSAS Tabular model Analysis Services
9875456 4022753 FIX: SSAS 2014 crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy Analysis Services
9876069 4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server SQL service
9983862 4021580 Fix: System generated stored procedures are created incorrectly in P2P publication if the schema name of published table contains a period (.) in SQL Server 2014 SQL service
10029667 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column XML
10039462 4022895 FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server 2014 is also installed Data Quality Services (DQS)
10099539 4022873 FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 in Windows 10 Creators Update SQL service
10097899 4023419 FIX: Query with UNION ALL and a row goal may run slower in SQL Server 2014 or later versions when it's compared to SQL Server 2008 R2 SQL performance
9783554 3108537 FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server SQL service
10158085 4024311 FIX: "Non-yielding Scheduler" condition occurs on spinlock contention in Microsoft SQL Server 2014 SQL service
9918468 4024563 FIX: An unhandled exception occurs when you export a SSRS report to a .pdf file if the page height is set to 8.5 inches in SQL Server 2014 Reporting Services
10087562 4022780 FIX: Checkpoint and backup operations fail with error 2601 when Change Tracking is enabled for a database in SQL Server 2014 SQL service

Notes for this update


Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the hotfixes:
 

Cumulative update package information


Prerequisites

To apply this cumulative update package, you must be running SQL Server 2014 SP2.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.