I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. But there one thing that has caught my attention every single day I have been with her – she is curious about every single thing that she sees. With every new release of SQL Server, I sort of get into the same mode or feeling. I become a child as there is so much to explore and learn.
I heard about new a lot of new features in SQL Server 2016. So, I downloaded media from Microsoft site and tried installing on my VM. I have selected all the features and moved forward. This is common because I don’t want to miss out on anything that gets introduced in the new release. Later, during the installation process, I faced an error and I was not able to proceed.
Here is the Rule check failure.
I was wondering what part of SQL Server required us to have Oracle JRE. If I click on hyperlink on failed, I get below:
Here is the text of the message:
Rule Check Result
Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed.
This computer does not have the Oracle Java SE Runtime Environment Version 7 Update 51 (64-bit) or higher installed. The Oracle Java SE Runtime Environment is software provided by a third party. Microsoft grants you no rights for such third-party software. You are responsible for and must separately locate, read and accept applicable third-party license terms. To continue, download the Oracle SE Java Runtime Environment from https://www.oracle.com/technetwork/java/javase/downloads/index.html.
NOTE: On little exploring, found that you can skip this error if you don’t want to use PolyBase feature. You can go back and uncheck highlighted feature to avoid this check.
If you want to use PolyBase then to solve above error, you can follow below steps:
- Go to https://www.oracle.com/technetwork/java/javase/downloads/index.html
- Click on Download on JRE as highlighted below
- Then click on “Accept License Agreement” as shown below
- Once accepted, I have downloaded the one which says Windows x64 because my operating system is windows 64 bit. Note that version (8 update 45) will change in future but steps would remain same.
- After installing, I was able to move forward and install SQL Server 2016.
Hope this helps those trying to install SQL Server 2016 with Polybase features. I am sure you will be able to solve this.
Reference: Pinal Dave (https://blog.sqlauthority.com)