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 to allow the use of the Windows credentials to authenticate the user.
This feature is available only when Replication Agent
for Microsoft SQL Server is running on Windows 2000 or Windows 2003
and requires Microsoft SQL Server 2000 SP 3 (or later) or Microsoft
SQL Server 2005.
To use Windows authentication
In your primary Microsoft SQL Server, add the <ra_user> as a Windows-authenticated user, including the user's domain as appropriate. Be sure to add the <ra_user> to the primary database and grant the appropriate permissions. For additional information, refer to the Microsoft SQL Server documentation.
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.
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 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.
On the same machine, login as the <ra_user> and start the Replication Agent for Microsoft SQL Server instance.
Log into RepAgent and configure the following parameters using values appropriate for the primary 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
Continue configuring and using Replication Agent as described in Replication Agent documentation.
