Multiple NIC's in SQL - SQL Server Forums

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)

Multiple NIC's in SQL

Author

Topic

grc1uk
Starting Member

4 Posts

Posted - 2007-03-21 : 05:51:28

Hi

I have been trying to connect to my SQL server from a remote server which is connected via a VPN. The problem is that when i TELNET to the SQL server i get a server does not exist error.
I think i have come accross the issue in hand. The server that we are
trying to connect to is in a cluster, that is not the issue. The issue is
that the server has 3 network cards.
NIC one - 10.0.0.13
NIC two - 192.168.0.98
NIC three - 172.16.0.42

SQL is currecntly listening on NIC two 192.168.0.98 but we are connecting on
the other network card which is on the 10.0.0.13 range. How, within SQL can
i change which NIC SQL is associted with?

can someone shed some light on this one for me

thanks

Gareth Collins

Thanks

Gareth Collins

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-03-21 : 06:00:05

Configure your client network utility (for TCP/IP library) to listen to desired IP address.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

grc1uk
Starting Member

4 Posts

Posted - 2007-03-21 : 09:25:37

Hi

thanks for the reply

can you let me know how this is done, when i go in to the Cleint Network Utility, i can not see where i edit the TCP/IP Library

thanks

Gareth Collins

Thanks

Gareth Collins

grc1uk
Starting Member

4 Posts

Posted - 2007-03-22 : 04:46:54

Just to let you know that this has been resolved.

Needed to re-run the SQL server setup and then put the additional IP address in the settings.

This has been done and tested and works fine

thanks for you help

Thanks

Gareth Collins

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources