Manage SQL server accross WAN?

Hi,
Has anyone had any experience managing a SQL 2000 server behind a a locked
down router? I have to move a SQL server into a secure DMZ and give access
to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
this allow SQL management using Enterprise Manager installed on the remote
client?
Thanks in advance.....Yes, however, i suggest that you either setup the terminal service and
connect remotely through the terminal service client to the server. it
is more secure. you could also do a port forwarding using SSH. This
could be done by setting up the SSH server on the server that you
install SQL server and on the client use a ssh client, setup the port
forwarding to map to 1433 or any other port your sqlserver is running
on. in this setup (via SSH), you usually have to configure in your
client network utility an alias to the server and port. it is far more
secure and faster to do it this way. reason being that a. terminal
service does not send the actual data across the line b. ssh allow
compression to be done on the packet sent over the line and c. both
support data encryption.|||I do this all the time, typically via a VPN solution to the network. If
this is not an option then the following KB article will help.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mostro" <mostro@.nospam.com> wrote in message
news:KaKdnRNK5J5KzhveRVn-gg@.adelphia.com...
> Hi,
> Has anyone had any experience managing a SQL 2000 server behind a a locked
> down router? I have to move a SQL server into a secure DMZ and give access
> to it from an internal netework. If I open TCP port 1433 and UDP 1434 will
> this allow SQL management using Enterprise Manager installed on the remote
> client?
> Thanks in advance.....
>