SQL Server Performance Forum – Threads Archive

SQL Server replication + name changing

Hi all, We currently have two servers replicating using merge replication.
We changed the workstation name of one of the computers and the replication is no more valid. Does someone know a way to make it work again without reinitializing the replication ?

If the servername is changes then ensure you’ve used to drop and recreate the server using SP_DROPSERVER and SP_ADDSERVER. In order to take the new servername the replication must be re-initialized. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

In fact, the SQL Server didn’t change only the computer name did

If you chance the servername (Windows name) of the machine then you should also affect the same name to SQL server also by using above SPs. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Does that mean that in any case, the replication must be reinitialized ?

Yes ofcourse. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for your answers

]]>