Will, I'm struggling against the very same thing at present. Did you ever figure out the problem?
> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
