Connect to specific TCP/IP endpoint?

Hello All,
I'd read in BOL that it is possible to connect "explicitly" to a
specific TCP/IP endpoint on the server. Does anyone know how to do
this? I can't find an example anywhere.
Thanks in advance.
-KJIn Enterprise manager, when you connect to a new server in a server group
enter the IP address of your server instead of the server's network name. If
your server is behind a firewall, you would have to implement NAT to the
actual server's Internal server's private IP address using port 1433 (the
default). Enter your EXTERNAL IP address as the server's address in the Ent
mgr in this case.
This way you can control a sql server from anywhere, but be aware that you
are opening a dangerous door. You should have a firewall that allows you to
filter the origin of the calls on port 1433 and only allow those requests
that originate from your safe Ip addresses to go through, that means that
your Ip address from which you make the calls should be a fixed IP. (costs
more)
HTH
Bob
"KJ" <n_o_s_p_a__m@.mail.com> wrote in message
news:1151340328.957952.169780@.c74g2000cwc.googlegroups.com...
> Hello All,
> I'd read in BOL that it is possible to connect "explicitly" to a
> specific TCP/IP endpoint on the server. Does anyone know how to do
> this? I can't find an example anywhere.
> Thanks in advance.
> -KJ
>|||I should have stated that I am actually looking for information on
connecting to TCP/IP endpoints (default or user-created) in SQL Server
2005.
Thanks Bob for your reply.
Bob wrote:
> In Enterprise manager, when you connect to a new server in a server group
> enter the IP address of your server instead of the server's network name.
If
> your server is behind a firewall, you would have to implement NAT to the
> actual server's Internal server's private IP address using port 1433 (the
> default). Enter your EXTERNAL IP address as the server's address in the En
t
> mgr in this case.
> This way you can control a sql server from anywhere, but be aware that you
> are opening a dangerous door. You should have a firewall that allows you t
o
> filter the origin of the calls on port 1433 and only allow those requests
> that originate from your safe Ip addresses to go through, that means that
> your Ip address from which you make the calls should be a fixed IP. (costs
> more)
> HTH
> Bob
>
> "KJ" <n_o_s_p_a__m@.mail.com> wrote in message
> news:1151340328.957952.169780@.c74g2000cwc.googlegroups.com...sqlsql