RE: SQL Linked server over firewall

From: jjstenhouse (anonymous_at_discussions.microsoft.com)
Date: 11/27/03 

Date: Thu, 27 Nov 2003 02:23:28 -0800

Thanks, but...

I have already read this document, and have had port 1024
to 5000 inclusive opened on the remote firewall. NETSTAT
shows that a connection is being made from a random port
to port 1433 on the local machine, but no authentication
attempts are logged. Also last night, I ran a small job
every 20 minutes. The job sucessfully logged in to the
remote server between 6PM and 11PM every 20 minutes, then
failed for the rest of night. The nightly backup started
on this server just after 11PM, and lasted until about
12:30AM. No authentication attempts were logged after
11PM, although the job contuned to run.
The SQL databases are accesed from a web server, which
also uses port 1433 (TCP comms), might they be
conflicting?
I would prefer to use multiprotocol to connect the servers
so I can use enrytption, but when I do, the remote server
attempts to connect on ports 135 and 445, which our
firewall admins are not happy about opening as these ports
have been used by several worms and viruses to replicate.
Can I force multprotocol to use a port of my choosing and
if so, how?

Many thanks

JohnS
>-----Original Message-----
>See the following kb:
>
>287932 INF: TCP Ports Needed for Communication to SQL
Server Through a
>Firewall
>http://support.microsoft.com/?id=287932
>
>
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>

Relevant Pages

  • RE: Remote Web Workplace not completely working.
    ... In order to allow a remote desktop connection to a client computer through ... TS requests through a firewall on TCP port 4125, ... To open the port 4125 on ISA, we can re-run CEICW to confirm it. ... server certificate) and then click Next. ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA Rule for Remote Desktop?
    ... My server has a private IP address on the WAN NIC. ... I've just had an opportunity to try testing Remote Desktop through RWW from ... attempts being made from the logging interface in ISA to port 4125 when I ... There are three connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Kazzaa- spyware
    ... > server, then file retrievals from your machine must be done with the ... >>- Allow all UDP for both direction, for local port 123 and remote port ... > But unfortunately RR is changing the DNS addresses all the time. ...
    (comp.security.firewalls)
  • Re: 1 NIC v. 2 NICS & remote access questions from beginner
    ... a remote user I would recommend using a secure VPN. ... VPN funcionality I`ll tend to use that, ... the firewall for each service to the SBS server. ... >> assigned to its LAN port. ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA Rule for Remote Desktop?
    ... Is the ip that changes a real world ip that your server sees? ... I am asking if your SBS external nic has a private NAT ip like ... IP address) I can now access RWW and use Outlook Web but still can't Remote ... attempts being made from the logging interface in ISA to port 4125 when I ...
    (microsoft.public.windows.server.sbs)