Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Create linked server as another name

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-10-21 : 09:31:13
Hi all,

I would like to create a linked server to another SQL Server. Using management Studio I normally choose SQL Server as the server type.

However as I want to have a different name for my Linked Server than it's actual name. How do I fill out the dialog box?

Let's say the name of the new linked server is Linked and it's to connect to server Jupiter.

Is it possible to do this in the GUI or does it have to be via script?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-21 : 09:40:37
Thats because you choose SQL Server as server type. you need to use other and give values as below

http://sqlserverplanet.com/dba/how-to-add-a-linked-server

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -