July 28, 2014 at 8:38 am
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
July 28, 2014 at 3:24 pm
To add on this..
select @@servername showing me exact instance name followed by exact hostname.
Regards,
Bipsy
July 29, 2014 at 12:44 pm
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