SQL Linked server over firewall

From: jjstenhouse (john.stenhouse.nospamthanks_at_tuht.scot.nhs.uk)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 07:32:48 -0800

I have a server in one town behind a firewall, and another
in another town behind another firewall. I've set up a
linkes server on server1 connecting to server2, with the
relevant ports open on the firewalls (1433 inbound on the
local firewall (no outbound blocking), 1024 - 5000 in and
out on the remote firewall. However, when I try to make
the linked server connection to the local server, a Server
Doesn't Exist or Access Denied error appears. Using a
port montor, I can see that a connection is being made
from the remote server to port 1433 on the local server,
but the local server seems not to respond. The remote
firewall administrators can see no traffic from the local
to remote server. This is using TCP/IP. If I use
multiprotocol, the remote server tries sending on ports
135 and 445. Ideally, I want a Linked Server on 1433, or
any high number port. Can anyone help?

Relevant Pages

  • Re: How to Maintain an IIS Server?
    ... > server running on a Windows 2000 server. ... before a firewall and antivirus have been installed]. ... open ports; however, this will not identify which program is using the port. ...
    (microsoft.public.inetserver.iis.security)
  • Re: CEICW fails at firewall config
    ... ISA Server prevents connection to a remote desktop when you connect through ... Remote Web Workplace on a Windows Small Business Server 2003-based computer ... Acceleration Server as a firewall. ... connection uses TCP port 4125. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Maintain an IIS Server?
    ... >> server running on a Windows 2000 server. ... > before a firewall and antivirus have been installed]. ... > program or executable using that port. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Activesync / Airsync - Alternative Ports
    ... Setup a reverse HTTP proxy. ... Another idea is to use the PPTP capabilities of a Windows Server to allow ... Satellite - Cisco Firewall - Exchange Server ... So on the server side you would configure the port 80 to redirect to ...
    (microsoft.public.pocketpc.activesync)
  • Re: Activesync / Airsync - Alternative Ports
    ... "Chris De Herrera" wrote: ... Another idea is to use the PPTP capabilities of a Windows Server to allow ... Satellite - Cisco Firewall - Exchange Server ... So on the server side you would configure the port 80 to redirect to 8888 ...
    (microsoft.public.pocketpc.activesync)