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):
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!
did you enable TCP/IP as a protocol in the SQL Server Configuration Manager? If not, try doing so.
Thanks for the quick reply, Adreas.
TCP/IP was enabled, but I found the culprit.
I accidentally had two backslashes in the JNDI URL.
When I removed the extra backslash, everything works :)
Sorry, I'm not sure
Try to specify dynamic TCP port.
See "SQL Server Configuration Manager" -> relevant instance network protocol TCP/IP (MUST be enabled) properties -> dynamic port.
did u try with MYsql then pl send me detail of how to do that. i am getting server not found exception