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.