I'm thinking this got lost in yesterday's backlog. Does anyone have any clues on this?
-- Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. Wil Genovese wrote: > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
