I tried to connect sql 2005 database with
JBOSS 4.0.3sp1 server,in ds.xml file i mentioned connection url,driver class.
<connection-url>
jdbc:sqlserver://3.109.105.219:1433;DatabaseName=MMOffshore;
</connection-url>
<driver-class>
com.microsoft.sqlserver.jdbc.SQLServerDriver
</driver-class>
i kept sqljdbc.jar in class path and enabled TCP\IP port number 1433 also in sql server.
after setting all these i tried to start my JBOSS server.
it is giving error..not able to connect db..
org.jboss.resource.connectionmanager.InternalManagedConnectionPool:getConnection:232 Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect)
can any one help..where is problem..where to change.
Thanks,
Anji