Using Windows authentication with the Microsoft SQL Server JDBC driver

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

To use Windows Authentication

1. In your primary Microsoft SQL Server, add the <ra_user> as a Windows-authenticated login, including the user's domain as appropriate.

   Be sure to also add the <ra_user> to the primary database and grantappropriate permissions. For details, refer to your 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, then add only <ra_user> to the Windows user account.

3. On the machine on which the Replication Agent for Microsoft SQL Server is running, 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 the following location: <install_dir>\sqljdbc_<version>\<language>\auth\

   

   • 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. Log in as the <ra_user> on to the machine on which Replication Agent for Microsoft SQL Server will be running and start the Replication Agent for Microsoft SQL Server instance.

5. Log in to Replication Agent and configure the connectivity properties described previously (in step #5); however, you can omit pds_password.

6. Configure the Replication Agent property, pds_integrated_security

   to "true" (default is “false”). For example:

    ra_config pds_integrated_security, true
   

7. Continue with other Replication Agent configuration as described in the Replication Agent Administration Guide.