I need to replicate some tables that are in a database that is part of an always-on group. When I try using the AG listener name it gives the the error..
SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'ServerName1'. (Replication.Utilities)
So if I use the name of the primary node it will work, but then what happens when it fails over to ServerName2? How can I get around this?
This is on SQL 2012 Enterprise Edition.
Thank you!
Jim