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
Thanks Pinal, very helpful as always :)
Dear Dave
i thank you very much
your guidance was realy helpful for me!
Sincerely yours
Ali Sakhaei
Excellent summary, thank you. I always find the oracle download site so confusing!
It helps too much. Thanks!
Great, Excuse me not Great, but marvelous.
muy bueno
Thanks …. it was helpful…
you are great..
VERY USEFUL
This fix doesn’t seem to be working for SQL Server 2017 developer edition installation on Windows 10. I’ve both latest JAVA SDK as well as JRE installed on my box but this check still fails. I’ve 64 bit java version 9.0.1. Still the rule keeps failing.
@Raski – 1. Uninstall the Java version 9.0.1
2. Install Java version JRE 8u152 through below link and it allows to run the Polybase installation smoothly.
https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html
I had the same issue as @Rasik. Following your instructions has allowed the SQL Server 2016 setup to recognize the JRE installation and continue. Thank you for the resolution, Fahad!
Hi Fahad,
Thanks for the link that resolve the JRE issue for sql server 2016. I was facing same challenges as Raski and resolved now.
Thank you JRE-8 worked for me. JRE-7 was no longer available from Oracle
Thanks a lot.
Thank man! cool
Thanks u very much!
Glad that it worked.
thank you
My pleasure.
Thanks for this helpful info
Welcome!
Thanks you very much…
Thanks Mitul. I am glad that its helping many folks.
IS SO GOOD
Thanks. Glad it is helping.
You are amazing!!!
Thanks Nicolas.
Thanks! It`s working!
Thanks a lot Ana.
Thanks Dave!
Your welcome Timo!