December 11, 2018 at 7:45 am
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)
December 11, 2018 at 9:11 am
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.
December 11, 2018 at 9:25 am
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 )
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply