How to Connect to a SQL Server thru a firewall

Hi, Guru,
I have a SQL Server running behind a firewall. I also have a client
installed on my local machine. How should I configure the client to
connect to the server? What port do I need to ask the network/security
admin to open on the firewall? All installation on the server and on the
client are default. I am not familiar with SQL Server, but I have some
common sense. What should I put in the "Server Alias"? The IP of the SQL
Server? What if I run a named instance on the server. Any special
configuration I need to do on Client Network Utility?
If you could show me step by step, it would be great. If you can point me
to some online reference, it will be also great.
Any of you help is appreciated.
ChopinThe default sql server tcp port is 1433. So if you have to connect to a
server behind a firewall, you have to ask the network team to open this
port. To make sure it's working you can run the following command from the
client machine:
telnet servername_or_ip 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>|||try this
http://support.microsoft.com/defaul...kb;en-us;287932
Br,
Mark.
"Chopin Hu" <huchopin@.yahoo.com> wrote in message
news:ux7cmyGAEHA.3452@.TK2MSFTNGP11.phx.gbl...
> Hi, Guru,
> I have a SQL Server running behind a firewall. I also have a client
> installed on my local machine. How should I configure the client to
> connect to the server? What port do I need to ask the network/security
> admin to open on the firewall? All installation on the server and on the
> client are default. I am not familiar with SQL Server, but I have some
> common sense. What should I put in the "Server Alias"? The IP of the
SQL
> Server? What if I run a named instance on the server. Any special
> configuration I need to do on Client Network Utility?
> If you could show me step by step, it would be great. If you can point
me
> to some online reference, it will be also great.
> Any of you help is appreciated.
> Chopin
>sql