Post reply

SQL Server replication requires the actual server name

  • May 19, 2010 at 7:13 pm

    #222716

    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.

  • May 27, 2015 at 1:45 am

    #1800772

    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


    [font="Tahoma"]Fahim Ahmed[/font]
    [font="Times New Roman"]Knowledge is a journey, not a destiny [/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply