Using Windows Authentication with Microsoft SQL Server

When running Replication Agent for Microsoft SQL Server on a Windows platform, you have the option of configuring it to connect to Microsoft SQL Server using Windows credentials to authenticate the user.

To configure Replication Agent to use Windows authentication:

  1. In your primary Microsoft SQL Server, add the user who will be starting Replication Agent, <ra_user>, as a Windows-authenticated user, including the user domain as appropriate. Add the <ra_user> to the primary database and grant the appropriate permissions. For additional information, see the Microsoft SQL Server documentation.
  2. On the machine on which the Replication Agent for Microsoft SQL Server is running, add <domain>\<ra_user> to the Windows user account. If no domain exists, add only the <ra_user> to the Windows user account.
  3. On the same machine, copy the sqljdbc_auth.dll file from the Microsoft SQL Server JDBC driver location to a directory on the Windows system path. When you installed the Microsoft SQL Server JDBC driver, the sqljdbc_auth.dll files were installed in this location:
    <install_dir>\sqljdbc_<version>\<language>\auth\
    Note: On a 32-bit processor, use the sqljdbc_auth.dll file in the x86 folder. On a 64-bit processor, use the sqljdbc_auth.dll file in the x64 folder.
  4. On the same machine, login as the <ra_user> and start the Replication Agent for Microsoft SQL Server instance.
  5. Log in to Replication Agent and configure these parameters using values appropriate for the primary Microsoft SQL Server: 
    ra_config pds_server_name, <server> 
ra_config pds_port_number, <port>
ra_config pds_database_name, <database>
ra_config pds_username, <ra_user>
ra_config pds_integrated_security, true
  6. Continue configuring and using Replication Agent as described in Replication Agent documentation.
Parent topic: Replication Agent for Microsoft SQL Server