Issue on Replication

Murali Gvr
Murali Gvr used Ask the Experts™
on
Hi,
Please help me to resolve the issue on Replication. While doing the replication between 2014 to 2012, screenshot attached.

I tried to add server as actual server name as Local, but the message showing as already exists.

Is there any other approach.

Regards
Murali
Repl.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jason clarkDBA Freelancer

Commented:

Commented:
Check the server name is sys.servers system view.

You have two options:

Option 1. change the server name in replication setup which is showing in sys.servers
                 
select * from sys.servers where server_id=0 

Open in new window


Option 2. Change the server in system table using below command.

commands:
select * from sys.servers where server_id=0

sp_dropserver <Server Name which is showing in result>
go
sp_addserver <Server Name by which you connect the SQL instance>, LOCAL
go

Open in new window

Murali GvrAssistant Manager

Author

Commented:
Thanks Deepak,

 I tried as same as your steps. But i faced same issue. Actually my requirement is 2014 server is subscriber and 2012 is publisher. As of now I tried to fix the issue, but never get to succeed.

Regards
Murali
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
Distributor is local or Remote?  

Well... can you try by creating the aliase of subscriber at publisher server.
Murali GvrAssistant Manager

Author

Commented:
Distributor is Local.

Actually Publisher is Local server(2012 Standard)  and Subscriber (2014 Standard) which is Cloud Server(AWS). I used to change the actual server name as 'es' server name. Even I tried to Replication from Local(2012) to AWS(2012) using same procedure it's working on good condition. Please help me how to fix this issue.

Regards
Murali

Commented:
for which server you are getting connection error "can not connect to "SUbscriber" or Publisher\Distributor"

Have you checked the local server name.
SELECT SERVERPROPERTY(N'<servername>')
SELECT @@SERVERNAME

also check the server name and network name.
sp_helpserver

Are you able to connect all instance in ssms by the name which you are using in replication?
Murali GvrAssistant Manager

Author

Commented:
Yes both servers are using on their PublicIP. If we may not used to do Replication, its throwing error. That's why I used to connect using PublicIP.

Commented:
Ok. Try by creating Aliase in SQl server configuration manager at publisher server.
Murali GvrAssistant Manager

Author

Commented:
If create aliase in configuration manager, that it may not effect to server right?
Commented:
Right no impact on the server.
Murali GvrAssistant Manager

Author

Commented:
Deepak,

 As per your advise I did to change the server name and I finished on replication. Thanks for your support

Regards
Murali

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial