From SQL Server Source to DE Agent for SQL Server

To secure connections from the SQL Server source database to DE Agent for SQL Server,

  1. Request a certificate from a trusted Certificate Authority (CA).

  2. Install this certificate on the source SQL Server and configure SQL Server to enable encryption.

  3. On the machine where you have installed DE Agent for SQL Server,

    • install the same certificate you used for the source SQL Server instance in the Current User or Local Machine certificate store.

    • install the certificate chain of the Certificate Authority in the Trusted Root Certification Authorities.

  4. In DDW, while loading the SQL Server schema, provide the full SQL Server instance name.

  5. In Administration Site, while starting BDT or CDT, turn on Secure Connection in the General Settings tab. For more details, refer to Data Exchange Runtime Administration and Operations Help.