Dave and Snake, I think you are right and it's the port number as I have set up SQL 2005 to listen to 1433. Can I just change the port number for SQL 2005 to another unused number (like 1444?)
Thx PS Yes, Rick you are right it's 7.02. On 7/11/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > 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? > > Yes, you can connect CFMX 7.0.2 to SQL Server 2000 and 2005 instances on > the > same box. Each instance should have its own IP listener on a unique port. > I > suspect that SQL Server 2005 is now listening on the port you were > previously using for SQL Server 2000. You should be able to find out > what's > listening on what ports by running the command "netstat -ab". I don't know > enough about Express specifically to know whether it has the same network > management interface as SQL Server 2005 Standard or Enterprise. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:246204 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
