Adding a target instance for remote apply in an AlwaysOn availability group

Adding an instance of the CDC Replication Engine for Microsoft SQL Server to a database that is remote from any of the servers in the AlwaysOn availability group follows the customary procedure for creating new instances.

Before you begin

• If you are installing CDC Replication as a target on a server that is different from your database server, you must specify UNC format for a shared directory on your database server. For example, \\databaseservername\mysharedirectory. CDC Replication requires write privileges for this directory and SQL Server requires read privileges.
• Configure CDC Replication to run under an account that has network access privileges.
• Configure the AlwaysOn listener name and port as host and port. Use the same information that was used when the AlwaysOn availability group was created.
• Ensure that the CDC Replication user ID is present on all nodes where the availability group might fail over.
• Ensure that the refresh loader path is present on all nodes where CDC Replication might fail over. This path also has to be symmetrically available on the host where CDC Replication is installed. The requirements for the refresh loader path are similar to those for remote apply in non-AlwaysOn deployment.