Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Changing Replication

Author  Topic 

Ex
Posting Yak Master

166 Posts

Posted - 2006-04-10 : 19:51:43
Hi all,

Not to sure how to do this one,

Have replication setup on a develoment box. The box got shiped to clients and the clients decided to change the name of the computers. Which stuffed up our replication.

Can someone help me on how i can change the replication to match the new name. Cant seem to get it to work and dont want to have to recreate the replication if it can be avoided

------------------------------------------------------------------

sp2 for IE is FIREFOX !!

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-04-11 : 05:51:28
Script it out and change anywhere the servername appears to the new name, then run it on the box..
Go to Top of Page

Tazz602
Starting Member

11 Posts

Posted - 2006-04-19 : 09:55:44
If you want a "quick and dirty" - add a server alias in the client configuration with the old server name but pointing to the new server IP\instance. Will also make it easier to change if they decide to change it again, which if they did it once, they will do it again.
Go to Top of Page
   

- Advertisement -