2 SQL Servers in one host - Urgent
627971Mar 11 2008 — edited Apr 23 2008Hi,
I have both SQL2000 and SQL2005 on one machine. I would like to migrate the SQL2005 instances to oracle, thus i have installed sql developer.
When i try to link the Developer to SQL Server, i use windows authentication, hostname='DEV' and Port=1433.
This always points me to the SQL2000. I have named my sql2005 instance 'SQL_2005'. Under the management studio, it is shown as DEV\SQL_2005.
How do i link up to the SQL2005 instance?