DTS and firewall

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mark (markjones_at_n0Sp8mTAIRAWHITIdotAC.NZ)
Date: 05/12/04 

Date: Thu, 13 May 2004 10:37:43 +1200

Hi all, I have some DTS packages that are used to import /export data to a
SQL box located outside in a DMZ behind a firewall.

We need to open up a port in the firewall so that the Internal Server can
communicate (Execute DTS packages against) with the SQL box located outside
the DMZ.

How do I find out what Port we need to open so that the Internal SQL box can
communicate with the external SQL box?

Thanks in advance
Mark

Relevant Pages

  • Re: cluster connection issue
    ... You will need to allow connections from each physical public NIC back through the firewall. ... Principal SQL Infrastructure Consultant ... We have an application running on an NLB cluster in the DMZ. ...
    (microsoft.public.sqlserver.clustering)
  • Can not connect to SQL Server from DMZ
    ... access SQL server that is behind the firewall. ... server from the server in DMZ and we also checked and confirmed port ...
    (microsoft.public.sqlserver.security)
  • Re: newbie Frage zu Server-Explorer - Datenverbindungen
    ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: ActiveX script works in DTS but not in job, why?
    ... Account that SQL Agent runs under and it is a Local Admin on the box. ... As another test I saved the script as a .vbs file and tried running it, ... Microsoft OLE DB Provider for SQL Server ... that would be since I need to be able to load DTS packages from either a SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: [fw-wiz] I wonder, how to test..
    ... secure as possible for your type of organization. ... of the how locked the web server is or if the SQL machine is in the DMZ. ... laptop and perform network scans with scanners like Nessus. ...
    (Firewall-Wizards)