Support Matrix for Microsoft SQL Server JDBC Driver

Dear SQL Server developers and users: In the last few weeks, I have received a number of queries on which driver version is supported with which SQL server version. I have created a support matrix describing the supported configuration. Matrix also lists the dates when we plan to end support for each driver. Driver Name…

4

SQL Server 2005 JDBC Driver and Database Mirroring

We’ve heard from some customers that they are having difficulty getting Database Mirroring to work with our JDBC driver.  Recently, Adam from our counterpart customer service team posted a great blog on this topic.  Please refer to his blog regarding a couple of gotchas with the v1.2 driver. http://blogs.msdn.com/psssql/archive/2008/12/31/sql-2005-jdbc-driver-and-database-mirroring.aspx Jimmy WuSQL Server JDBC Team

2

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.

What is SSL and why is my JDBC driver using it? The v1.2 JDBC driver uses SSL (Secure Sockets Layer) to encrypt connections to SQL Server for improved security.  Where it can, the v1.2 driver ALWAYS uses SSL to encrypt the login to SQL Server.  For integrated auth connections, SSL provides an added layer of…

13

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

On a Windows platform, when trying to connect to SQL Server using Integrated Authentication, you may see this exception:    com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.along with the following trace message:    com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>    WARNING: Failed to load the sqljdbc_auth.dll This generally indicates that the driver can not find the appropriate sqljdbc_auth.dll in the JVM library path.  To…

40

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

If you are seeing this exception while trying to use the SQL Server 2005 JDBC driver, then you will need to update the application. The class name has changed between the SQL Server 2000 JDBC driver and the SQL Server 2005 JDBC driver.  This particular class “com.microsoft.jdbc.sqlserver.SQLServerDriver” is the class name for the SQL Server…

33