At the beginning of October, the SQL Server 2017 was officially released. A few days later after the official announcement I wanted to install it in my virtual environment to take a look at newest features. During SQL Server 2017 installation I faced “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” error and I was not able to proceed.
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://go.microsoft.com/fwlink/?LinkId=526030.
It is a known error since SQL Server 2016 introduced Polybase feature. If you don’t want to use Polybase you can easily fix it by unchecking the proper checkbox in Feature Selection window.
That will reduce the number of rules to check.
However, I wanted to install Polybase so I had to install Oracle JRE. According to the error message, it needs to be JRE 7 Update 51 or newer. Currently, the newest available version is JRE 9.0.1 and can be downloaded here: http://www.oracle.com/technetwork/java/javase/downloads/jre9-downloads-3848532.html. Installation is very easy.
Java Runtime Environment 9 was installed and is visible in system.
To my huge surprise, it didn’t help.
To solve this issue I decided to install JRE version 8.
It solved my problem.
Summary
Apparently, there is a bug in SQL Server 2017 installer. Because of it, the installer doesn’t recognize JRE 9. Fortunately, there is a very simple workaround. To install Polybase you have to install JRE 8. This will pass all checks and you will be able to continue with your installation.
If you found it annoying then you can upvote this connect item: https://connect.microsoft.com/SQLServer/Feedback/Details/3141825
EDIT:
Connect was moved to Azur User Voice. Here you can find migrated connect item: https://feedback.azure.com/forums/908035-sql-server/suggestions/32899312-sql-server-2017-installer-should-recognize-java-jd
-Marek
Share it:
A bit late on this, so some links on this and other articles no longer work. And some updates don’t seem to be still available. Anyway, I was having this problem installing Polybase on SQL 2016 and received the error. Knowing nothing about Java, I didn’t know what I was looking for and was struggling to progress. I installed a JDK, which didn’t work, then thankfully found this article.
Eventually went to https://www.java.com/en/download/ and simply clicked on “Download Java”, which downloaded jre-8u371-windows-x64.exe. I installed this, which allowed the Polybase install to succeed.
Thanks Marek.
Thanks it will help me out
Thank you.
Thank you Mr. Marek Maśko .
I had both 32 bit and 64 bit installed and enabled. I had to disable 32 bit from the Java applet in control panel to get past this validation error
Genuinely when someone doesn’t be aware of after that its up to other users that they will
assist, so here it happens.
Good post. I learn something new and challenging on websites I stumbleupon every day.
It’s always interesting to read content from other authors and
use a little something from their web sites.
Which java version required for SQL server 2017?
As described in the post Summary you need to have JRE 7 or 8 to install SQL Server 2017 RTM. JRE 9 is not recognized by installer and installation fails.
It worked
Thanks, On installing version 8, I am also now able to install SQL.?
Thanks again
Super Awesome!!!
– Thanks Bro, I’ve spend over 4 hours on looking work around for this installation until I found your Blog. I appreciate the help.
Installed 1.8.0_171-b11 on my windows 10 box (and no other versions of Java) and the SQL installer couldn’t identify it.
Thank you. It really works; just take update 144 (maybe anotherone), 171 doesn´t work for this solution
Enormous thank you
Thank you! I installed Java 9 JDK, didn’t work, tried JRE 9 didn’t work.. didn’t think to try 8 JRE, totally works.
U r hero
Microsoft has migrated SQL Server Connect to Azure User Voice: https://feedback.azure.com/forums/908035-sql-server. I tried to search for your connect item but was unable to find it. If you can find the User Voice item would you please post and I will certainly upvote it.
That’s a good point! I was able to find this bug report. Here is the link: https://feedback.azure.com/forums/908035-sql-server/suggestions/32899312-sql-server-2017-installer-should-recognize-java-jd
It’s fine.
Thanks a lot.
Very nice blog post. I definitely appreciate this website. Thanks!
thank you