Java Language Extensions in SQL Server 2019 by Prashanth Jayaram recommends downloading the Zulu Builds of OpenJDK. This is the Java release installed by the Microsoft SQL Server 2019 Setup.
We originally set this up to run on our SQLExpress edition, but later changed to the developer edition as we are developing application triggers to send an email to various users when certain tables are changed. The process is the same regardless of the edition.
The Java 8 (LTS) version at the time of this writing is 8u27b17 (Zulu 184.108.40.206). The ZULU site claims “Oracle Java SE and Zulu OpenJDK function identically. We downloaded the latest Zulu JDK 15.28 (15.0.1) – 64 bit version for Windows.
Note: By default, SQL Server installs Zulu Open JRE (Java Runtime Environment) version 11.0.3. It is also possible to install the full JDK (Java Development Kit) for compilers and/or any other Java distribution.
Note the default location for the Zulu installation for Windows is typically c:\program files\zulu\zulu-15\. This can be changed to any directory, just note the location where the installation occurs. In our case, we decided to use drive D:\Zulu-15\ as it has more storage space.
After clicking “Next”, allow the installer to make changes to your system.
A window appears requiring you to allow the app to make changes to your system. After clicking “Yes”, an installation progress window appears.
When the installation is complete, click the Finish button in the window as pictured below:
Now, we need to either add or modify the PATH variable so our new Java installation can be found.
Open a command terminal and test your Java installation. Type “java -version” at the command prompt and you should see a message returning the applicable version information:
How to Install PolyBase on Windows
Polybase can only be installed on ONE instance of SQL Server. The installer will warn you to remove a previous instance if one is already set up. Removing the Polybase feature is a relatively simple process.
How to remove Polybase from a previous instance of SQL Server
Removing the Polybase feature from another instance of SQL Server is not intuitively obvious in Windows 10.
From the Tool Bar Search, type Add or Remove programs and select the applicable app (System Settings).
In the “Apps & features” section, use the search feature to find Microsoft SQL Server 20xx (xx-bit). Click on the applicable version as installed on your system, then click uninstall.
Click “Yes” to allow the app to make changes to your system.
Click on the Remove option and continue to select the options you wish to remove from the instance you choose.
The Setup Window appears and you will note that it is set to REMOVE features from the existing set up. In this case, selecting Polybase will cause it to be removed from the instance requested.
Restart your computer to affect the changes made and proceed to either modify an existing instance or install a new instance of SQL Server.
You can now run the SQL Server 2019 Setup and follow through the dialogue options accordingly.
If you are adding to an existing instance, ensure that the directory matches that of currently installed features or you will receive an error window as show below.
Click the Install button to continue with the installation. After a few minutes the following screen will appear:
Related Articles and Resources
Java Language Extensions in SQL Server 2019 by Prashanth Jayaram describes the installation process for SQL Server 2019 with the Java language extension.
SQL Beginner to Guru: MySQL Edition – Master SQL with MySQL (Video) – Packt Publishing.
How to Configure Database Mail in SQL Server by Bojan Petrovic, (22-Nov-2017).