How do I create a Linked Server

• sandeepivs

  SSC-Addicted

  Points: 494

  More actions

  June 1, 2010 at 5:38 am

  #141260

  Hi Friends,

  I want to create a linked server in my system.

  Error in creating the linked servers between sql server 2000 Servers..

  Can any one help me how to create a linked Server?

  Using SQL Server 2000 as a Linked Server target from MS SQL Server 2000?

  Waiting for your reply

  Thanks In Advance

  Sandeep IVS

• malleswarareddy_m

  SSCertifiable

  Points: 5847

  More actions

  June 1, 2010 at 6:03 am

  #1174727

  USE master

  GO

  -- To use named parameters:

  EXEC sp_addlinkedserver

  @server = 'SF-PC035',

  @srvproduct = '',

  @provider = 'SQLNCLI',

  @provstr = 'DRIVER={SQL Server};SERVER=SF-PC035\sqlexpress;userid=sa;password="password";'

  EXEC sp_addlinkedsrvlogin 'SF-PC035', 'false', NULL, 'sa', 'password'

  sp_addlinkedserver is for creating linked server.

  sp_addlinkedsrvlogin is for Providing authentication for the linked server.

  Then Linked server created sucessfully.

  Malleswarareddy
  I.T.Analyst
  MCITP(70-451)