Change name of LINKED SERVER (without dropping an re-creating)

• Express12

  SSCoach

  Points: 18517

  More actions

  December 11, 2018 at 7:45 am

  #376596

  How would I change the name of a Linked Server and maintain its existing credentials -- without DROPPING and Re-CREATING the linked Server?

  This link discusses "how to" but I'm still not understanding: https://stackoverflow.com/questions/11866079/changing-properties-of-a-linked-server-in-sql-server

  My current ServerName is ServerABC w/ a Linked Server Def defined as ServerLINKEDServer (and it's Security uses a remote login w/ a pwd)

  BT

• goher2000

  SSCertifiable

  Points: 5479

  More actions

  December 11, 2018 at 9:11 am

  #2016001

  I would say try on your test environment and let us know the results, I too want to know if it works, if it does not then you might need 
  https://www.richardswinbank.net/admin/extract_linked_server_passwords , I haven't tested extracting passwords so let us know the results.

• Express12

  SSCoach

  Points: 18517

  More actions

  December 11, 2018 at 9:25 am

  #2016002

  this worked:  EXEC master.dbo.sp_serveroption @server=N'ServerLINKEDServer', @optname=N'name', @optvalue=N'Server_NEW_LINKEDServer'

  ( I did not need to specify my ServerABC name which is the SQL Server housing the original Linked Server name: ServerLINKEDServer )

  BT