Re: two NICs, SQL2000 and SQL2005 on the same machine

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@xxxxxxxxxxxxx> wrote in message news:evxhjRdgHHA.2368@xxxxxxxxxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: SBS 1002 Premium R2 Mangling Port Issues
    ... If you have a decent hardware firewall/router now, ISA ... NIC or 2 NICs) did you finally end up with? ... the WAN NIC so there's only one NIC in the SBS (and then re-run CEICW ... port forward 8016 to the "external" SBS NIC IP ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 1002 Premium R2 Mangling Port Issues
    ... The ADT remote camera view is working ... configure SBS), or you can configure SBS to use both NICs and then re-run ... If choose two NICS, the WAN NIC and the LAN side of the router must ... + Now forward the port 8016 traffic from the external SBS NIC to the LAN ...
    (microsoft.public.windows.server.sbs)
  • Re: Desperate to email; Can you HELP?
    ... so are their two dual port NICs? ... Ethernet adapter Local Area Connection: ... Connection-specific DNS Suffix. ...
    (microsoft.public.windows.server.sbs)
  • Re: CEICW failure
    ... The port forward thing I had tried just out of desperation. ... The router is 192.168.1.1 subnet 255.255.255.0 ... > port 80 from the Internet to your Server. ... >> SBS box has the 2 NICs. ...
    (microsoft.public.windows.server.sbs)
  • Re: DNS, Group Policy errors when enabling second NIC
    ... You're running Sharepoint Portal Server inside your SBS domain and exposing it to the "world"? ... You won't find anyone here supporting the opening of port 80 being passed inside the LAN...huge security hole ... to try putting Sharepoint on port 80 locally, using the second NICs IP ... Unless this one of those unique load balancing nics that has software so ...
    (microsoft.public.windows.server.sbs)