December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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\SQL2012DXD32 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 ...