KB3164674 - Cumulative Update 1 for SQL Server 2016

Release Date:   July 25, 2016
Version:   13.0.2149.0

This article describes cumulative update package 1 (build number: 13.0.2149.0) for Microsoft SQL Server 2016. This update contains fixes that were released after the release of SQL Server 2016.

Improvements and fixes included in this update

Bug reference Description Fix area
7693722 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS (KB3025408) Analysis Services
7694337 FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition (KB3160874) Analysis Services
7699226 Analysis Services may crash if the HeapTypeForObjects memory property is configured by a slot allocator in SQL Server 2016 (KB3167113) Analysis Services
7709923 FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode) (KB3168242) Analysis Services
7723472 FIX: Error message isn't localized completely when you use Tabular Model Scripting Language (TMSL) in SQL Server 2016 (KB3171932) Analysis Services
7771531 FIX: Unexpected exception when you make cross-appdomain TOM call in SQL Server 2016 (KB3173781) Analysis Services
7779859 Can't capture the CommandBegin and CommandEnd events in a JSON-based statement script in SQL Server 2016 (KB3171574) Analysis Services
7806774 An unexpected error occurs when you execute a DAX query that contains variables in SQL Server 2016 Analysis Services (KB3173784) Analysis Services
7807302 FIX: Can't create a database with a used database name by using the Create or CreateOrReplace command in SQL Server 2016 (KB3173779) Analysis Services
7940156 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200) (KB3178934) Analysis Services
7674716 Malformed xml requests may cause an internal error to be raised during parsing, causing a memory dump. Analysis Services
7760201 Vertipaq AV exception while running common queries when row-level security is present and Vertiscan trace events/XEvents are turned on. Analysis Services
7796665 An Excel workbook with an embedded PowerQuery may not be able to get scheduled data refresh. Analysis Services
7801559 Provide support for Database-Scoped credentials in SQL PDW. Data Warehouse
7678981 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server (KB3152965) High Availability
7705225 FIX: The SEEDING_MODE setting is ignored when you add an AlwaysOn AG replica to an existing AG in SQL Server 2016 (KB3168571) High Availability
7801571 Performance issues occur when using the sys.dm_hadr_availability_replica_states DMV on an AlwaysOn Availability Group that contains many databases in SQL Server 2016 (KB3173038) High Availability
7805725 The .NET Framework 3.5 is required when you configure SQL Server 2016 as a secondary in Transaction Log Shipping (KB3173666) High Availability
7806776 FIX: Availability databases aren't fully started after you restart the server instance of SQL Server 2016 (KB3173989) High Availability
7710427 Multiple reliability improvements in logging, redo, replication in Always On. High Availability
7520653 FIX: Large disk checkpoint usage occurs for an In-Memory optimized filegroup during heavy non-In-Memory workloads (KB3147012) In-Memory OLTP
7761773 FIX: Checkpoint files are missing from sys.dm_db_xtp_checkpoint_files on SQL Server 2016 (KB3173975) In-Memory OLTP
7761776 FIX: Slow database recovery in SQL Server 2016 due to large log when you use In-Memory OLTP on a high-end computer (KB3171001) In-Memory OLTP
7761777 SQL Server 2016 database log restore fails with the "Hk Recovery LSN is not NullLSN" error message (KB3171002) In-Memory OLTP
7771534 Data loss or incorrect results occur when you use the sp_settriggerorder stored procedure in SQL Server 2016 (KB3173004) In-Memory OLTP
7779857 FIX: Fatal Error when you run a query against the sys.sysindexes view in SQL Server 2016 (KB3173976) In-Memory OLTP
7779858 FIX: Secondary replica in "not healthy" state after you upgrade the primary database in SQL Server 2016 (KB3171863) In-Memory OLTP
7801567 FIX: Data loss when you alter column operation on a large memory-optimized table in SQL Server 2016 (KB3174963) In-Memory OLTP
7761774 Fixes high CPU and slow recovery on an In-Memory OLTP database where many DELETE operations have taken place. In-Memory OLTP
7705261 Adds the adjusted buffer size to the BufferSizeTuning event when AutoAdjustBufferSize is enabled in SSIS 2016 (KB3170140) Integration Services
7520608 FIX: "The process cannot access the file" error when an XML task fails in SQL Server (KB3115741) Integration Services
7600445 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 (KB3164404) Integration Services
7687861 FIX: Error 7330 when querying the view that is created by the Data Feed Publishing Wizard in SQL Server 2016 (KB3170132) Integration Services
7687872 FIX: SSIS package doesn't run when you call it from executable files outside the DTS\Binn folder in SQL Server 2016 (KB3170145) Integration Services
7693343 Buffer size isn't set correctly when the data flow engine handles blob data when AutoAdjustBufferSize is enabled in SQL Server Data Tools in Visual Studio 2015 (KB3170142) Integration Services
7735626 FIX: Can't generate an SSIS package when you use SQL Server Import and Export Wizard in SQL Server 2016 (KB3170214) Integration Services
7750351 FIX: SSMS can't save maintenance plans when you connect to an instance of SQL Server 2008 R2 or earlier versions (KB3171882) Integration Services
7750361 FIX: Unexpected exception when you add more maintenance plan tasks for an instance of SQL Server 2012 in SSMS 2016 (KB3171884) Integration Services
7705263 Add error codes to diagnostics information for SSIS 2016 package execution failures (KB3171174) Integration Services
7290668 FIX: "Failed to create a new table" error when you export the cleansing results of a Data Quality Services domain in SQL Server (KB3136205) Master Data Services (MDS)
7693380 An unhandled exception occurs when you reopen a saved workbook that contains MDS entities in SQL Server 2016 (KB3170061) MDS
7700604 FIX: Data loss when you run the udpConvertCollectionAndConsolidatedMembersToLeaf stored procedure in SQL Server 2016 MDS (KB3170076) MDS
7700848 FIX: Exception occurs when you associate an availability database with MDS web application in SQL Server 2016 (KB3170083) MDS
7700850 SQL Server 2016 can't send diagnostics information for MDS web application and MDS Add-in for Excel (KB3170071) MDS
7700851 Slow performance occurs when SQL Server 2016 Master Data Services is used for operations on large MDS databases (KB3170080) MDS
7705223 FIX: Can't insert the value NULL into column "ArgumentScript" when you apply a business rule in SQL Server 2016 MDS (KB3170084) MDS
7705224 FIX: Permission issues when you use SQL Server 2016 Master Data Services (KB3170079) MDS
7721158 An unhandled exception occurs after a filter is applied on an attribute in SQL Server 2016 Master Data Services (KB3170068) MDS
7721161 A deadlock condition occurs when you run certain operations in parallel in SQL Server 2016 Master Data Services (KB3170081) MDS
7721162 FIX: Permission issue or failure occurs when you upgrade to SQL Server 2016 Master Data Services (KB3170082) MDS
7721163 Can't create an MDS website by using a low-privilege account in SQL Server 2016 (KB3170078) MDS
7735621 FIX: Unexpected exception occurs when deploying a package using SQL Server 2016 MDSModelDeploy tool (KB3170074) MDS
7735625 Domain-based attributes created by MDS Add-in for Excel aren't available for Business Rules Extension feature in SQL Server 2016 (KB3170085) MDS
7735627 FIX: JavaScript error when you create an MDS subscription view in SQL Server 2016 (KB3170077) MDS
7735622 The Add Annotation button is disabled for the current member version in MDS Explorer (KB3170075) MDS
7723473 Improvements and fixes for SSRS 2016 mobile report (KB3170359) Reporting Services
7678915 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS (KB3152042) Reporting Services
7678934 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report (KB3152596) Reporting Services
7678976 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS (KB3162396) Reporting Services
7699227 FIX: The "Select All" check box doesn't work in the subscriptions page in SSRS 2016 (KB3167175) Reporting Services
7699246 FIX: Subscriptions that are filtered out are still affected by the actions in SSRS 2016 (KB3167174) Reporting Services
7699255 FIX: SSRS logs fill up the hard disk and agent jobs aren't recreated after database migration in SQL Server 2016 (KB3167434) Reporting Services
7711871 SQL Server 2016 Reporting Services doesn't upload Service Quality Monitoring data collections (KB3171470) Reporting Services
7711872 Can't open an SSRS paginated report from SQL Server 2016 Reporting Services web portal on an iPad (KB3171469) Reporting Services
7711873 FIX: Only one Boolean parameter can select default value when you have multiple Boolean parameters in SSRS 2016 (KB3168200) Reporting Services
7711874 The "BackgroundColor" property isn't respected when it's specified by an expression in SQL Server 2016 Reporting Services (KB3170528) Reporting Services
7711875 Fixes some issues about assistive technology tools in SSRS 2016 (KB3169923) Reporting Services
7711876 Can't create a new subscription for a report that contains Unicode characters in SQL Server 2016 Reporting Services web portal (KB3169922) Reporting Services
7711878 Update to fix layout issues in SQL Server 2016 Reporting Services (SSRS) web portal (KB3169921) Reporting Services
7760202 "HTTP 503: Service unavailable" error message when you open the SSRS web portal after you upgrade to SSRS 2016 (KB3171040) Reporting Services
7771533 FIX: Can't retrieve favorite KPIs or mobile reports in Power BI Mobile app or GetCatalogItem API in SQL Server 2016 (KB3171480) Reporting Services
7771535 Can't pin an SSRS report to Power BI dashboards when you aren't a member of any groups on PowerBI.com website (KB3171467) Reporting Services
7771743 A report configured to automatically refresh causes errors after the web browser idles for a while in SQL Server 2016 Reporting Services (KB3171085) Reporting Services
7771745 Drilling through from one mobile report to another doesn't respect the embed parameter specified in a URL in SQL Server 2016 Reporting Services (KB3171532) Reporting Services
7771746 FIX: Can't rename a catalog item with the same name in different case in SSRS 2016 (KB3171475) Reporting Services
7801558 FIX: Home page of SSRS web portal becomes empty after you enable My Reports feature in SQL Server 2016 (KB3172981) Reporting Services
7679024 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format (KB3160427) Reporting Services
7771744 FIX: Column becomes empty when the VerticalAlign property is set to Middle or Bottom in SSRS 2016 (KB3172732) Reporting Services
7801566 FIX: Localized user interface of SSRS 2016 web portal doesn't work correctly in Internet Explorer and Microsoft Edge (KB3173046) Reporting Services
7801569 FIX: Date picker on the SSRS 2016 web portal displays invalid characters if the web browser is set to non-English (KB3172939) Reporting Services
7439700 FIX: The ALTER SERVER CONFIGURATION with SET SOFTNUMA command doesn't work in SQL Server 2016 (KB3158710) Setup & Install
7722018 Setup UI changes to English if a non-English version of SQL Server 2016 GDR update is installed using the Product Update feature (KB3168257) Setup & Install
7761775 The Product Update feature doesn't update SQL Server Setup support files during a slipstreamed installation for a non-English version of SQL Server 2016 (KB3170293) Setup & Install
7824390 FIX: Can't install a non-English version of SQL Server 2016 on a Windows Server that is installed in Server Core mode (KB3173957) Setup & Install
7649866 Executions of sp_sqlagent_log_jobhistory or xp_instance_regread may cause an access violation due to outdated version of msvcrt120.dll. Setup & Install
7710425 Fixes an issue where LocalDB.msi package built from CU branch failed to install. Setup & Install
7381655 You may get an access violation in CBpBatch::PcGetVectorBuffer when using spatial functions. SQL Engine
7791519 Fixes a failure to upgrade a SQL Telemetry DLL Microsoft.SqlServer.Configuration.TelemetryConfigExtension.dll. SQL Engine
7791521 Performance and data improvement of SQL Telemetry queries. SQL Engine
7795583 You may see an access violation exception when performing DML operations on a temporal table with sparse columns and the DML doesn't modify the sparse columns. SQL Engine
7801551 Fixes an issue where SQL Telemetry services aren't successfully patched because it isn't restarted during an update. SQL Engine
7806257 If you use sp_execute_external_script with parameters, and the parameter declaration has value assignment in it, you may get an access violation exception. SQL Engine
7806598 When a user creates a new database and creates large number of partitions, the database becomes extremely slow. SQL Engine
7832337 Bulk insert fails with an access violation exception and error 7301 "Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)"". SQL Engine
7290754 Query plan generation improvement for some columnstore queries in SQL Server 2014 or 2016 (KB3146123) SQL performance
7290758 Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available (KB3156157) SQL performance
7290582 FIX: "Non-yielding Scheduler" condition when you run a query that contains a UNION operation in SQL Server 2014 or 2016 (KB3138321) SQL performance
7290744 FIX: An access violation occurs when you run a spatial query that contains OPENQUERY methods through a linked server in SQL Server 2014 or 2016 (KB3152135) SQL performance
7514884 FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 (KB3160303) SQL performance
7735628 FIX: Assertion failure when you run UNION or UNION ALL clauses on a Row-Level Security enabled table in SQL Server 2016 (KB3172973) SQL performance
7770911 Adds trace flag 9358 to disable batch mode sort operations in a complex parallel query in SQL Server 2016 (KB3171555) SQL performance
7801554 FIX: Can't disable batch mode sorted by session trace flag 9347 or the query hint QUERYTRACEON 9347 in SQL Server 2016 (KB3172787) SQL performance
7818856 FIX: SQL Server 2016 uses all available memory and crashes when it runs a query that contains HASHBYTES functions (KB3174684) SQL performance
7290727 Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server 2012 or 2016 (KB3149128) SQL security
7290649 FIX: SMK initialization fails on one node of a SQL Server 2012, 2014, or 2016 failover cluster (KB3132062) SQL security
7779871 SECURITY_CRYPTO_CONTEXT_MUTEX waits cause SQL Server 2016 to stop responding to client requests in SQL Server 2016 (KB3173472) SQL security
7801561 FIX: Wrong "schema_name" and "class_type" values for the CREATE SECURITY POLICY statement in SQL Server 2016 (KB3173043) SQL security
7705424 An update is available to add FIPS compliant support in SQL Server 2016 (KB3168570) SQL service
7806778 Behavior changes when you add uniqueidentifier columns in a clustered Columnstore Index in SQL Server 2016 (KB3173436) SQL service
7831747 Improves the installation process of the SQL Server R Services in SQL Server 2016 (KB3175018) SQL service
7290565 FIX: Error occurs when you try to drop or delete filegroups or partition schemes and functions in SQL Server (KB3132058) SQL service
7290686 FIX: "A severe error occurred on the current command" when a Table-Valued User-Defined function is referred to by a synonym (KB3139489) SQL service
7337506 FIX: "Cannot resolve the collation conflict" error when you apply a snapshot to the subscriber database in SQL Server (KB3131443) SQL service
7337617 FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server (KB2953354) SQL service
7513881 FIX: Heavy concurrent OLTP activity runs slowly when delayed durability is enabled in SQL Server 2016 (KB3170999) SQL service
7520618 FIX: Error 5120 when you create or use a FILESTREAM-enabled database on a dynamic disk in an instance of SQL Server 2014 or 2016 (KB3152377) SQL service
7520625 FIX: A "Non-yielding Scheduler" condition occurs when you perform a BULK INSERT and the data file exists in a FileTable in SQL Server (KB3150896) SQL service
7520630 FIX: FileTables in an AlwaysOn availability group become unavailable after failover in an instance of SQL Server (KB3152378) SQL service
7520647 FIX: Canceling a backup task crashes SQL Server 2014 or 2016 (KB3146404) SQL service
7593774 AUTOGROW_ALL_FILES and READ_ONLY aren't either updated by DDL or preserved after a database restarts in SQL Server 2016 (KB3163924) SQL service
7678948 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server (KB3154226) SQL service
7679011 FIX: MERGE statement to sync tables is unsuccessful when change data capture is enabled in SQL Server 2012, 2014, or 2016 (KB3155503) SQL service
7694330 FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 (KB3155209) SQL service
7694670 FIX: Can't create or delete a table or index when another DDL transaction is running on the same database in SQL Server 2016 (KB3168793) SQL service
7709918 Creating or updating statistics takes a long time on a large memory-optimized table in SQL Server 2016 (KB3170996) SQL service
7735631 FIX: ShortestLineTo() and STDistance() methods return incorrect result for the shortest distance in SQL Server 2016 (KB3175203) SQL service
7735635 FIX: Long query that contains specific expressions receives syntax error if forced parameterization is enabled in SQL Server 2016 (KB3175205) SQL service
7770910 FIX: Error 8061 when you use BULK INSERT on a table in SQL Server 2016 (KB3172959) SQL service
7771144 FIX: Error 8624 occurs when you run a query against a nonclustered columnstore index in SQL Server 2016 (KB3171544) SQL service
7771529 FIX: Error 10635 when you rebuild indexes online for tables that contain large object (LOB) columns in SQL Server 2016 (KB3174433) SQL service
7771530 FIX: Incorrect number of rows in sys.partitions for a columnstore index in SQL Server 2016 (KB3172974) SQL service
7771537 FIX: BULK INSERT or OPENROWSET import wrong data if UTF-8 encoded file doesn't have a BOM in SQL Server 2016 (KB3172671) SQL service
7772133 FIX: PolyBase feature doesn't install when you add a node to a SQL Server 2016 failover cluster (KB3173087) SQL service
7779868 The Customer Experience Improvement Program is disabled after FIPS compliance is enabled in SQL Server 2016 (KB3174788) SQL service
7779870 FIX: "The service is not available" error when you use SSRS 2016 Portal after you disconnect from the domain (KB3171505) SQL service
7788772 The Apply button on the Parameter Properties page isn't localized in SQL Server 2016 Reporting Services web portal (KB3171489) SQL service
7791531 A query that accesses data in a columnstore index causes the Database Engine to receive a floating point exception in SQL Server 2016 (KB3171759) SQL service
7795585 A data flush task may cause a deadlock condition when queries are executed on a memory-optimized table in SQL Server 2016 (KB3173841) SQL service
7795586 A memory leak occurs when DATA_CONSISTENCY_CHECK is being executed for a system-versioned temporal table in SQL Server 2016 (KB3174708) SQL service
7795587 Audit record is missing when you turn on SYSTEM_VERSIONING for a table by using the ALTER TABLE statement in SQL Server 2016 (KB3174710) SQL service
7795589 SYSTEM_VERSIONING isn't turned on for a table in a database that has the READ_COMMITTED_SNAPSHOT isolation level enabled in SQL Server 2016 (KB3174711) SQL service
7795590 A deadlock condition occurs when you make updates on a memory-optimized temporal table and you run the SWITCH PARTITION statement on a history table in SQL Server 2016 (KB3174712) SQL service
7795591 Data Flush Tasks of a memory-optimized temporal table may consume 100 percent CPU usage in SQL Server 2016 (KB3174713) SQL service
7801555 FIX: sys.dm_external_script_execution_stats returns an incorrect counter_value in SQL Server 2016 (KB3174395) SQL service
7801565 Windows Authentication doesn't work when you connect to SQL Server from R Script on SQL Server 2016 Express Edition (KB3174393) SQL service
7801572 FIX: "A network-related or instance-specific error occurred" when you repair SQL Server 2016 (KB3174829) SQL service
7806256 SQL Server 2016 generates a dump file when you execute an external script in parallel mode (KB3173065) SQL service
7806268 FIX: Failed execution of ALTER AUDIT statement causes SQL Server to crash in SQL Server 2016 (KB3174436) SQL service
7806777 FIX: It takes a long time to compile a query and add it to the Query Store in SQL Server 2016 (KB3175478) SQL service
7811575 FIX: Error 3456 "Could not redo log record" occurs, causing replicas to be suspended or repeated behavior in SQL Server (KB3173471) SQL service
7827402 FIX: Error 5283 when you run DBCC CHECKDB on a database that contains non-clustered columnstore index in SQL Server 2016 (KB3174088) SQL service
7831314 The Full-Text Search feature doesn't always return the expected results in SQL Server 2016 (KB3174674) SQL service
7837980 FIX: Queries on Stretch Database enabled databases always involve a network round-trip to Azure in SQL Server 2016 (KB3174812) SQL service
7866996 Query Store automatic data cleanup fails on editions other than Enterprise and Developer edition of SQL Server 2016 (KB3178297) SQL service
7914931 FIX: Potential loss of historical data when you alter an in-memory temporal table in SQL Server 2016 (KB3178137) SQL service
7284275 FIX: XA transactions aren't cleaned when you exit a Java application in an instance of SQL Server (KB3145492) SQL service
7337473 FIX: The Log Reader Agent stops intermittently and an Access Violation occurs in SQL Server (KB3123309) SQL service
7710945 FIX: Online index operations block DML operations when the database contains a clustered columnstore index (KB3172960) SQL service
7795584 FIX: Infinite recompile occurs when querying a view that references the identity column of a system-versioned temporal table (KB3174669) SQL service
7801553 FIX: Counters for job objects created by SQL Server Trusted Launchpad aren't visible in Windows Performance Monitor (KB3174396) SQL service
7806775 FIX: All data goes to deltastores when you bulk load data into a clustered columnstore index under memory pressure (KB3174073) SQL service
7811515 FIX: Can't query or migrate data from a local Stretch-enabled table after you execute sys.sp_rda_reconcile_batch (KB3174076) SQL service

How to obtain this cumulative update package

The following update is available from the Microsoft Download Center:

Download the latest cumulative update package for Microsoft SQL Server 2016 now

If the download page doesn't 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.

Notes for this update

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 might 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.
Hybrid environments deployment

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

Language support
  • SQL Server Cumulative Updates are currently multilingual. Therefore, this cumulative update package isn't specific to one language. It applies to all supported languages.
  • The "Download the latest cumulative update package for Microsoft SQL Server 2014 now" form displays the languages for which the update package is available. If you don't see your language, that's because a cumulative update package isn't available specifically for that language and the ENU download applies to all languages.
Components updated

One cumulative update package includes all the component packages. However, the cumulative update package updates only those components that are installed on the system.

Support for this update

If other issues occur, or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and to issues that don't qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers, or to create a separate service request, go to the Microsoft support website.

How to uninstall this update

To do this, follow these steps:

  1. In Control Panel, select Add or Remove Programs.

    Note

    If you are running Windows 7 or a later version, select Programs and Features in Control Panel.

  2. Locate the entry that corresponds to this cumulative update package.

  3. Right-click the entry, and then select Uninstall.

Cumulative update package information

Prerequisites

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

Restart information

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

Registry information

To use one of the hotfixes in this package, you don't have to make any changes to the registry.

File information

Cumulative update package file information

This cumulative update package might not contain all the files that you must have to fully update a product to the latest build. This package contains only the files that you must have to correct the issues that are listed in this article.

The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it's converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86-based versions

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.analysisservices.core.dll 13.0.2149.0 1064648 12-Jul-16 08:00 x86
Microsoft.analysisservices.dll 13.0.2149.0 702656 12-Jul-16 08:00 x86
Microsoft.analysisservices.tabular.dll 13.0.2149.0 765120 12-Jul-16 08:00 x86
Sql_common_core_keyfile.dll 2015.130.2149.0 88768 12-Jul-16 08:00 x86

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.cleansing.dll 13.0.2149.0 473280 12-Jul-16 08:01 x86

SQL Server 2016 Tools and Workstation Components Extensions

File name File version File size Date Time Platform
Dts.dll 2015.130.2149.0 2631872 12-Jul-16 08:00 x86
Dtspipeline.dll 2015.130.2149.0 1059520 12-Jul-16 08:00 x86
Dtswizard.exe 13.0.2149.0 895680 12-Jul-16 08:00 x86
Microsoft.analysisservices.project.dll 2015.130.2149.0 2023104 12-Jul-16 08:00 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2149.0 432840 12-Jul-16 08:00 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2149.0 2043584 12-Jul-16 08:01 x86
Microsoft.sqlserver.deployment.dll 13.0.2149.0 250048 12-Jul-16 08:01 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33992 12-Jul-16 08:01 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:01 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:01 x86
Msmdlocal.dll 2015.130.2149.0 36954824 12-Jul-16 08:00 x86
Msmgdsrv.dll 2015.130.2149.0 6497984 12-Jul-16 08:01 x86
Sql_tools_extensions_keyfile.dll 2015.130.2149.0 88768 12-Jul-16 08:00 x86
Xmsrv.dll 2015.130.2149.0 32693440 12-Jul-16 08:00 x86

x64-based versions

SQL Server 2016 Business Intelligence Development Studio

File name File version File size Date Time Platform
Sqlsqm_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 Writer

File name File version File size Date Time Platform
Sqlwriter_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 Analysis Services

File name File version File size Date Time Platform
Microsoft.analysisservices.server.core.dll 13.0.2149.0 1064136 12-Jul-16 08:00 x86
Microsoft.analysisservices.server.tabular.dll 13.0.2149.0 765640 12-Jul-16 08:00 x86
Microsoft.data.edm.netfx35.dll 5.7.0.62516 667872 15-Jun-16 12:46 x86
Microsoft.data.edm.netfx35.dll 5.7.0.62516 667872 17-Jun-16 00:32 x86
Microsoft.data.mashup.dll 2.35.4399.541 186592 15-Jun-16 12:46 x86
Microsoft.data.mashup.dll 2.35.4399.541 186592 17-Jun-16 00:32 x86
Microsoft.data.odata.netfx35.dll 5.7.0.62516 1461464 15-Jun-16 12:46 x86
Microsoft.data.odata.netfx35.dll 5.7.0.62516 1461464 17-Jun-16 00:32 x86
Microsoft.data.odata.query.netfx35.dll 5.7.0.62516 188128 15-Jun-16 12:46 x86
Microsoft.data.odata.query.netfx35.dll 5.7.0.62516 188128 17-Jun-16 00:32 x86
Microsoft.mashup.container.exe 2.35.4399.541 27872 15-Jun-16 12:46 x64
Microsoft.mashup.container.exe 2.35.4399.541 27872 17-Jun-16 00:32 x64
Microsoft.mashup.container.netfx40.exe 2.35.4399.541 28384 15-Jun-16 12:46 x64
Microsoft.mashup.container.netfx40.exe 2.35.4399.541 28384 17-Jun-16 00:32 x64
Microsoft.mashup.container.netfx45.exe 2.35.4399.541 28384 15-Jun-16 12:46 x64
Microsoft.mashup.container.netfx45.exe 2.35.4399.541 28384 17-Jun-16 00:32 x64
Microsoft.mashup.eventsource.dll 2.35.4399.541 159456 15-Jun-16 12:46 x86
Microsoft.mashup.eventsource.dll 2.35.4399.541 159456 17-Jun-16 00:32 x86
Microsoft.mashup.oauth.dll 2.35.4399.541 63200 15-Jun-16 12:46 x86
Microsoft.mashup.oauth.dll 2.35.4399.541 63200 17-Jun-16 00:32 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 143072 15-Jun-16 12:46 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 143072 17-Jun-16 00:32 x86
Microsoft.mashupengine.dll 2.35.4399.541 5652704 15-Jun-16 12:46 x86
Microsoft.mashupengine.dll 2.35.4399.541 5652704 17-Jun-16 00:32 x86
Microsoft.odata.core.netfx35.dll 6.15.0.0 1444576 15-Jun-16 12:46 x86
Microsoft.odata.core.netfx35.dll 6.15.0.0 1444576 17-Jun-16 00:32 x86
Microsoft.odata.edm.netfx35.dll 6.15.0.0 785632 15-Jun-16 12:46 x86
Microsoft.odata.edm.netfx35.dll 6.15.0.0 785632 17-Jun-16 00:32 x86
Microsoft.spatial.netfx35.dll 6.15.0.0 133344 15-Jun-16 12:46 x86
Microsoft.spatial.netfx35.dll 6.15.0.0 133344 17-Jun-16 00:32 x86
Msmdlocal.dll 2015.130.2149.0 36954824 12-Jul-16 08:00 x86
Msmdlocal.dll 2015.130.2149.0 55971016 12-Jul-16 08:02 x64
Msmdsrv.exe 2015.130.2149.0 56515776 12-Jul-16 08:00 x64
Msmgdsrv.dll 2015.130.2149.0 7502528 12-Jul-16 08:00 x64
Msmgdsrv.dll 2015.130.2149.0 6497984 12-Jul-16 08:01 x86
Sql_as_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Sqlceip.exe 13.0.2149.0 193216 12-Jul-16 08:00 x86
System.spatial.netfx35.dll 5.7.0.62516 124640 15-Jun-16 12:46 x86
System.spatial.netfx35.dll 5.7.0.62516 124640 17-Jun-16 00:32 x86
Tmapi.dll 2015.130.2149.0 4344512 12-Jul-16 08:00 x64
Tmcachemgr.dll 2015.130.2149.0 2825408 12-Jul-16 08:00 x64
Tmpersistence.dll 2015.130.2149.0 1069760 12-Jul-16 08:00 x64
Tmtransactions.dll 2015.130.2149.0 1347264 12-Jul-16 08:00 x64
Xmsrv.dll 2015.130.2149.0 32693440 12-Jul-16 08:00 x86
Xmsrv.dll 2015.130.2149.0 24012992 12-Jul-16 08:00 x64

SQL Server 2016 Database Services Common Core

File name File version File size Date Time Platform
Microsoft.analysisservices.core.dll 13.0.2149.0 1064648 12-Jul-16 08:00 x86
Microsoft.analysisservices.dll 13.0.2149.0 702656 12-Jul-16 08:00 x86
Microsoft.analysisservices.tabular.dll 13.0.2149.0 765120 12-Jul-16 08:00 x86
Sql_common_core_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 Data Quality

File name File version File size Date Time Platform
Microsoft.ssdqs.cleansing.dll 13.0.2149.0 473280 12-Jul-16 08:00 x86
Microsoft.ssdqs.cleansing.dll 13.0.2149.0 473280 12-Jul-16 08:01 x86

SQL Server 2016 Database Services Core Instance

File name File version File size Date Time Platform
Hkcompile.dll 2015.130.2149.0 1296576 12-Jul-16 08:00 x64
Hkengine.dll 2015.130.2149.0 5596864 12-Jul-16 08:00 x64
Hkruntime.dll 2015.130.2149.0 159424 12-Jul-16 08:00 x64
Qds.dll 2015.130.2149.0 843456 12-Jul-16 08:02 x64
Rsfxft.dll 2015.130.2149.0 34496 12-Jul-16 08:00 x64
Sql_engine_core_inst_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Sqlaccess.dll 2015.130.2149.0 461504 12-Jul-16 08:00 x64
Sqlagent.exe 2015.130.2149.0 565952 12-Jul-16 08:00 x64
Sqlceip.exe 13.0.2149.0 193216 12-Jul-16 08:00 x86
Sqldk.dll 2015.130.2149.0 2583752 12-Jul-16 08:02 x64
Sqllang.dll 2015.130.2149.0 39278784 12-Jul-16 08:02 x64
Sqlmin.dll 2015.130.2149.0 37326536 12-Jul-16 08:00 x64
Sqlos.dll 2015.130.2149.0 26304 12-Jul-16 08:00 x64
Sqlscriptdowngrade.dll 2015.130.2149.0 27840 12-Jul-16 08:00 x64
Sqlscriptupgrade.dll 2015.130.2149.0 5797064 12-Jul-16 08:00 x64
Sqlserverspatial130.dll 2015.130.2149.0 732864 12-Jul-16 08:00 x64
Sqlservr.exe 2015.130.2149.0 392384 12-Jul-16 08:00 x64
Sqltses.dll 2015.130.2149.0 8896704 12-Jul-16 08:00 x64

SQL Server 2016 Database Services Core Shared

File name File version File size Date Time Platform
Dts.dll 2015.130.2149.0 3145408 12-Jul-16 08:01 x64
Dtspipeline.dll 2015.130.2149.0 1278152 12-Jul-16 08:01 x64
Dtswizard.exe 13.0.2149.0 895168 12-Jul-16 08:01 x64
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33984 12-Jul-16 08:00 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:00 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:00 x86
Sql_engine_core_shared_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 sql_extensibility

File name File version File size Date Time Platform
Launchpad.exe 2015.130.2149.0 1012928 12-Jul-16 08:01 x64
Sql_extensibility_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Sqlsatellite.dll 2015.130.2149.0 836800 12-Jul-16 08:00 x64

SQL Server 2016 Full-Text Engine

File name File version File size Date Time Platform
Mswb7.dll 14.0.4763.1000 331672 29-Apr-15 02:16 x64
Prm0007.bin 14.0.4763.1000 11602944 29-Apr-15 02:16 x64
Prm0009.bin 14.0.4763.1000 5739008 29-Apr-15 02:16 x64
Prm0013.bin 14.0.4763.1000 9482240 29-Apr-15 02:16 x64
Sql_fulltext_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 sql_inst_mr

File name File version File size Date Time Platform
Imrdll.dll 13.0.2149.0 23744 12-Jul-16 08:00 x86
Sql_inst_mr_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 Integration Services

File name File version File size Date Time Platform
Dts.dll 2015.130.2149.0 2631872 12-Jul-16 08:00 x86
Dts.dll 2015.130.2149.0 3145408 12-Jul-16 08:01 x64
Dtspipeline.dll 2015.130.2149.0 1059520 12-Jul-16 08:00 x86
Dtspipeline.dll 2015.130.2149.0 1278152 12-Jul-16 08:01 x64
Dtswizard.exe 13.0.2149.0 895680 12-Jul-16 08:00 x86
Dtswizard.exe 13.0.2149.0 895168 12-Jul-16 08:01 x64
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 13.0.2149.0 469704 12-Jul-16 08:00 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 13.0.2149.0 469696 12-Jul-16 08:01 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33984 12-Jul-16 08:00 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33992 12-Jul-16 08:01 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:00 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:01 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:00 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:01 x86
Msdtssrvr.exe 13.0.2149.0 216768 12-Jul-16 08:01 x64
Sql_is_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Sqlceip.exe 13.0.2149.0 193216 12-Jul-16 08:00 x86

SQL Server 2016 PolyBase

File name File version File size Date Time Platform
Sqldk.dll 2015.130.2149.0 2526408 12-Jul-16 08:00 x64
Sqlos.dll 2015.130.2149.0 26304 12-Jul-16 08:00 x64
Sqltses.dll 2015.130.2149.0 9064128 12-Jul-16 08:00 x64

SQL Server 2016 Reporting Services

File name File version File size Date Time Platform
Microsoft.reportingservices.authorization.dll 13.0.2149.0 77000 12-Jul-16 08:00 x86
Microsoft.reportingservices.dataextensions.xmlaclient.dll 13.0.2149.0 567488 12-Jul-16 08:00 x86
Microsoft.reportingservices.diagnostics.dll 13.0.2149.0 1620160 12-Jul-16 08:01 x86
Microsoft.reportingservices.hpbprocessing.dll 13.0.2149.0 329408 12-Jul-16 08:01 x86
Microsoft.reportingservices.htmlrendering.dll 13.0.2149.0 887488 12-Jul-16 08:01 x86
Microsoft.reportingservices.interfaces.dll 13.0.2149.0 76480 12-Jul-16 08:00 x86
Microsoft.reportingservices.interfaces.dll 13.0.2149.0 76480 12-Jul-16 08:01 x86
Microsoft.reportingservices.portal.interfaces.dll 13.0.2149.0 122560 12-Jul-16 08:01 x86
Microsoft.reportingservices.portal.odatawebapi.dll 13.0.2149.0 104136 12-Jul-16 08:01 x86
Microsoft.reportingservices.portal.services.dll 13.0.2149.0 4892864 12-Jul-16 08:01 x86
Microsoft.reportingservices.portal.web.dll 13.0.2149.0 9644736 12-Jul-16 08:01 x86
Microsoft.reportingservices.portal.webhost.exe 13.0.2149.0 93376 12-Jul-16 08:01 x64
Microsoft.reportingservices.processingcore.dll 13.0.2149.0 5951168 12-Jul-16 08:01 x86
Msmdlocal.dll 2015.130.2149.0 36954824 12-Jul-16 08:00 x86
Msmdlocal.dll 2015.130.2149.0 55971016 12-Jul-16 08:02 x64
Msmgdsrv.dll 2015.130.2149.0 7502528 12-Jul-16 08:00 x64
Msmgdsrv.dll 2015.130.2149.0 6497984 12-Jul-16 08:01 x86
Reportingserviceslibrary.dll 13.0.2149.0 2516680 12-Jul-16 08:00 x86
Reportingservicesnativeclient.dll 2015.130.2149.0 108744 12-Jul-16 08:00 x64
Reportingservicesnativeclient.dll 2015.130.2149.0 114368 12-Jul-16 08:01 x86
Reportingservicesnativeserver.dll 2015.130.2149.0 99016 12-Jul-16 08:00 x64
Reportingserviceswebserver.dll 13.0.2149.0 2516168 12-Jul-16 08:00 x86
Sql_rs_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Sqlserverspatial130.dll 2015.130.2149.0 732864 12-Jul-16 08:00 x64
Sqlserverspatial130.dll 2015.130.2149.0 584384 12-Jul-16 08:00 x86
Xmsrv.dll 2015.130.2149.0 32693440 12-Jul-16 08:00 x86
Xmsrv.dll 2015.130.2149.0 24012992 12-Jul-16 08:00 x64

SQL Server 2016 R Services

File name File version File size Date Time Platform
Smrdll.dll 13.0.2149.0 23744 12-Jul-16 08:00 x86
Sql_engine_core_shared_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64

SQL Server 2016 Tools and Workstation Components Extensions

File name File version File size Date Time Platform
Dts.dll 2015.130.2149.0 2631872 12-Jul-16 08:00 x86
Dts.dll 2015.130.2149.0 3145408 12-Jul-16 08:01 x64
Dtspipeline.dll 2015.130.2149.0 1059520 12-Jul-16 08:00 x86
Dtspipeline.dll 2015.130.2149.0 1278152 12-Jul-16 08:01 x64
Dtswizard.exe 13.0.2149.0 895680 12-Jul-16 08:00 x86
Dtswizard.exe 13.0.2149.0 895168 12-Jul-16 08:01 x64
Microsoft.analysisservices.project.dll 2015.130.2149.0 2023104 12-Jul-16 08:00 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2149.0 432840 12-Jul-16 08:00 x86
Microsoft.sqlserver.chainer.infrastructure.dll 13.0.2149.0 432832 12-Jul-16 08:01 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2149.0 2043584 12-Jul-16 08:01 x86
Microsoft.sqlserver.configuration.sco.dll 13.0.2149.0 2043592 12-Jul-16 08:01 x86
Microsoft.sqlserver.deployment.dll 13.0.2149.0 250048 12-Jul-16 08:01 x86
Microsoft.sqlserver.deployment.dll 13.0.2149.0 250056 12-Jul-16 08:01 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33984 12-Jul-16 08:00 x86
Microsoft.sqlserver.integrationservices.runtimetelemetry.dll 13.0.2149.0 33992 12-Jul-16 08:01 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:00 x86
Microsoft.sqlserver.manageddts.dll 13.0.2149.0 606400 12-Jul-16 08:01 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:00 x86
Microsoft.sqlserver.packageformatupdate.dll 13.0.2149.0 445120 12-Jul-16 08:01 x86
Msmdlocal.dll 2015.130.2149.0 36954824 12-Jul-16 08:00 x86
Msmdlocal.dll 2015.130.2149.0 55971016 12-Jul-16 08:02 x64
Msmgdsrv.dll 2015.130.2149.0 7502528 12-Jul-16 08:00 x64
Msmgdsrv.dll 2015.130.2149.0 6497984 12-Jul-16 08:01 x86
Sql_tools_extensions_keyfile.dll 2015.130.2149.0 100544 12-Jul-16 08:01 x64
Xmsrv.dll 2015.130.2149.0 32693440 12-Jul-16 08:00 x86
Xmsrv.dll 2015.130.2149.0 24012992 12-Jul-16 08:00 x64

References