How to connect to a sql-server through internet?

Hi,
after I tried it a few times without success, I'm searching for a step by
step guide how I can realize a odbc-connection to a sql-server through the
internet.
In the local Network where the Server is installed the port 1433 is opened,
directed to the server and I know the WAN-IP-Adress and the Name of the
Computer on which the sql-server is installed.
I don't want to establish the connection through vpn. This works, but when I
am connected to the server through vpn I am not able to work in the clients
local Network.
Do I need anything more? - How do I have to go step by step?
thx in advance for your help and ideas why I'm successless in the past
Hubert
Do you have TCP/IP protocol enabled for the SQL Server? Is it
configured to work with port 1433? All this could be done by using SQL
Server Network Utility.
Leonid.
"Hubert Ball" <Hubert@.Lochkarte.com> wrote in message news:<ceflan$ubm$05$1@.news.t-online.com>...
> Hi,
> after I tried it a few times without success, I'm searching for a step by
> step guide how I can realize a odbc-connection to a sql-server through the
> internet.
> In the local Network where the Server is installed the port 1433 is opened,
> directed to the server and I know the WAN-IP-Adress and the Name of the
> Computer on which the sql-server is installed.
> I don't want to establish the connection through vpn. This works, but when I
> am connected to the server through vpn I am not able to work in the clients
> local Network.
> Do I need anything more? - How do I have to go step by step?
> thx in advance for your help and ideas why I'm successless in the past
> Hubert

How to configure udp port in sql ?

Hi friends,
I want to open/publish my sql server 2000 into internet,
for security reason, many articles said that I must close
TCP port 1433 and UDP 1434.
My questions are :
I can change TCP port with others port, how can I change
udp port ?
Thanks.You can't , however if you just have a default instance, it won't make any
difference to block it. If using named instances then you would have to
supply the port when connecting or use an alias set up in the client network
utility (on the client attempting to connect)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kresna Rudy Kurniawan" <anonymous@.discussions.microsoft.com> wrote in
message news:071701c3bdfa$abdd8140$a101280a@.phx.gbl...

quote:

---

> Hi friends,
> I want to open/publish my sql server 2000 into internet,
> for security reason, many articles said that I must close
> TCP port 1433 and UDP 1434.
> My questions are :
> I can change TCP port with others port, how can I change
> udp port ?
> Thanks.

---

|||You don't want to open UDP 1434. If the server is behind ISA, set the
server to use a Fixed port. The clients will have to know the port in
order to connect.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, you can't change the UDP port. It is fixed at UDP 1434. You should
only use this for domain level applications to enumerate what ports SQL
Named Instances are listening on. The server listen-on port can be changed
using the Server Network Utility.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.