[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
The server version is not supported

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

The server version is not supported.


Applies to: Microsoft SQL Server 2008 R2, Linux Red Hat, Oracle
 

Problem Description.
 

We have a stored procedure on a Oracle server that we run as a cron on Linux. From there we run a stored procedure on a SQL Server instance. The cron was running successfully for a SQL Server 2005 instance, but started to fail when we upgraded the SQL Server instance to SQL Server 2008 R2. The JDBC connection was throwing the following error:

Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.
Caused by: 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(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:240)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.core.support.JdbcDaoSupport.getConnection(JdbcDaoSupport.java:119)
...
XXXXX Job Finished ------------- /


Solution.

When we downloaded and installed Microsoft SQL Server JDBC Driver 3.0 from the following link, the cron ran successfully.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=21599


We followed these instructions to install the driver:

Installation Instructions for the UNIX version of the JDBC Driver

1. Download sqljdbc_<version>_<language&.tar.gz to a temporary directory.

2. To unpack the zipped tar file, navigate to the directory where you want the driver unpacked and type gzip -d sqljdbc_<version>_<language>.tar.gz.

3. To unpack the tar file, move it to the directory where you want the driver installed and type tar –xf sqljdbc_<version>_<language>.tar.

4. After the package unpacks, open the JDBC Help System by opening %InstallationDirectory%/Microsoft SQL Server JDBC Driver 3.0/sqljdbc_<version>/<language>/help/default.htm. This will display the help system in your default Web browser.
 



 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.