Microsoft SQL Server JDBC driver Support matrix

This page contains support matrices and support lifecycle policies for the Microsoft SQL Server JDBC driver.

Microsoft JDBC driver supports life cycle matrices and policies

The Microsoft Support life cycle (MSL) policy provides predictable, transparent information about the support life cycle of Microsoft products. The JDBC driver version 3.0, 4.x, 6.x, and 7.x have five years of mainstream support since the date the driver was released. Mainstream support is defined on the Microsoft support life cycle site.

The Microsoft JDBC driver does not provide extended and custom support options.

The following Microsoft JDBC drivers are supported until the specified support end date.

driver name	Driver package Version	applicable JAR (s)	Mainstream Support ends
Microsoft JDBC Driver 7.0 for SQL Server	7.0	Mssql-jdbc-7.0.0.jre10.jar Mssql-jdbc-7.0.0.jre8.jar	July 31, 2023
Microsoft JDBC Driver 6.4 for SQL Server	6.4	Mssql-jdbc-6.4.0.jre9.jar Mssql-jdbc-6.4.0.jre8.jar Mssql-jdbc-6.4.0.jre7.jar	February 27, 2023
Microsoft JDBC Driver 6.2 for SQL Server	6.2	MSSQL JDBC 6.2.2.jre8.jar Mssql-6.2.2.jre7.jar	June 30, 2022
Microsoft JDBC Driver 6.0 for SQL Server	6.0	Sqljdbc42.jar Sqljdbc41.jar	July 14, 2021
Microsoft SQL Server JDBC driver 4.2	4.2	Sqljdbc42.jar Sqljdbc41.jar	August 24, 2020
Microsoft SQL Server JDBC driver 4.1	4.1	Sqljdbc41.jar	December 12, 2019

The following Microsoft JDBC drivers are no longer supported.

driver name	Driver package Version	Mainstream Support ends
Microsoft JDBC Driver 4.0 for SQL Server	4.0	March 6, 2017
Microsoft SQL Server JDBC Driver 3.0	3.0	April 23, 2015
Microsoft SQL Server JDBC Driver 2.0	2.0	December 31, 2012
Microsoft SQL Server 2005 JDBC Driver 1.2	1.2	June 25, 2011
Microsoft SQL Server 2005 JDBC driver 1.1	1.1	June 25, 2011
Microsoft SQL Server 2005 JDBC Driver 1.0	1.0	June 25, 2011
Microsoft SQL Server # JDBC Driver	2000	July 9, 2010

SQL version Compatibility

driver version	sql Server 2008	sql Server 2008R2	sql Server	azure SQL Database	PDW 2008R2 AU34	sql Server	sql server	sql Server	Span data-ttu-id= "de00e-179" >azure SQL Managed instance (extended personal preview)
6.4	no		Yes	is	Yes	Yes	Yes	Yes
6.2	Yes		Yes	is	Yes	Yes	Yes	Yes	no
6.1	Yes		Yes	is	Yes	Yes	Yes	no	no
6.0	Yes		Yes	is	Yes	Yes	Yes	no	no
4.2	Yes		Yes	is	Yes	Yes	Yes	no	no
4.1	Yes		Yes	is	Yes	Yes	Yes	no	no
4.0	Yes		Yes	is	Yes	Yes	Yes	no	no
3.0	Yes		Yes 1	is 2	no	Yes 5	no	no	no
2.0	Yes 3	is 3	no	no	no	No	no	no	no
1.2	Yes 3	no	no	no	no	No	no	no	no
1.1	no	no	no	no	no	No	no	no	no
1.0	no	no	no	no	no	No	no	no	no
2000	Whether	Whether	Whether	Whether	Whether	Whether	Whether	Whether	Whether

The 1Microsoft SQL Server JDBC Driver version 3.0 can be used as a subordinate client to connect to SQL Server 2012.

23.0 support for Azure SQL Database was introduced as a patch in the driver. It is recommended that Azure SQL Database customers use the latest driver version.

The 3Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 can be connected to SQL Server 2008 as a subordinate client. When subordinate conversions are allowed, applications can perform queries and updates on new SQL Server 2008 data types, such as time, date, datetime2, DateTimeOffset, and FILESTREAM. For more information about how to use these new data types with the JDBC driver, see Working with SQL Server date/time data Types using JDBC Driver (using the JDBC driver to process S  QL Server 2008 Date/Time data type) and working with SQL Server FileStream using JDBC Driver (using the JDBC driver to process SQL Server 2008 file streams). For more information about the subordinate compatibility of these new data types, see the Using date and time data in SQL Server Books Online (using date-and-times information) and the FILESTREAM support (file stream supported) topic.

4Microsoft SQL Server JDBC Driver 4.0 and Microsoft SQL Server R2 parallel Data Warehouse Device Update 3 first introduced the connection support between the Microsoft JDBC driver and the parallel Data Warehouse.

The 5Microsoft SQL Server JDBC Driver version 3.0 can be used as a subordinate client to connect to SQL Server 2014.

Java and JDBC specification support

JDBC driver Version	JRE version	JDBC API Version
7.0	1.8, 10	4.2, 4.3 (part)
6.4	1.7, 1.8, 9	4.1, 4.2, 4.3 (part)
6.2	1.7, 1.8	4.1, 4.2
6.1	1.7, 1.8	4.1, 4.2
6.0	1.7, 1.8	4.1, 4.2
4.2	1.7, 1.8	4.1, 4.2
4.1	1.7	4.0
4.0	1.5, 1.6, 1.7	3.0, 4.0
3.0	1.5, 1.6,	3.0, 4.0
2.0	1.5, 1.6	3.0, 4.0
1.2	1.4, 1.5, 1.6	3.0
1.1	1.4	3.0
1.0	1.4	3.0
2000	1.4	3.0

Supported operating Systems

The Microsoft JDBC driver can work on any operating system that supports the use of a Java virtual machine (JVM). Some common platforms include Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server R2, Windows Vista, Linux, Unix, AIX, MacOS, and more.

The JDBC product team tested the drivers on Windows, Sun Solaris, SUSE Linux, and RedHat Linux. customer support is available on all platforms, but we may ask you to reproduce the problem on a platform such as Windows.

Application Server Support

The Microsoft SQL Server JDBC driver was tested against various application servers. check with the application server vendor for additional details about the version of the driver that is compatible with its product.

Microsoft SQL Server JDBC driver Support matrix