Procedure for Linking SQL Servers

  1. Start Enterprise Manager
  2. Click + to expand SQL Server Group
  3. Click + to expand the link from Server Group
  4. Click + to expand Security
  5. Right click Linked Servers
  6. Click New Linked Server...
  7. Enter the Linked Server name in Linked Server

    8. Linked Server name should be SQL Server name followed by database name

    example: SQL Server: BIWGDCSQL02

    Database : DCO88001

    Linked Server name: SQL02_DCO88001

  8. Check Other data source radio button
  9. Choose Microsoft OLE DB Provider for SQL Server in Provider name
  10. Enter SQL Server name in Data source

    11. example: BIWGDCSQL02

  11. Enter SQL Database name in Catalog
  12. Click Security tab
  13. Click they will be mapped to radio button
  14. Enter SQL Server Login name of the linked server in remote user
  15. Enter SQL Server Login password in with password
  16. Click General tab
  17. Click OK
  18. Click + to expand your linked server
  19. Double click Tables
  20. Your tables should appear on the right half of the screen