CF 9 MSSQL DB Connection loss after service restart
We have 9 servers running almost identical applications, they all pull data from one database server (Connections are internal).
We also have services on CF restarting nightly around 4am on all the servers.
On one of our servers occasionally the resart will cause the database connections to hopelessly break, we get the following CF errors constantly until we restart the entire server, at which point it works just fine.
[Macromedia][SQLServer JDBC Driver]Object has been closed.
[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
It seems the database is rejecting the connections to the newly restarted services. I can't glean anything from CF logs other than the above. The database logs dont seem to say anything either (Admittedly not an expert). Does anyone have any ideas as to what could possibly be causing this?
Application Server Specs:
CF9 64 bit
| Server Details | |
| Server Product | ColdFusion |
| Version | 9,0,0,251028 |
| Edition | Standard |
| Serial Number | XXXXXXXXXXXXXXXXXXXXXX |
| Operating System | Windows Server 2008 |
| OS Version | 6.0 |
| Adobe Driver Version | 4.0 (Build 0005) |
| JVM Details | |
| Java Version | 1.6.0_14 |
| Java Vendor | Sun Microsystems Inc. |
| Java Vendor URL | http://java.sun.com/ |
Datbase Server Specs:
Windows Server 2008 64bit, Microsoft SQL Server 2008
AdChoices