Cumulative update 1 for SQL Server 2014 SP2

Applies to: SQL Server 2014 Business IntelligenceSQL Server 2014 Business IntelligenceSQL Server 2014 Developer More

This article describes cumulative update package 1 (build number: 12.0.5511.0) for Microsoft SQL Server 2014 Service Pack 2 (SP2). This update contains fixes that were released after the release of SQL Server 2014 SP2.

Cumulative update

Cumulative updates are now available at the Microsoft Download Center.

Only the most recent cumulative update (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.

The Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack is a stand-alone package that provides additional value for SQL Server Integration Services (SSIS).Note After future CUs are released for SQL Server 2014 Service Pack 2, this CU can be downloaded from the Microsoft Windows Update Catalog. However, we recommend that you install the latest CU that's available.

Hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
7990703 3070382 FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name SQL service
7990673 3178541 PivotTable connects to incorrect data source in SQL Server 2012 or 2014 PowerPivot for SharePoint Analysis Services
7990684 3150432 Performance of Analysis Services in Multidimensional mode degrades over time Analysis Services
7855155 3168690 FIX: SQL Server 2014 PowerShell script jobs trigger DCOM errors after you install Azure PowerShell Management Tools
7990722 3170051 FIX: SQL Server 2012 failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting High Availability
7679006 3157575 FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server 2012 or 2014 Management Tools
7855199 3160303 FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 SQL performance
7855170 3154147 FIX: "Value cannot be null" error occurs when you evaluate or import policies for registered servers in SQL Server 2014 Management Tools
7678944 3154226 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server SQL service
7990664 3162858 "The log backup chain is broken" error when the log backup process fails in SQL Server High Availability
7855158 3168707 FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 Management Tools
7678980 3152965 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server High Availability
7679023 3160427 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
7990687 3171896 Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas in SQL Server High Availability
7855175 3154482 FIX: Service Broker UCS task leaks memory in SQL Server 2014 SQL service
7678990 3149128 Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server SQL security
7855165 3168708 FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server 2014 SP1 or SP2 Management Tools
7987652 3184227 "The remote server '(null)' does not exist" error occurs after you remove an article from a publication in SQL Server 2014 SQL service
7678929 3152596 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Reporting Services
7990659 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
7990668 3171516 Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Analysis Services
7990650 3156452 FIX: "'Salt' attribute for OraPassword is missing" error in SSIS in SQL Server 2012 or 2014 Integration Services
7520685 3151526 FIX: Incremental deployment of an Analysis Services project to SQL Server 2014 Service Pack 1 causes unexpected shutdown Analysis Services
7678913 3152042 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Reporting Services
7678974 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
7990693 3177666 FIX: Cannot create or manage data alert for a report if the report name or folder name contains a comma in SSRS 2012 or 2014 Reporting Services
7679014 3158388 FIX: SQL Server 2016 MDS database is not visible in SQL Server 2012 MDS Configuration Manager Data Quality Services (DQS)
7855162 3169738 FIX: Managed Backup Retention-based cleanup task fails because of a query time-out in SQL Server 2014 SP1 or SP2 Management Tools
7855194 3157016 FIX: RDL report that's generated programmatically fails to run in SSRS 2014 or SSRS 2012 Reporting Services
7855189 3168710 FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 SQL service
7679023 3160427 FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
7990659 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
7694336 3160874 FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition Analysis Services
7855160 3169736 FIX: Can't create a database backup by executing smart_admin.sp_backup_on_demand on a non-preferred backup replica Management Tools
7990713 3166545 FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
8198020 3175883 Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server SQL performance
8197967 3153836 Operating system error 32 when you restore a database in SQL Server 2014 SQL service
8198026 3178526 An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 SQL connectivity
N/A 3212393 FIX: rsInvalidReportServerDatabase error after you upgrade a SQL Server 2012 instance SQL service
7504584 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR in SQL Server 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.