MS SQL Network Help

[VG008]

Hi,

I have a system which uses both a LAN connection and 3G network card. This network system can't change.
Anyway, MS SQL is using the 3G network to connect to the database, however I require it to connect using the LAN connection.

How can this be done?

Thanks, in advance!

 

[froot]

The easiest way to do this is to add a static route to the database in your routing table and set it to use your LAN connection.

 

[ShaughnK]

Yip. just beat me to it. Add a static route and tell it to use the network connection that you lan is using.

 

[emalherbe]

You can also use the "Sql Server Configuration Manager": Go to "SQL Server Network Configuration/Protocols", double click TCP/IP and disable "Listen All". Then on the "IP Addresses" tab enable and disable the ones you want.