Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

综合技术 2017-06-22

If you are trying to install SQL Server 2016 on Windows Server 2012 R2, under certain circumstances, you might get the below error message:

Rule "KB2919355 Installation" failed.


KB2919355 Check Failed. If you have installed KB2919355, please make sure you have restarted your machine. For more information, you can visit https://support.microsoft.com/kb/2919355/

The first logical thing to try is of course to install the reported set of patches under the name "KB2919355" .

However, when you try to install KB2919355 you might get an error message as well, just like the below:

"This update is not applicable for you computer"

So, what do you do?

A possible reason for not being able to install KB2919355 is that it is missing another prerequisite patch: KB2919442

I know, all this prerequisites thing can be a little bit annoying sometimes but what else can we do? 🙂

So, in order to overcome the issue and be able to install SQL Server 2016 on your Windows Server 2012 R2, you can try first the below set of actions:

Step 1: Install patch KB2919442

Step 2: Install patch KB2919355 . Note that KB2919355 is not a single patch but a package of KBs which, as provided in Microsoft's instructions, need to be installed in the following order:

- clearcompressionflag.exe

- KB2919355

- KB2932046

- KB2959977

- KB2937592

- KB2938439

- KB2934018

Note about Step 2 : Almost each one of the patches will require to reboot the computer after installation. Prior to each reboot, first make sure that you don't have any applications open or any unsaved work.

Step 3: Try again to install SQL Server

Hope this helps!

Reference: The SQL Server and .NET Hub ( http://www.sqlnethub.com )

What are your views on the subject? Have something to share? Feel free to leave your comment!

您可能感兴趣的

What’s new in SQL Server Management Studio 17.3 This post was authored by Alan Yu, Program Manager, Microsoft SQL Server We are excited to announce the release of SQL Server Management Studio (SSM...
Execute Multiple Files Using SQLCMD/SQLClient – Wh... Hello! I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database to another. The pro...
Few Outer Rows Optimization In this blog post, we will look at one more Nested Loops (NL) Join Post Optimization Rewrite. This time we will talk about parallel NL and Few Outer R...
SQL Server Replication for Temporal Tables SQL Server Indexing Tips and Tricks - Our next free MSSQLTips Webcast Problem Let's say you have the need to replicate SQL Server temporal tabl...
SQL SERVER – Error: 17142 – SQL Server Service has... Recently I was looking around in my virtual machine to find a topic to blog. Within a few minutes, I was having an idea. In this blog we would talk ab...