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://126.96.36.199: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.