SQL Server 2012 Transactional replication

  • Hi experts,

    I have two standalone sql instances on same domain with named instances and they are listening on 2 different static ports.

    pubserver on xyz domain with instance INST01 listening on 1433

    subserver on xyz domain with instance INST01 listening on 61433

    Need following configuration in replication:-

    subserver\inst01 will act as distributor and it will have our subscription DB as well.

    pubserver\inst01 will be having publication and pointing to distributor on subserver\inst01.

    I am having problem in defining distributor followed by defining publication.

    I enabled named pipes and shared memory on pubserver and subserver and able to configure distributor on subserver where I was able to connect on SSMS without using port 61433 but later when I went to pubserver\inst01 and tried to configure publication.When I am selecting distributor for subserver\inst01 on port 61433 then following error is coming:-

    ===================================

    Cannot connect to subserver\INST01,61433.

    ===================================

    SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'subserver\INST01'. (Replication.Utilities)

    ------------------------------

    Program Location:

    at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.CheckServerAlias(ServerConnection conn)

    at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.ValidateConnection(UIConnectionInfo connInfo, IServerType server)

    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

    I have tried using alias but nothing happening.

    All firewall rules are also OK for SQL ports and able to connect both instances from both the servers.

    Regards

    Bipsy

  • To add on this..

    select @@servername showing me exact instance name followed by exact hostname.

    Regards,

    Bipsy

  • Try this:

    select name, data_source

    from sys.servers

    where server_id = 0

    Are both columns equal to each other and equal to @@servername?

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

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