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
Posted Wednesday, May 27, 2015 1:45 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 30, 2015 10:42 PM
Points: 199, Visits: 222
Though the question is pretty old, but to help someone in this situation, check if the SQL Server Browser service is running on the subscriber. If not then start the service.
If the publisher and subscribers are separated by a firewall, then you'll need to have firewall open not just for subscriber's TCP port, but also for UDP port 1434 for Browser service.

Cheers,
Fahim




Fahim Ahmed
Knowledge is a journey, not a destiny
Post #1688955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse