ColdFusion · Database exception

Timed Out Trying To Establish A Connection

What does Timed Out Trying To Establish A Connection mean in ColdFusion?

After a ColdFusion service restart or server reboot, a trusted-connection SQL Server DSN can fail to reconnect while other datasources (Oracle, for example) on the same instance work fine — the DSN's cached connection state doesn't refresh cleanly through the restart. Deleting and recreating the exact same DSN definition is often the only thing that clears it.

Timed Out Trying To Establish A ConnectionAdobe ColdFusion

Condition

After a ColdFusion service restart or server reboot, a trusted-connection SQL Server DSN can fail to reconnect while other datasources (Oracle, for example) on the same instance work fine — the DSN's cached connection state doesn't refresh cleanly through the restart. Deleting and recreating the exact same DSN definition is often the only thing that clears it.

Fix

If a specific DSN starts timing out only after a restart, delete and recreate it rather than just re-verifying, and confirm it's using ColdFusion's built-in driver (macromedia.jdbc.MacromediaDriver) rather than a third-party JDBC jar that may not reinitialize the same way.

Pending source verification. Not yet checked against official documentation.

Related database exception