Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server replication requires the actual server name Expand / Collapse
Author
Message
Posted Wednesday, May 19, 2010 7:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 21, 2011 11:20 AM
Points: 17, Visits: 96
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.
Post #924767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse