HI
I am trying to set SQL serve replication between two different datacenters.
Source:'XXAMSVDB01\DCOINTAUTH1'
Destination:'XXATLVDB01\DCOINTAUTH2'
Both are running on port 1113.
I am able to connect 'XXATLVDB01\DCOINTAUTH2' from 'XXAMSVDB01\DCOINTAUTH1' using 'XXATLVDB01\DCOINTAUTH2,1113'
But while creating the subscription in transactional replication it is throwing me an error:
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'XXAMSVDB01\DCOINTAUTH1'
Any Idea why this is happening? I tried creating the allias but that did not work for me.