[jboss-user] [JNDI and Naming] - JBOSS 4.2.2 and MS SQL 2005

Hi there, I just installed JBOSS 4.2.2 and I want to use MS SQL 2005. So this is what I did: 1. Deleted JBOSS_HOME/server/default/deploy/hsqldb-ds.xml 2. Copied JBOSS_HOME/docs/examples/jca/mssql-ds.xml to JBOSS_HOME/server/default/deploy. 3. In the new copy of mssql-ds.xml, I edit the connection-url, user-name and password elements to match my local SQL db instance. 4. Changed the value of the jndi-name element from MSSQLDS to DefaultDS 5. Deleted the file JBOSS_HOME/server/default/deploy/jms/hsqldb-jdbc2-service.xml. 6. Copied JBOSS_HOME/docs/examples/jms/mssql-jdbc2-service.xml into the folder JBOSS_HOME/server/default/deploy/jms 7. In the new copy of mssql-jdbc2-service.xml, I replaced the string MSSQLDS with DefaultDS 8. I copied the MSSQL JDBC driver sqljdbc.jar to JBOSS_HOME/server/default/lib. When I start JBOSS I get the following error: 2009-09-03 16:59:34,609 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.microsoft.sqlserver.jdbc.SQLServerDriver, url: jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=systinetdb) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)... Do you have any suggestion? Thanks Maurizio View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4253404#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...