SQL Server communication over a firewall

[Barry G.]

I've got a client machine on the outside of a firewall trying to
communicate with a server on the other side of a firewall. I tried
searching the Microsoft knowledge base, but it didn't help much.

I need to know how to set up the client and the server to listen on a
specific port. If anyone has any information, it would be greatly
appreciated.

Thanks in advance.

----------------------------------------------------------------------------------------
Barry Gast
bga...@nycap.rr.com

[Syed Rehan Ahmed]

Barry,

If you have installed the TCP/IP protocol on the SQL Server. Then at the
clinet site you can go the SQL Server Client Configuration Utility and then
go to the Advanced tab. In the Client Configuration tab choose the Server
name or put it by yourself, in the DLL Name pick TCP/IP Sockets and in the
connection string put in the IP address of the Server. Hopefully this will
allow you to connect through the TCP/IP.

--

------------------
Syed

Barry G. wrote in message <3703ce41...@news.appliedtheory.com>...