Highlighted

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

Participant ,
Jan 25, 2017

Copy link to clipboard

Copied

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.

Views

676

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Participant ,
Jan 25, 2017

Copy link to clipboard

Copied

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.

Views

677

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 25, 2017 0
BKBK LATEST
Adobe Community Professional ,
Feb 07, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 07, 2017 0