Connection verification failed for data source on port 1433

[ssailer]

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!!! 

[carl type3 · Accepted solution]

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.