Java com.microsoft.sqlserver.jdbc.SQLServerException: 不支持服务器版本。目标服务器必须是 SQL Server 2000 或更高版本

com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later

提问by Manan Adani

I am trying to connect SQL Server 2008 Express Edition using JDBC. I have included SQLServer Driver 3.0 (sqljdbc.jar) and I am using JDK 1.5.

我正在尝试使用 JDBC 连接 SQL Server 2008 Express Edition。我已经包含了 SQLServer Driver 3.0 (sqljdbc.jar) 并且我使用的是 JDK 1.5。

Below are my code snippet:

下面是我的代码片段：

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con = DriverManager.getConnection("jdbc:sqlserver://10.54.10.190:1433;databaseName=SADB_database", "user", "password");

I am getting below exception:

com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)
    at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)

Please help any one. Thanks in advance

请帮助任何人。提前致谢

回答by Obl Tobl

Try to update your driver to Version 4. Version 3.0 is very old.
Alternatively you can use jTDSJDBC Driver. This is a third-party driver but supports much more versions of Microsoft SQLServer.

尝试将您的驱动程序更新到版本 4。3.0 版本已经很老了。
或者，您可以使用jTDSJDBC 驱动程序。这是第三方驱动程序，但支持更多版本的 Microsoft SQLServer。

回答by Aymen Touzi

This works for me after upgrading to Microsoft JDBC Drivers version 4.0

升级到 Microsoft JDBC 驱动程序 4.0 版后，这对我有用