I'm using JBoss 4.0.2 and have recently installed SQL Server 2005 (Express). However, I get the following exception:
| 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 refused: connect) | I tried changing the JNDI to specify the instance name (the only way I can successfully connect to the database without JNDI): | jdbc:sqlserver://myserver\\SQLEXPRESS;DatabaseName=MyDatabase | However, this results in a different exception: | org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.) | I have successfully connected via JDBC (without JNDI) with the instance name, so I'm assuming that the problem lies in how I'm using the JNDI descriptor. Has anyone else successfully setup a JNDI using the instance name nomenclature? If I must specify the port number, then is there a configuration change I must make to SQL Server to allow direct port connections? Any help would be greatly appreciated! -Trey View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3920776#3920776 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3920776 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
