Connecting to SBS SQL via Remote VPN (VB Application)

12 Jan 2006 3:21 PM

TIM

Hi,

Dont really know if this is the place to ask but here goes....

I have written a VB application that talks to various SQL2000 Tables. But i
need to expand the VB App to work on a laptop thats remotely connected by VPN.

Even though the laptop is connected via VPN and can use server applications
it cannot see the SQL server??? and produces (can find it errors).

Is there anything i need to do to the sql server to allow outside
connections or to the ISA firewall etc etc.

Any help will be appreciated.

Regards
TIM

12 Jan 2006 3:53 PM

JT

If you know that your VPN connection is working correctly, then next try
connecting to the database server using it's IP and port as the data source:
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer

If that doesn't work, then speak with your DBA and/or network admin. Perhaps
the following is relevent to your situation:

How To Use ADO to Connect to a SQL Server That Is Behind a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269882
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q287932

Show quote

"TIM" <T**@discussions.microsoft.com> wrote in message
news:C10D5F9D-F628-4B57-9EF3-707C9E621DA9@microsoft.com...
> Hi,
>
> Dont really know if this is the place to ask but here goes....
>
> I have written a VB application that talks to various SQL2000 Tables. But
> i
> need to expand the VB App to work on a laptop thats remotely connected by
> VPN.
>
> Even though the laptop is connected via VPN and can use server
> applications
> it cannot see the SQL server??? and produces (can find it errors).
>
> Is there anything i need to do to the sql server to allow outside
> connections or to the ISA firewall etc etc.
>
> Any help will be appreciated.
>
> Regards
> TIM