I get the following error:
Error:
Cannot create PoolableConnectionFactory (The connection to the host localhost, named instance SQLEXPRESS has failed. Error: “java.net.SocketTimeoutException: Receive timed out”. Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.)
I left the default instance name of SQLEXPRESS. I am using jdbc:sqlserver://localhost\SQLEXPRESS as the Connect URL. I am using the default “sa” account for the login with the password that I created.
I have enabled the TCP/IP protocol, started the SQL Server Browser service, and made sure that “Allow Remote Connections” is checked. I have Windows Firewall turned off.
It seems that I have everything set up correctly according to the information that I could find but it is not working so I must have missed something.
You might try running “netstat -a” from the command line and verify that UDP 1434 is listening. Your first method of specifying the instance was correct, so either TCP/IP isn’t fully enabled, or something is blocking it.
I recently had this problem using SQL Server 2008 R2. Besides above: ensuring the firewall ports are open (both hardware and software firewalls), SQL Server Browser is running, SQL Server Instance allows Remote Connections, and SQL Server TCP/IP is enabled, I had to do the following to get the remote connection to work:
In the SQL Server TCP/IP Properties, explicitly set the TCP Port to 1433 and TCP Dynamic Ports to blank under IPAll section
In Ignition Database Connection Properties Connect URL, explicitly supply the port number. ie. “jdbc:sqlserver://<InstanceName>:1433”
[quote=“chris”]I recently had this problem using SQL Server 2008 R2. Besides above: ensuring the firewall ports are open (both hardware and software firewalls), SQL Server Browser is running, SQL Server Instance allows Remote Connections, and SQL Server TCP/IP is enabled, I had to do the following to get the remote connection to work:
In the SQL Server TCP/IP Properties, explicitly set the TCP Port to 1433 and TCP Dynamic Ports to blank under IPAll section
In Ignition Database Connection Properties Connect URL, explicitly supply the port number. ie. “jdbc:sqlserver://<InstanceName>:1433”
Hope this helps.[/quote]
This solved my problems after getting a “port 49565 has failed” timeout. Deleted port 49565 from the TCP Dynamic Ports and added port 1433 to the TCP Port and got the “Valid” status. We were connecting to SQL Server Express 2014 that was installed on top of SQL Server Express 2008.
FWIW, I came up against an error similar to this, and the issue was that the IP addresses within the TCP/IP properties were set to Disabled. I enabled the localhost one (and the others just in case) and it started working.