--- title: Installing SQL Server 2016 on Windows Server 2012 R2 (the KB2919355 issue) description: This post explains how to overcome the frustrating KB2919355 issue when installing SQL Server 2016 on Windows Server 2012 R2 image: https://blog.coeo.com/hubfs/Blog%20images/The%20KB2919355%20installation%20failed.png --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # Installing SQL Server 2016 on Windows Server 2012 R2 (the KB2919355 issue) # The Coeo Blog ![Ryan Allport](https://blog.coeo.com/hubfs/Profile%20photos/RyanCircle.jpg) While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading. First, the environment. The box was running Windows Server 2012 R2 and had SQL Server 2014 already installed which was being used as a data warehouse. The plan was to migrate away from SQL Server 2014 to SQL Server 2016. The problem presented itself almost immediately: ![The KB2919355 installation failed](https://blog.coeo.com/hs-fs/hubfs/Blog%20images/The%20KB2919355%20installation%20failed.png?width=817&name=The%20KB2919355%20installation%20failed.png) As you can see, the upgrade feature rules check failed around the KB2919355 installation. At this point, reading the error message, I assumed (I know, I know, it’s something we should never do as a DBA!) that the patch had been downloaded and applied during the latest round of Windows patching, and all that was required was a server reboot. I was wrong. Upon running the upgrade again, I got the same error message. Hmm, annoying. So, after some Googling I was confident I knew what to do to resolve this; download and install the KB2919355 patch. So, I downloaded the patch from the official Microsoft website ([KB2919355](https://www.microsoft.com/en-us/download/confirmation.aspx?id=42334)) and kicked off the installation. ![The update is not applicable to your computer](https://blog.coeo.com/hs-fs/hubfs/Blog%20images/The%20update%20is%20not%20applicable%20to%20your%20computer.png?width=364&name=The%20update%20is%20not%20applicable%20to%20your%20computer.png) As you can probably tell, annoyingly the patch installs failed. Back to Google. I figured out that to install KB2919355, I needed to install a different patch: KB2919442. As far as I’m aware, these are not included within the normal Windows updates, in some cases, I’ve seen them referenced as optional updates to download. So, after installing KB2919442 successfully, I was then able to install KB2919355 without issue. Phew! Once those two patches had been installed and the server rebooted, I then re-ran the SQL Server 2016 upgrade and it passed the feature rules without issue and I was able to complete the upgrade successfully. Hopefully this will save someone out there lots of time and from pulling their hair out scouring Google for a solution. ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [Microsoft Envision UK 2022](https://blog.coeo.com/microsoft-envision-uk-2022) ### [SQLBits 2022 session - Field Testing Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/sqlbits-2022-session-field-testing-ola-hallengrens-maintenance-solution) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top