How to Setup a Linked Server

A linked connection in Microsoft SQL Server gives programmers the ability to write code on one database that queries another. It's beneficial for corporations that have multiple databases across the organization without creating multiple copies of tables. For instance, if a separate reporting server is set up from the main database, a linked server allows programmers to query reports from the main SQL server. Setting up a linked server only takes a few steps through the Enterprise Manager console.

Things You'll Need

• Computer

Instructions

The Steps

1. Click the Windows "Start" button and select "All Programs." From the menu, select "Microsoft SQL Server Enterprise Manager."

2. Select the name of the server on the left of the window.

3. Click "Security" to expand its options.

4. Right-click the "Linked Server" icon and select "New Linked Server" from the menu.

5. Click the "General" tab. Enter the name of the database you want to link in the textbox labeled "Linked server."

6. Select the server type in the listbox. If the server is another SQL server, then no drivers need to be selected. If you link to a source such as a Microsoft Access database, then drivers need to be selected. Click "OK."

7. Close the Enterprise Management console.

References

• Microsoft