At the moment, we have SQL2000 Standard Edition running as the only
instance (it is a named instance) on the server, with one of the two
NICs disabled. If we enable the second NIC, and then create a SQL2005
named instance, will both named instances listen on both NICs by
default, and will the SQL2005 instance automatically select a port to
listen on that does not conflict with SQL2000? The NICs would be
independent, not "teamed".

Thanks
JD

Yes, you can enable the second NIC.

Yes, By default both SQL Servers will listen on both ports (after enabling
network access vi SQL Configuration manager on the 2005 instance.) You can
force SQL 2005 to only listen on specific NICs.

By default, named instances will not use conlicting ports. You can force
each instance to a particular port. For SQL 2005, this can be a different
port for each NIC.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"JohnD" <JohnD (AT) belltolls (DOT) org> wrote