Cumulative Update 4 for SQL Server 2016 SP1

Applies to: Microsoft SQL Server 2016 Service Pack 1SQL Server 2016 Enterprise CoreSQL Server 2016 Developer More

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

Note The package name for CU4, "SQLServer2016SP1-KB4024305-<x86/x64>.exe", contains the CVE-2017-8516 KB number (4019095), not the CU4 KB number, (4024305). This can be ignored as a single package services both release channels.
This article describes cumulative update package 4 (build number: 13.0.4446.0) for Microsoft SQL Server 2016 Service Pack 1 (SP1) . This update contains fixes that were released after the release of SQL Server 2016 SP1.

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 SP1 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.

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
10052301 4021994 FIX: SSAS crashes when a measure is added that refers to null values in Power BI Analysis Services
10048666 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 SQL Service
10167609 4023995 FIX: Data mask on a floating points column is removed unexpectedly in SQL Server 2016 SQL security
10049124 4013585 FIX: SQL Server Analysis Service proactive caching processes a partition but doesn't run an SQL query, causing stale data Analysis Services
10067693 4016946 FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016 SQL service
10195260 3212541 FIX: SSAS crashes when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase Analysis Services
10200392 4024392 FIX: "Non-yielding Scheduler" condition occurs when you change the BUCKET_COUNT value for large memory-optimized tables in Microsoft SQL Server 2016 In-Memory OLTP
10162127 4024548 FIX: It takes a long time to perform Process Update operations on SSAS databases in SQL Server 2016 Analysis Services
10143390 4024840 FIX: An access violation occurs when you update a partitioned table that contains PERSISTED computed columns in SQL Server 2016 SQL performance
9919215 4025020 FIX: SUSER_SNAME function returns different result between SQL Server 2014 and SQL Server 2016 SQL security
9876036 4018908 FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) Analysis Services
10087679 4023865 FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server 2016 MDS Data Quality Services (DQS)
10029657 4017080 FIX: Transaction log backup failure on the secondary replica in SQL Server Always-On Availability Groups High Availability
10033530 4021405 FIX: An access violation occurs when you create an index with page compression in SQL Server SQL service
10018554 4022435 FIX: Parallel query execution returns incorrect results for merge join operations in SQL Server 2016 SQL performance
10242542 4024184 FIX: Access violation with query to retrieve data from a clustered columnstore index in SQL Server 2014 or 2016 SQL service
10099394 4022873 FIX: "FILESTREAM feature is disabled" error when you use the FILESTREAM feature for SQL Server 2014 or 2016 in Windows 10 Creators Update SQL service
9983975 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
10205059 4024622 FIX: Couldn't truncate a partition of the partitioned table if it contains an extended or XML index in SQL Server 2016 SQL service
10029684 4018227 FIX: A stored procedure may fail after an automatic failover occurs on a mirrored database in SQL Server High Availability
9953962 4019978 FIX: "Error occurred during rendering" when you export a report as a PowerPoint presentation in SQL Server 2016 Reporting Services Reporting Services
10017583 4022594 FIX: MDX query returns incorrect results if the table has a table attribute cross-join with the same attribute in a table hierarchy in SSAS 2016 Analysis Services
10049113 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
9879793 4024715 FIX: SharePoint sites that contain the Report Viewer Web Part fail to load after you upgrade from SharePoint 2013 to 2016 in SSRS 2016 Reporting Services
9313605 4024868 FIX: Assertion failure when backing up large TDE encrypted database in SQL Server SQL service
10375276 4034056 FIX: Access violation occurs when you execute a query in SQL Server 2016 SQL service
10048666 4016804 FIX: Deadlocks occur in SSISDB when you run multiple SSIS packages in SQL Server 2014 or 2016 Integration Services
9874233 4013106 Cumulative Update 2 for SQL Server 2016 SP1 Reporting Services
10106167 4024023 FIX: SSAS crashes when you access .vmp files in SQL Server 2016 Analysis Services
10067711 4019446 FIX: SQL Server 2016 stops responding when the "Latch_Suspend_End" extended event is incorrectly triggered SQL performance
10162582 4024393 FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 SQL service
10018470 4024449 FIX: Databases on secondary replica shows "NOT SYNCHRONIZING" status after failover in SQL Server 2016 High Availability
10049128 4019603 FIX: SSAS crashes when an MDX query that refers to parent-child dimensions runs in SQL Server 2014 or 2016 Analysis Services
10185322 4025021 FIX: Blank spaces in the parameter area when you open SSRS report that contains Hidden or Internal parameters in SQL Server 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
10331381 4032543 FIX: SSAS crashes when you run a DAX or MDX query in SSAS 2016 in Tabular mode Analysis Services
10273869 4024989 FIX: "EXCEPTION_INVALID_CRT_PARAMETER" error with BULK INSERT statement in SQL Server 2016 SQL service
10029671 4019125 FIX: System Center Configuration Manager replication process by using BCP APIs fails when there is a large value in an XML column XML
10107258 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
10280055 4025208 FIX: Memory leak occurs when you use memory-optimized tables in Microsoft SQL Server 2016 Standard edition In-Memory OLTP
10049134 4017023 FIX: SQL Server 2014 or 2016 Backup to Microsoft Azure Blob storage service URL isn't compatible for TLS 1.2 SQL service
10022111 4033178 FIX: Cast error when you open a local mode report in SharePoint Integrated mode in SSRS 2016 Reporting Services
9882162 4018930 Update adds the "CLR strict security" feature to SQL Server 2016 SQL service
10193902 4032686 FIX: Search result isn't highlighted in SSRS 2016 report in SharePoint Integrated Mode Reporting Services
10352073 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
10296144 4025402 FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2016 Analysis Services
10015190 4038210 FIX: Change Data Capture stops working after a recent cumulative update for SQL Server is installed SQL Service
10099394 4022874 FIX: The FILESTREAM feature in SQL Server is disabled after you install Windows 10 Creators Update SQL service
10268790 4019893 FIX: Restore fails when you do backup by using compression and checksum on a TDE enabled database in SQL Server 2016 SQL service
9704947 4039284 Enhancement: New keyword added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server 2016 SQL service
10867554 4043459 FIX: Remote instance of SQL Server crashes while executing a stored procedure that bulk loads an incomplete data file into a temporary table Analysis Services

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 SP1.

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.