Cumulative update 1 for SQL Server 2014 SP2

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 numberKB article numberDescriptionFix area
79907033070382FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name SQL service
79906733178541PivotTable connects to incorrect data source in SQL Server 2012 or 2014 PowerPivot for SharePoint Analysis Services
79906843150432Performance of Analysis Services in Multidimensional mode degrades over time Analysis Services
78551553168690FIX: SQL Server 2014 PowerShell script jobs trigger DCOM errors after you install Azure PowerShell Management Tools
79907223170051FIX: SQL Server 2012 failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting High Availability
76790063157575FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server 2012 or 2014 Management Tools
78551993160303FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016 SQL performance
78551703154147FIX: "Value cannot be null" error occurs when you evaluate or import policies for registered servers in SQL Server 2014 Management Tools
76789443154226FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server SQL service
79906643162858"The log backup chain is broken" error when the log backup process fails in SQL Server High Availability
78551583168707FIX: Retention policy does not work when you use SQL Server Managed Backup to Windows Azure in SQL Server 2014 Management Tools
76789803152965FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server High Availability
76790233160427FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
79906873171896Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas in SQL Server High Availability
78551753154482FIX: Service Broker UCS task leaks memory in SQL Server 2014 SQL service
76789903149128Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server SQL security
78551653168708FIX: SQL Server Managed Backup to Windows Azure tries to back up database snapshots in SQL Server 2014 SP1 or SP2 Management Tools
79876523184227"The remote server '(null)' does not exist" error occurs after you remove an article from a publication in SQL Server 2014 SQL service
76789293152596FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Reporting Services
79906593164404FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
79906683171516Update to add a security warning message when you schedule data refresh for PowerPivot workbooks Analysis Services
79906503156452FIX: "'Salt' attribute for OraPassword is missing" error in SSIS in SQL Server 2012 or 2014 Integration Services
75206853151526FIX: Incremental deployment of an Analysis Services project to SQL Server 2014 Service Pack 1 causes unexpected shutdown Analysis Services
76789133152042FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Reporting Services
76789743162396FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
79906933177666FIX: 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
76790143158388FIX: SQL Server 2016 MDS database is not visible in SQL Server 2012 MDS Configuration Manager Data Quality Services (DQS)
78551623169738FIX: Managed Backup Retention-based cleanup task fails because of a query time-out in SQL Server 2014 SP1 or SP2 Management Tools
78551943157016FIX: RDL report that's generated programmatically fails to run in SSRS 2014 or SSRS 2012 Reporting Services
78551893168710FIX: CONTEXT_INFO returns incorrect values when context_info ends with two trailing zeros in SQL Server 2014 SQL service
76790233160427FIX: Incorrect page numbers are displayed when you export an SSRS report to PDF or TIFF format Reporting Services
79906593164404FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
76943363160874FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition Analysis Services
78551603169736FIX: Can't create a database backup by executing smart_admin.sp_backup_on_demand on a non-preferred backup replica Management Tools
79907133166545FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
81980203175883Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL ServerSQL performance
81979673153836Operating system error 32 when you restore a database in SQL Server 2014SQL service
81980263178526An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014SQL connectivity
N/A 3212393FIX: rsInvalidReportServerDatabase error after you upgrade a SQL Server 2012 instance 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:

Language support
Components updated
Support for this update
How to uninstall this update

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.
Cumulative update package file information
Properties

Article ID: 3178925 - Last Review: Dec 15, 2016 - Revision: 1

Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, SQL Server 2014 Reporting Services

Feedback