How to connect to remote SQL server through IP address : LUSENET : SQL Server Database Administration : One Thread

Hi all I have to connect to a remote SQL server through IP address.

Thanks Jay

-- Anonymous, July 24, 2000



Basically, you need to tell your SQL server how to translate the IP Address to a server name, then use the server name.

The Internet uses only TCP/IP, so you need to run TCP/IP on your clients and the server. You need to be able to PING and PING from your local clients. The firewall must be configured to allow your SQL traffic through. To provide name resolution you need to put an entry in your local HOSTS file or DNS/WINS server. Then use this name in your connection string.

Hope this helps,


-- Anonymous, July 24, 2000

Moderation questions? read the FAQ