Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 11:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 6:55 AM
Points: 1, Visits: 81
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
Post #1514001
Posted Tuesday, June 3, 2014 9:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 11, 2014 5:47 PM
Points: 104, Visits: 618
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.


Post #1577202
Posted Wednesday, June 4, 2014 6:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 2,059, Visits: 1,431
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
Post #1577287
Posted Wednesday, June 4, 2014 6:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 11, 2014 5:47 PM
Points: 104, Visits: 618
Hi Lempster -

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



Post #1577298
Posted Wednesday, June 4, 2014 8:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:09 AM
Points: 2,059, Visits: 1,431
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
Post #1577343
Posted Wednesday, June 4, 2014 9:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 11, 2014 5:47 PM
Points: 104, Visits: 618
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.



Post #1577384
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse