Failure to Create DNS to SQL Server?
When I try to create a DNS to connect to a SQL Server Database (2014), I get a failure:
Connection verification failed for data source: soundings
java.sql.SQLNonTransientConnectionException: [macromedia][SQLServer JDBC Driver]The connection to the host HOMEBIZ, named instance SQLEXPRESS (local) has failed. Error: "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've tried various ways to resolve this problem:
1) I created rules to allow the requisite ports through the Firewall (Norton).
2) I've run netstat - ano to get info on the ports:
TCP: [: :]:61223 HOMEBIZ:0 Listening PID: 4048
TCP: 0.0.0.0:61223 HOMEBIZ:0 Listening PID: 4048
(This PID does correspond to the running SQL Server)
UDP: [: :]:1434 *:* PID: 6076
UDP: 0.0.0.0:1434 *:* PID: 6076
(This PID does correspond to the running SQLBrowser)
I've gone into the ODBC DataSources (both 64 and 32 bit and have created DSNs to the database: when testing during the creation, I get a "successful" report -- So it is possible to reach the Database Server.
I've got this set up with Mixed Authenication -- so I'm not adding a username or password when creating the DNS (but I've tested it with and without: no difference)
I've looked for ways to set up some sort of connection string in Cold Fusion to try to connect outside the ColdFusion DNS but I've not been successful in finding the right instructions for doing that test.
