Could not create connection in JBoss

[blakeyu]

In my jboss server, I incur cannot create connection problem, the database server was working well, anybody has experience on it?

I used Jboss 3.2.3 and MS SQL Server 2000.

Here is my error message of Jboss.

16:13:01,656 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Network error IOException: Connection timed out: connect); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Network error IOException: Connection timed out: connect))

Thanks in advance.

[blakeyu]

Btw, can I set connection property in my datasource file like as
<connection property name="autoReconnect">true</connection property>

I found a way for MYSQL for autoReconnect when can't connect to db like as "//192.168.0.2:1433/testdb?autoReconnect=true", is any similar way to autoreconnect in MSSQL 2000 also?