If you have initialized Replication Agent for the first time, have subsequently de-initialized Replication Agent using pdb_xlog remove, and want to re-initialize this Replication Agent instance or another Replication Agent instance for a different database in the same primary data server, use the following procedure.
Subsequently initializing Replication Agent instances
Determine the primary Microsoft SQL Server DAC port number, and make sure Microsoft SQL Server is configured to allow a remote DAC:
sp_configure 'remote admin connections', 1
GO
RECONFIGURE
GO
To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, you must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.
Log in to your Replication Agent, and set the pds_dac_port_number configuration parameter.
Configure the following Replication Agent connectivity parameters for the Microsoft SQL Server primary database:
pds_server_name
pds_database_name
pds_username
pds_password
For information about these configuration parameters, see the Replication Agent Installation Guide and Replication Agent Reference Manual.
Verify that Replication Agent can connect to the primary database:
test_connection PDS
Initialize the Microsoft SQL Server data server and Replication Agent:
pdb_xlog init
