Create linked server with SQL command

Question

can you help me to create linked server using some SQL command ?

subquestion : How to remove it ?

Sachin Shanbhag · Accepted Answer · 2011-02-10 14:15:29Z

4

Check this sp_addlinkedserver command in SQL server to add a linked server

Check sp_dropserver command in SQL server to remove a linked server.

Only the servername is mandatory to be supplied to this command, rest all parameters are optional.

edited Feb 10, 2011 at 14:15

answered Feb 10, 2011 at 7:06

Sachin Shanbhag

55.7k11 gold badges92 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gary Kindel · Accepted Answer · 2011-05-23 13:42:16Z

4

Here is a code example

--local linked server
EXEC sp_addlinkedserver   
   @server='FUSIONRIS', 
   @srvproduct='',
   @provider='SQLNCLI', 
   @datasrc='MylocalServerName'

answered May 23, 2011 at 13:42

Gary Kindel

17.9k7 gold badges51 silver badges67 bronze badges

Comments

Lynn Langit · Accepted Answer · 2012-05-10 19:08:52Z

0

There is a also a GUI in SSMS to set up linked servers. Be sure to create a login -> db user on each server and to create the mapping between these two db users correctly either via your script or in the GUI. Also these users should have the least possible permissions, as when you are using linked servers, you are doubling your attack surface.

answered May 10, 2012 at 19:08

Lynn Langit

4,0601 gold badge25 silver badges31 bronze badges

Collectives™ on Stack Overflow

Create linked server with SQL command

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related