Adobe Community: Message List - Specific instances not connecting to DSNs

Re: Specific instances not connecting to DSNs

forums_noreply@adobe.com — Mon, 21 Jul 2014 14:53:52 GMT

Quite interesting. Thanks for sharing it with us. Please mark your post as the 'correct' answer.

Re: Specific instances not connecting to DSNs

forums_noreply@adobe.com — Mon, 21 Jul 2014 14:40:11 GMT

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.

Re: Specific instances not connecting to DSNs

forums_noreply@adobe.com — Sat, 19 Jul 2014 13:34:33 GMT

Your database brand?

Specific instances not connecting to DSNs

forums_noreply@adobe.com — Fri, 18 Jul 2014 16:03:09 GMT

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.