Renaming Linked Server

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 17, 2005 at 1:48 am

  #86494

  Hello!

  Does anyone know how to change the Name of a linked server without dropping and recreating it? I.e changing name without loosing all the associated login mappings?

  Problem: Server name change and atleast 20 SQL Servers with Linked Servers (with everything from 1 to 50 Login Mapping) pointing to the old name...

   

  Hanslindgren

• gbn

  SSCertifiable

  Points: 6429

  More actions

  June 17, 2005 at 4:21 am

  #566346

  Use "sp_setnetname" to change the "data_source" of the linked server

  We don't use actual server names for our linked servers, but use sp_setnetname to keep, for example, the same linked server name across test, live, dev etc but each points to a different server

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 17, 2005 at 4:31 am

  #566349

  Thanx Shawn C!

  But you know of no way of actually changing the Server name?

   

   

• gbn

  SSCertifiable

  Points: 6429

  More actions

  June 17, 2005 at 4:37 am

  #566354

  Sorry no, except for dropping and creating.

  However, this should work but I don't know the side effects:

  EXEC dbo.sp_configure 'show advanced options', 1

  GO

  RECONFIGURE

  GO

  EXEC dbo.sp_configure 'allow updates', 1

  GO

  RECONFIGURE WITH OVERRIDE

  GO

  USE master

  GO

  UPDATE dbo.sysservers SET srvname = 'new' WHERE srvname = 'old'

  GO

  EXEC dbo.sp_configure 'allow updates', 0

  GO

  RECONFIGURE WITH OVERRIDE

  GO

   

   

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 17, 2005 at 4:42 am

  #566358

  Right...

  I'll do some testing... Thanx again!

  P.S And if someone else have tried it and found any issues with changing this system table, please let us know!