Setting Up Linked Servers

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 16 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

Send a Message


 

 

 


 
  

Configuring Linked Servers

You can use the below instructions to set up a linked server in SQL Server 2005.

NOTE:  Make sure that the SQL Server that you want to link to is configured so that you can access the SQL Server.

Step 1:  In the "Object Explorer" of Management Studio, go to Server objects->Linked Servers->New Linked Server

Step 2:  Enter the SQL Server name for the database that you wish to link to in the "Linked Server" field.  Also, select "SQL Server" in the Server Type field.

 

Step 3:  Select the "Security" option in the menu on the left side of the screen.

Step 4:  In the bottom of the screen, select the option, "Be Made using this security context".  Then, enter the username and password that should be used to connect to the sql server that you want to link to.  After that, you can complete the configuration by clicking on the "Ok" button.

 

Now, you should be able to run your query:

SELECT * 
FROM [server1].[Database Name].[Dbo].[Table Name] as table INNER JOIN 
[Linked Database Server].[Database Name]. [Linked Server Table Name] as linkedtable
ON table.ID=linkedtable.ID