Hi, I have a dev box that was running CFMX 7.2 and SQL 2000 very well until this morning. Then, I installed SQL 2005 Express and after a lot of trial and error I was finally able to restore a database previously backed up in SQL 2000 and restore it to SQL 2005 and connect from cfmx Admin to the new db in SQL 2005, but now the connection to the SQL 2000 fails with the message: Connection verification failed for data source: db_name java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'.
I haven't change anything on the SQL 2000 server instance. I can connect to the db using Enterprise Manager and other tools. The db allows mix authentication and the user id and password are valid. Is it possible to connect CFMX 7.2 to SQL 2000 and SQL 2005 all of them on the same box? If yes how? Any pointers greatly appreciated. Thx Victor ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246191 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
