Connecting to a remote SQL Server

Is there anyway of connecting to a remote SQL Server other than via a
VPN.
The remote SQL Server has a connection to the internet via a firewall
which has a static public IP Address.
Thanks
LCAre the firewall ports open? If they are, you can just
connect using the IP address. Check the following article:
INF: TCP Ports Needed for Communication to SQL Server
Through a Firewall
http://support.microsoft.com/?id=287932
-Sue
On Tue, 22 Mar 2005 22:20:59 -0000, LJC
<lyndoncushing@.mediascene.co.uk> wrote:

>Is there anyway of connecting to a remote SQL Server other than via a
>VPN.
>The remote SQL Server has a connection to the internet via a firewall
>which has a static public IP Address.
>Thanks
>LC|||Thanks that was a great help
LC
In article <m9m1411a6u8hgvt015d4aonjt9di39r3l7@.4ax.com>,
Sue_H@.nomail.please says...
> Are the firewall ports open? If they are, you can just
> connect using the IP address. Check the following article:
> INF: TCP Ports Needed for Communication to SQL Server
> Through a Firewall
> http://support.microsoft.com/?id=287932
> -Sue
> On Tue, 22 Mar 2005 22:20:59 -0000, LJC
> <lyndoncushing@.mediascene.co.uk> wrote:
>
>