Changing distributor server name

• leomar

  Old Hand

  Points: 362

  More actions

  September 7, 2007 at 12:44 pm

  #92732

  My company is going to change all server names. Is there some problem with the SQL Servers that are Subscribers? Look like replication works with hostnames instead IP. How can I handle this problem with less pain?

  Thanks.

  Best regards,

  Leomar

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 7, 2007 at 3:23 pm

  #732277

  I have not found an easy way out of that one

  Sorry for the bad news.

  
  * Noel

• leomar

  Old Hand

  Points: 362

  More actions

  September 8, 2007 at 9:53 am

  #732331

  So it's better not to change the server names???

• Erik Bitemo

  SSCrazy

  Points: 2062

  More actions

  September 11, 2007 at 2:48 am

  #732701

  Hi,

  Are they pull or push subscriptions?

  In general you can change quite easily the publisher/distributor server name if it's the same. Use sp_addserver and sp_dropserver and modify the distribution agent jobs. In addition, you should check the distribution database if the old name disappeared. If not, you should change it as well.

  Basically, it's a lot of hacking, so test it before production use. I have no test server at hand to give you a step-by-step instructions, if you need one, I might do it

   

  -- Erik http://blog.rollback.hu