June 17, 2005 at 1:48 am
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
June 17, 2005 at 4:21 am
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
June 17, 2005 at 4:37 am
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
June 17, 2005 at 4:42 am
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!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply