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

  • Top 3 Blazor Extensions for Visual Studio Code

    Some developers prefer to create applications with Microsoft's open-source Blazor tooling from within the open-source, cross-platform Visual Studio Code editor. Here are the top tools in the VS Code Marketplace for those folk, as measured by the number of installations.

  • How to Invert a Machine Learning Matrix Using C#

    VSM Senior Technical Editor Dr. James McCaffrey, of Microsoft Research, explains why inverting a matrix -- one of the more common tasks in data science and machine learning -- is difficult and presents code that you can use as-is, or as a starting point for custom matrix inversion scenarios.

  • Microsoft Engineer: 'It's Time to Move OData to .NET 5'

    Microsoft engineer Sam Xu says "it’s time to move OData to .NET 5" and in a new blog post he shows how to do just that.

  • Microsoft Goes Virtual with Developer Education in Face of COVID-19

    Like many organizations that host developer educational events, Microsoft has gone virtual amid shelter-in-place directives and a surge in remote work stemming from the COVID-19 pandemic.

  • Microsoft Enhances Low-Code Power Apps

    Microsoft's nod to the low-code movement, Power Apps, has been enhanced with a bevy of new features, including mixed reality, canvas/model support in a new mobile app, UX improvements and more.

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events