Download and Install SQL Server JDBC Driver

This section provides a tutorial example on how to download and install the SQL Server JDBC driver from Microsoft Website.

Since I am running JVM 13 which is not officially supported yet by Microsoft, so I downloaded the latest version, 7.4, of the SQL Server JDBC driver to try it out.

1. Go to "Microsoft JDBC Driver 7.4 for SQL Server" page at

2. Select "English" as the language and click "Download". And save the downloaded file as sqljdbc_7.4.1.0_enu.tar.gz

3. Unzip and untar the downloaded file:

herong$ gunzip sqljdbc_7.4.1.0_enu.tar.gz
herong$ tar -xf sqljdbc_7.4.1.0_enu.tar

4. Verify JDBC driver jar files:

herong$ ls -l sqljdbc_7.4/enu/

     136 Jan  2 19:03 auth
    1178 Aug  3 05:49 install.txt
    8806 Aug  3 05:49 license.txt
13001033 Aug  3 05:49 mssql-jdbc-7.4.1.jre11-shaded.jar
 1219373 Aug  3 05:49 mssql-jdbc-7.4.1.jre11.jar
13001069 Aug  3 05:49 mssql-jdbc-7.4.1.jre12-shaded.jar
 1219384 Aug  3 05:49 mssql-jdbc-7.4.1.jre12.jar
12991268 Aug  3 05:49 mssql-jdbc-7.4.1.jre8-shaded.jar
 1209659 Aug  3 05:49 mssql-jdbc-7.4.1.jre8.jar
   15377 Aug  3 05:49 release.txt
     374 Jan  2 19:03 samples
   12563 Aug  3 05:49 thirdpartynotices.txt
     170 Jan  2 19:03 xa

5. Create the "WEB-INF/lib" and install the JRE 12 version. Make sure them have "read" permissions for all users.

herong$ mkdir /Library/Tomcat/apache-tomcat-9.0.26/webapps/herong/WEB-INF/lib

herong$ cp sqljdbc_7.4/enu/mssql-jdbc-7.4.1.jre12.jar \

See the next tutorial on how to create a Java program to test the JDBC driver with my SQL Server database.

Table of Contents

 About This Book

 JSP (JavaServer Pages) Overview

 Tomcat Installation on Windows Systems

 JSP Scripting Elements

 Java Servlet Introduction

 JSP Implicit Objects

 Syntax of JSP Pages and JSP Documents

 JSP Application Session

 Managing Cookies in JSP Pages

 JavaBean Objects and "useBean" Action Elements

 Managing HTTP Response Header Lines

 Non-ASCII Characters Support in JSP Pages

 Performance of JSP Pages

 EL (Expression Language)

 Overview of JSTL (JSP Standard Tag Libraries)

 JSTL Core Library

 JSP Custom Tags

 JSP Java Tag Interface

 Custom Tag Attributes

 Multiple Tags Working Together

 File Upload Test Application

 Using Tomcat on CentOS Systems

 Using Tomcat on macOS Systems

Connecting to SQL Server from Servlet

 SQL Server Connection Requirements

Download and Install SQL Server JDBC Driver

 Test SQL Server JDBC Driver

 Use JDBC Driver in Servlet

 Load JDBC Driver Class in Servlet

 Developing Web Applications with Servlet

 Archived Tutorials


 Full Version in PDF/EPUB