Changing Distributor

• cnadler3-1118456

  SSC Enthusiast

  Points: 117

  More actions

  June 22, 2009 at 11:19 am

  #201696

  We have a SQL server that was renamed. Replication was enabled when the server was renamed. When I right click on replication folder and choose publisher properties, the distributor name is the old server. The sql server instance and distributor does not match.

  There is also no distribution database.

  How can I change the name or remove replication from the server and start over?

• Kendal Van Dyke

  SSCertifiable

  Points: 5972

  More actions

  June 25, 2009 at 9:26 am

  #1015381

  Try this:

  sp_dropdistributor @no_checks=1,@ignore_distributor=1

  (Read more on the SP here: http://msdn.microsoft.com/en-us/library/ms173516(SQL.90).aspx)

  Kendal Van Dyke
  http://kendalvandyke.blogspot.com/[/url]