Linked Server

Question

Linked Server

kapil.kadaparthi

Grasshopper

Points: 21
More actions
November 13, 2013 at 11:23 am

#279143

Hi When i am trying to edit my linked server it encountered with below error message.Do i need to Drop the existing linked server and recreate it to change the data source or is there another way
"Msg 15028, Level 16, State 1, Procedure sp_addlinkedserver, Line 82
The server '********' already exists."
A bit urgent can any one respond to the post

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

lsalih SSCertifiable Points: 6143 More actions · Answer 1

The way I would go about it is by generating create script of the linked server in a new window, modify the script to include the modification you need, delete the linked server and run the script. That is how I have made changes to my linked server definition to change server name, not sure what you are trying to modify.

Lempster SSCoach Points: 15651 More actions · Answer 2

lsalih (6/3/2014)
The way I would go about it is by generating create script of the linked server in a new window, modify the script to include the modification you need, delete the linked server and run the script. That is how I have made changes to my linked server definition to change server name, not sure what you are trying to modify.

Bear in mind that when you script out a linked server definition, any passwords are replaced by ########### so you'll have to ually add them back in to the script before executing it.

Regards

Lempster

lsalih SSCertifiable Points: 6143 More actions · Answer 3

Hi Lempster -

Last time I created a linked server from generated script, I did not have to reenter password. I used SQL 2008.

Lempster SSCoach Points: 15651 More actions · Answer 4

Well, if you are using either a local login mapped to a remote login or have the 'be made using this security context' radio button checked, the password(s) will be replaced with ####### and you'll need to edit your script. Here's an example:

EXEC master.dbo.sp_addlinkedserver @server = N'10.5.13.250', @srvproduct=N'10.2.13.250', @provider=N'MSDASQL', @datasrc=N'10.5.13.250'

/* For security reasons the linked server remote logins password is changed with ######## */

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'10.5.13.250',@useself=N'False',@locallogin=NULL,@rmtuser=N'rmtuserl',@rmtpassword='########'

Regards

Lempster

lsalih SSCertifiable Points: 6143 More actions · Answer 5

Lempster -

Thank you for the info, I will keep this in mind. I do not recall what security options I had setup when I recreated the linked server.