Rick254474202qw9

Participant

Question

Enable to connect to mssql to test failover

4 replies
458 views
Translate

I have a db connection( xxxdev2) on a UAT server.

I am trying to setup a duplicate db( xxxdev2b) opn my local server to test db failover if the primary server goes down.

For some reason, I connot get the connection working in the coldfusion Datasource section.

I can login in to the server using sql studio, but I get the following error on the datsopurce page of CF.

"Connection verification failed for data source: xxxdev2b
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: LAPTOP-Rick:1433. Reason: Connection refused: connect"

This topic is closed to new replies. Start a new post to keep the conversation going.

Community Expert

Community Expert

When you use a hostname or machine name, the connection will use your machine's "real" IP address. Instead, use localhost or 127.0.0.1 for your connection.

Dave Watts, Eidolon LLC

Translate

Dave Watts, Eidolon LLC

Rick254474202qw9Author

Participant

Thank you for the response. I tried both those ideas previously, and niether worked. JUst for fun I tried it again and same result, still not connecting.

Translate

Community Expert

Community Expert

In that case, you have a different problem! If you set up MS SQL Server locally, it probably won't accept connections over TCP/IP, so you'll have to enable that in the SQL Server Configuration Manager.

https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16

Dave Watts, Eidolon LLC

Translate

Dave Watts, Eidolon LLC