How are they installed, both as default, or as specific instances. As both run on the same port, you wouldn't be able to have them both installed as a default instance. One would need to be installed as a named instance or listen on a port other than 1433.
Snake -----Original Message----- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: 11 July 2006 21:58 To: CF-Talk Subject: Connect CFMX 7.2 to SQL 2000 and SQL 2005 on the same box 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:246198 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
