Ok, we recently switched to running MS SQL 2005 servers in an Active/Passive cluster on Win2003 (64Bit). While we were testing we had no issues with DB access. After migrating most of our databases to the SQL 2005 Cluster we are not getting the same error a few times a day that crashes our whole CFMX application (which is running behind a load balancer across three CFMX servers.
The error we see is this: (note: az_tar is a valid name of a DB) Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "az_tar" requested by the login. The login failed. Date: 09/05/2007 Time: 06:16:08 The login permissions are set right and have not changed from the previous server to this server cluster. Also, the logins work most of the day without an issue then all of a sudden for reasons unknown to us this error pops up across most or all the databases on this server. We found a MS JDBC driver (Microsoft SQL Server 2005 JDBC Driver 1.1) that they state "In its continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server 2005." My questions are: Has anyone see this issue before? And if so, what was the problem/solution? Has anyone tried this MS JDBC Driver and what were your results? Thank You, Wil Genovese ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
