Specific instances not connecting to DSNs

Question

Very odd issue that has just started with our CF10 environment with 2 of our dev boxes.....I have a box for example that has been configured with 2 instances....dev-app and dev-admin. Randomly both instances will have issues talking to our DSN's , the main coldfusion admin http://localhost/CFIDE/administrator communicates no problem with the same set of DSN's. I have 2 boxes out of 15 acting like this....they are all setup exactly the same in terms of virtulization, firewall, etc

Specific error I receive is

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

I am at a loss why these boxes are suddenly popping up with these DSN timeouts....I have even rebuilt one of the boxes as far as CF goes but still same issue.....it might work again but I can't have it soo flaky.

desispeed · Accepted Answer

This issue was corrected and had nothing to do with ColdFusion in the end , it was related to a networking issue where 2 of the boxes(VM's) were sharing a MAC address. This occurred after I was testing Windows Network Balancing on the boxes, once I removed that component it caused all kinds of weird issues. Once the MAC was changed the DSN issue of course went away.

BKBK · Answer

Your database brand?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded