Access to a remote SQL server through ISA server

From: Ramiro Barreca (rbarreca_at_datamasters.com.ar)
Date: 11/14/03 

Date: Fri, 14 Nov 2003 06:11:04 -0800

We are having problems when trying to browse a remote SQL Server from any PC in our LAN through our ISA Server.

At Enterprise Manager we can register, connect, open the databases list, database objects, but when trying to display the list of tables, it hags up or report the remote server has close the connection.
Even when we try to run any DTS package from our internal server to this remote one, or execute the Replication to this remote suscriber appears an error saying the remote server does not exist or its connection has been refused.

We have created the rules "ANY -> 1433" and "1433 -> ANY" in the ISA as Microsoft recomended in one of its articles, but the problem persists.

When DO it work?
If we try the same through a modem outside the ISA server, it works fine (low but fine).

Relevant Pages

  • Re: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Access and ISA Server in SBS 2003?
    ... I am glad to hear the Remote Access Wizard is working fine now. ... there is no difference in VPN between SBS 4.5 and SBS ... Error Message: VPN Connection Error 800: Unable to Establish Connection ... the external NIC of the SBS Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote Office Configuration Suggestions?
    ... Welcome to SBS newsgroup. ... I understand that you want to keep the remote office continue working even ... after the main internet connection on the main office is not available. ... If you want to join the remote server to a SBS domain and become a member ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ... > Connection Manager to connect to the VPN server and gain access to a shared ...
    (microsoft.public.windows.server.sbs)