Skip to main content
Inspiring
Mar 26, 2015 10:24 PM UTC
Answered

Connection verification failed for data source on port 1433

Trying to set up a DSN for a SQL Server database on a new computer and it's failing every time.

Connection verification failed for data source: csf

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: SANDYPC:1433. Reason: Connection refused: connect

The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: SANDYPC:1433. Reason: Connection refused: connect

Now, when I installed CF 11, it installed on port 8500.  However, when I try changing the port in the setup to 8500, I get this error:

  • Connection verification failed for data source: csf
    java.sql.SQLException: Timed out trying to establish connection
    The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I cannot find anything online on how to fix this!  HELP!!! 

    This topic is closed to new replies. Start a new post to keep the conversation going.
    carl type3Correct answer
    Legend
    Mar 27, 2015 1:41 AM UTC

    Hi,

    Is that SQL Express edition? If so perhaps TCP protocol is not enabled. Is Windows firewall turned on? Check port 1433 is open.

    Normally you would not create a datasource to apache port 8500, that is a web server not database server port.

    HTH, Carl.

    1 reply

    carl type3Correct answer
    Legend
    Mar 27, 2015 1:41 AM UTC

    Hi,

    Is that SQL Express edition? If so perhaps TCP protocol is not enabled. Is Windows firewall turned on? Check port 1433 is open.

    Normally you would not create a datasource to apache port 8500, that is a web server not database server port.

    HTH, Carl.

    Translate