to change the netbios name on a replication server

• abdalah.mehdoini

  Ten Centuries

  Points: 1025

  More actions

  July 18, 2019 at 10:07 am

  #3664082

  Hello everyone

  I have a server in transactional replication

  I have a netbios change request from this server

  the Publisher and Distribution Server are configured on the same server

  what will be the impact of this change on the good functioning of my replication

  must change the logical no of this server through the command

  exec sp drop server servername

  thank you for your advice

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  July 18, 2019 at 6:47 pm

  #3664289

  SQL Server doesn't support the rename when it's involved in replication. You would need to remove the replication, do the rename and add the replication back again using the new server name.

  Sue