Microsoft JDBC Driver for SQL Server Support Matrix

List of Driver Versions

Microsoft JDBC Driver Support Lifecycle Matrix and Policy

The Microsoft Support Lifecycle (MSL) policy provides transparent, predictable information regarding the support lifecycle of Microsoft products. JDBC driver versions 3.0 and 4.0 have five year Mainstream support from the driver release date. Mainstream support is defined on the Microsoft support lifecycle web site.

Extended and custom support options are not available for the Microsoft JDBC Driver.

Support will end as per the matrix below.

Supported SQL Versions

¹Microsoft SQL Server JDBC Driver version 3.0 can connect to SQL Server 2012 as a down-level client.

²Support for SQL Azure was introduced in the 3.0 driver as a hotfix. We recommend that SQL Azure customers use the latest driver version available.

³Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 can connect to SQL Server 2008 as a down-level client. When down-level conversions are allowed, applications can execute queries and perform updates on the 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 2008 Date/Time Data Types using JDBC Driver and Working with SQL Server 2008 FileStream using JDBC Driver. For more information about the down-level compatibility of these new data types, see Using Date and Time Data and FILESTREAM Support topics in SQL Server Books Online.

⁴Support for connections between the Microsoft JDBC Driver and Parallel Data Warehouse was first introduced in the Microsoft JDBC Driver 4.0 for SQL Server and Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance Update 3.

Java and JDBC Specification Support

¹Support for JRE 1.7 is planned

Supported Operating Systems

The Microsoft JDBC driver is designed to work on any operating system that supports the use of a Java Virtual Machine (JVM). Some commonly used platforms include Windows 8, Windows 7, Windows Server 2008 R2, Windows Vista, Linux, Unix, AIX, MacOS, and others.

The JDBC product team tests our driver on Windows, Sun Solaris, SUSE Linux, and RedHat Linux. Customer Support is available to customers on all platforms, however we may ask you to reproduce the issue on a platform such as Windows.

Application Server Support

The Microsoft JDBC Driver for SQL Server is tested with various application servers. Consult your application server vendor for additional details on which driver version is compatible with their product. Some links are provided below.

• SAP Netweaver – SAP Service Marketplace
• JBoss Application Platform
• Apache TomCat
• IBM Websphere Application Server (WAS) – supported SQL Server versions
(select WAS version, then product, then OS. For example: Version 7.0 -> Base & Network Deployment -> Windows -> scroll down to database section)