Post reply

Linked Server

  • 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

  • June 3, 2014 at 9:15 pm

    #1718727

    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.

  • June 4, 2014 at 6:25 am

    #1718794

    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

  • June 4, 2014 at 6:42 am

    #1718803

    Hi Lempster -

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

  • June 4, 2014 at 8:03 am

    #1718838

    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

  • June 4, 2014 at 9:05 am

    #1718872

    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.

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

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