We are unable to create a data source with JDBC version 2 type for ms sql2005 server.
We had used the following things to create a data source.
XADS Classname: com.microsoft.sqlserver.jdbc.SQLServerXADataSource
In additional we gave the connection string and user name and password.
Created a driver with sqljdbc.jar.
Is there anything other than that we need to do?
The same connection string is working fine for JDBC version 1 type data source.