O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting Up Linked Servers Using SQL Server Management Studio

Although you can set up linked servers and login mappings by directly executing system stored procedures, you can also set them up easily through SQL Server Management Studio.

To create a “SQL Server” linked server, you follow these steps:

1. Open SQL Server Management Studio with a connection to a local server (DATAXDESIGN-PC\SQL2014DXD32 in this example).

2. Expand the Server Objects node and then the Linked Servers node.

3. Right-click the Linked Servers node and choose New Linked Server.

4. You are presented with a properties page where you must specify all the connection properties for the linked server. For this example, create a SQL Server database linked server entry. As shown ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required