Cumulative Update 7 for SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Cumulative Update 7 (CU7) for Microsoft SQL Server 2016 was also released as a SQL Server Security Bulletin on 8/8/2017, KB4019086. See CVE-2017-8516 for more information. Because of this, you may already have CU7 installed as part of that security bulletin release and installation of this CU is unnecessary. If you do try to install CU7 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 CU7 is already installed and no further action is required.

Note The package name for CU7, "SQLServer2016-KB4024304-<x86/x64>.exe", contains the CVE-2017-8516 KB number (4019086), not the CU7 KB number, (4024304). This can be ignored as a single package services both release channels.
This article describes cumulative update package 7 (build number: 13.0.2210.0) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

Cumulative update

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

Only the most recent CU that was released for SQL Server 2016 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 2016 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.

Hotfixes that are included in this cumulative update package


 
VSTS bug number KB article number Description Fix area
10029683 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server High Availability
10015189 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed SQL service
10163598 4023995 FIX: Data mask on a floating points column is removed unexpectedly in SQL Server 2016 SQL security
10049123 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Analysis Services
10049112 4011477 FIX: DMF sys.dm_db_incremental_stats_properties doesn't show all partitions if partitioning column is set to character or binary data type SQL performance
10049133 4017023 FIX: SQL Server 2014 or 2016 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2 SQL service
10297645 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2016 Analysis Services
10420071 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature of SQL Server 2016 SQL service
10049114 4014862 FIX: Intermittent failure with System.NullReferenceException when you use custom authentication in SSRS 2014 or 2016 Reporting Services
9995483 4023138 FIX: Incorrect syntax error when you add a subscription by using the "sp_addpullsubscription_agent" stored procedure in SQL Server SQL service
10029656 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server Always-On Availability Groups High Availability
10018568 4022435 FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016 SQL performance
9983973 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 or 2016 SQL service
10029670 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column XML
10029674 4019983 FIX: "Index was out of range" error when exporting to PDF in a SQL Server Reporting Services report Reporting Services
10029664 4015561 FIX: Access violation when a stored procedure is dropped before you execute END TRY section in SQL Server SQL service
10087725 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server 2016 MDS Data Quality Services (DQS)
10242547 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 SQL service
10107255 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
10029679 4017827 FIX: Reporting Services "SortExpression" cause rsComparisonError when there is a NULL value in a column set as "DataTimeOffset" Reporting Services
10375302 4034056 FIX: Access violation occurs when you execute a query in SQL Server 2016 SQL service
10049121 3210089 GDR update package for SQL Server 2016 SP1 Reporting Services
10048665 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Integration Services
10018516 4024449 FIX: Databases on secondary replica shows "NOT SYNCHRONIZING" status after failover in SQL Server 2016 High Availability
10049127 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Analysis Services
10015189 4018930 Update adds the "CLR strict security" feature to SQL Server 2016 SQL Service
10268792 4025628 FIX: Error 9004 when you try to restore a compressed backup from multiple files for a large TDE-encrypted database in SQL Server SQL service
10351981 4032200 FIX: Fail to compress the backup file when INIT and COMPRESSION option is used in a TDE enabled database in SQL Server 2016 SQL service
10273870 4024989 FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error when you execute a BULK INSERT statement in SQL Server SQL service
10351966 4019893 FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016 SQL service
9876047 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) 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 2016.

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.