PROBLEM setup CF11 and Local SQL Server Connections (SQLSERVER 2014)

Question

I've spent 2 days trying to set up a ColdFusion dsn in the cf admin.

Is there some trick to this??

Using CF11 / SQL SERVER 2014

I have tried windows authentication and SQL authentication

I've opened pipes and ports

I've tried regular SQL dsn

I've tried other : JDBC driver connection

Here is the latest error message

Connection verification failed for data source: testdsn
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The connection to the host PAT-2016, named instance SQL2014 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.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The connection to the host PAT-2016, named instance SQL2014 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.

BKBK · Answer

Forget about Coldfusion for a moment. What happens when you attempt to log into the database server directly? Which settings work?

When you succeed, take the working settings back to the ColdFusion Administrator and register them as the datasource.

Sign up