I get the following 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.