Wednesday, July 4, 2012

Replicatioin Configuration Problem Error -- SQL Server is unable to connect to server (Configure Distribution Wizard)


sp_helpserver
--SELECT @@ServerName

you will see error servename like,
--WIN08R2-666 WIN08R2-666--rpc,rpc out,use remote collation 0   NULL 0 0

sp_dropserver 'WIN08R2-666'
--to remove it and

sp_addserver 'WIN08R2-342', 'LOCAL'
--add the server name.

No comments: