2 Replies Latest reply on May 13, 2016 3:09 AM by Andrew Davis

    Scheduled connections to dynamic TCP/IP configured server.

    Andrew Davis

      Hi there,

       

      As the title suggests I'm trying to schedule a regular update to an embedded extract which fails to connect

      to a server that has been configured with a dynamic TCP port address which changes regularly for security reasons.

      Usually the port no for MS SQL server is 1433 but here it can vary due to it's dynamic nature.

       

      The firewall on said server needs to be maintained, obviously if the firewall is taken down then a connection

      is guaranteed.

       

      Is there any graceful way of achieving a connection in theses circumstances?

       

      Thanks

       

      Andrew