Install Problems Reported in SQL Server 2014 SP1 -- Visual Studio Magazine

Install Problems Reported in SQL Server 2014 SP1

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

By Kurt Mackie
04/17/2015

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.

Printable Format

comments powered by Disqus

Featured

Cloud-Focused .NET Aspire 9.1 Released

Along with .NET 10 Preview 1, Microsoft released.NET Aspire 9.1, the latest update to its opinionated, cloud-ready stack for building resilient, observable, and configurable cloud-native applications with .NET.
Microsoft Ships First .NET 10 Preview

Microsoft shipped .NET 10 Preview 1, introducing a raft of improvements and fixes across performance, libraries, and the developer experience.
C# Dev Kit Previews .NET Aspire Orchestration

Microsoft's dev team has been busy updating the C# Dev Kit, a Visual Studio Code extension that enhances the C# development experience by providing tools for managing, debugging, and editing C# projects.
Hands On: New VS Code Insiders Build Creates Web Page from Image in Seconds

New Vision support with GitHub Copilot in the latest Visual Studio Code Insiders build takes a user-supplied mockup image and creates a web page from it in seconds, handling all the HTML and CSS.
Naive Bayes Regression Using C#

Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the naive Bayes regression technique, where the goal is to predict a single numeric value. Compared to other machine learning regression techniques, naive Bayes regression is usually less accurate, but is simple, easy to implement and customize, works on both large and small datasets, is highly interpretable, and doesn't require tuning any hyperparameters.