[jboss-user] [Datasource Configuration] - Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver.

Roger Lee [https://community.jboss.org/people/NOTiFY] created the discussion "Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver." To view the discussion, visit: https://community.jboss.org/message/735357#735357 -------------------------------------------------------------- I using JBoss AS 6.1.0 Final and running using the JRE 6 included with jdk1.6.0_32. I need to connect to a MS SQL 2008 database and have downloaded the latest Microsoft JDBC drivers contained in sqljdbc_4.0.2206.100_enu.exe. I have copied sqljdbc4.jar to the default\lib folder and configure my DS etc. When my App tries to connect to the MS SQL database I get; 12:32:53,064 WARNING [SQLServerConnection] ConnectionID:1 ClientConnectionId: a0955e8d-226a-44e6-b8f8-b0217cd3cf47 Server major version:8 is not supported by this driver. 12:32:53,080 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server version 8 is not supported by this driver. ClientConnectionId:a0955e8d-226a-44e6-b8f8-b0217cd3cf47) A couple of posts said it was due to a bug in a previous JRE and upgrading to 32 woul resolve it. Any ideas? TIA. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/735357#735357] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]