"SQLServerException: The connection to the host mydbhost, named instance \myinstance failed." in JBoss EAP
Issue
- Datasource connection URL defined as
jdbc:sqlserver://mydbhost\\myinstance;... -
Encountering the error below when attempting to obtain a connection from the database
... com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host mydbhost, named instance \myinstance failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
Environment
- Red Hat JBoss Enterprise Application Platform (EAP) 7
- Microsoft SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
