Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL listening on 2 networkadresses

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-02 : 07:26:13
Mark writes "Hello,

We have a server running on W2000/SQL2000 and we have installed a second networdcard into it.
Now we want SQL Server to listen for requests on both network cards.
Is this possible and if so, how ??

Thanks, Mark."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-02 : 11:53:08
Each instance will only listen on one IP address and port. The server will listen on both cards, but SQL Server will not. I'm sure though that if you had two instances installed that you could configure each instance so that it listens on a different card.

Tara
Go to Top of Page
   

- Advertisement -