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 .
—————————
OK
—————————
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
- 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)
96 Comments. Leave new
April of 2018 and your post is still relevant and helpful. Thanks very much!
this is very helpful
Thanks for this post. It helped me to solve the issue.
I got same error after install the JDK also. Why is that? Anyway I unticked the polybase and installed.
even i installed the jre, i am getting same error. can any one solve my problem?
Thanks for your help, it served me well
Cheers !!! This resolved the issue for me
Issue Resolved for me .!! Thanks a ton
I not only installed the latest version of JRE (10, by the time of my writing), but also created the JAVA_HOME system variable and modified the Path variable in order to get sure that JRE is widely available in the system.
I was able to verify everything by running `java -version` from anywhere in the cmd and having it working. Also, writing `path` allowed me to clearly see the path to jre/bin directory. Notwithstanding, your solution didn’t work.
Saves me lots of Hours trying to figure out this error.. Thanks a bunch!!
tks bro
thanks!
Thank you very much
Thank you very much !
Awesome thanks a lot ….. i need your account number …..lol
Thanks. This helped.
thanks its work for me
November 2019, and you still saved my day!
Thanks. Saved me time :)
Thanks Pinal. It’s really helps rather than installing JRE which I don’t need in my application. Cheers!