Life Interesting Bit
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment