Here are the connection details again. The server is SQL Server 2008 R2.
TransactionType: LOCAL_TRANSACTION
DataSource Class: com.microsoft.sqlserver.jdbc.SQLServerDataSource
Servername: abcdefgh
port: 2866
user: ABCD
pw: ****
database: test
networkProtocal: TCP
Other Properties: Left blank.
Did not enable: connection Pooling [ I would like to enable after the connection is setup ]
The jar files which are already in place are msbase.jar, msutil.jar, mssqlserver.jar and sqljdbc.jar under /IntegrationServer/packages/WmJDBCAdapter/code/jars/static/
and sl53_cj34.jar under IntegrationServer/lib/jars/.
But I still get the same error as above. Can someone let me know what might be missing. Is it the login credentials or any jar file missing?