Microsoft Pulls SQL Server 2014 SP1 Due to Install Problems -- Redmondmag.com

Microsoft Pulls SQL Server 2014 SP1 Due to Install Problems

By Kurt Mackie
04/17/2015

Microsoft released SQL Server 2014 Service Pack 1 this week, but later pulled it after install errors surfaced.

The service pack originally was released via the Microsoft Download Center on Wednesday, but Microsoft subsequently found an "installation issue" with it. Consequently, the service pack was removed the next day.

Microsoft plans to make SP1 for SQL Server 2014 available again sometime "in the next few weeks," according to an updated announcement.

When SP1 gets released again, IT pros should replace the current build (12.0.4050.0) with the new build. Organizations that have already installed SP1 can follow the workaround steps that Microsoft describes in its updated announcement as a remediation step until the new build arrives.

The install problem affects "any SQL Server instance with SSISDB catalog enabled," according to Microsoft. It makes SQL Server unusable and throws the following error message: "Error: 912, Severity: 21, State: 2."

The new service pack, when reissued, will set a new service baseline for SQL Server 2014. SP1 includes fixes from Cumulative Update 1 to Cumulative Update 5, as well as some SQL Server 2012 SP2 fixes, Microsoft indicated.

As for SP1's benefits, Microsoft highlighted an improvement in its column store performance. SP1 also will fix some buffer pool extension issues. Queries will compile faster via a "new cardinality estimator," among other perks.

Microsoft's original announcement on Wednesday had indicated that SQL Server 2014 SP1 would be released via "the Volume Licensing center and via Microsoft Update starting May 1, 2015." However, those plans possibly may be changed now due to the flawed initial release.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.