News

Install Problems Reported in SQL Server 2014 SP1

Microsoft pulled its SQL Server 2014 Service Pack 1 after numerous reports of installation errors.

Microsoft pulled its SQL Server 2014 Service Pack 1 on Thursday after numerous reports of installation errors. Microsoft said it 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.

comments powered by Disqus

Featured

  • ML.NET Improves Object Detection

    Microsoft improved the object detection capabilities of its ML.NET machine learning framework for .NET developers, adding the ability to train custom models with Model Builder in Visual Studio.

  • More Improvements for VS Code's New Python Language Server

    Microsoft announced more improvements for the new Python language server for Visual Studio Code, Pylance, specializing in rich type information.

  • Death of the Dev Machine?

    Here's a takeaway from this week's Ignite 2020 event: An advanced Azure cloud portends the death of the traditional, high-powered dev machine packed with computing, memory and storage components.

  • COVID-19 Is Ignite 2020's Elephant in the Room: 'Frankly, It Sucks'

    As in all things of our new reality, there was no escaping the drastic changes in routine caused by the COVID-19 pandemic during Microsoft's big Ignite 2020 developer/IT pro conference, this week shifted to an online-only event after drawing tens of thousands of in-person attendees in years past.

  • Visual Studio 2019 v16.8 Preview Update Adds Codespaces

    To coincide with the Microsoft Ignite 2020 IT pro/developer event, the Visual Studio dev team shipped a new update, Visual Studio 2019 v16.8 Preview 3.1, with the main attraction being support for cloud-hosted Codespaces, now in a limited beta.

Upcoming Events