Linked server for a TNS entry

• manus4u

  Ten Centuries

  Points: 1238

  More actions

  June 11, 2009 at 12:54 am

  #95661

  Hi,

  I have a TNS Entry and I need to create a linked server for it on sql 2000.

  Could someone guide me with the steps pls...

  Thanks in Adv

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  June 11, 2009 at 4:46 am

  #1007888

  manus4u (6/11/2009)

  ---

  Hi,

  I have a TNS Entry and I need to create a linked server for it on sql 2000.

  Could someone guide me with the steps pls...

  Thanks in Adv

  Try this:

  EXEC master.dbo.sp_addlinkedserver

  @server = N'Your_TSN_Name',

  @provider=N'MSDAORA',

  @datasrc=N'Your_TSN_Name'

  EXEC master.dbo.sp_addlinkedsrvlogin

  @rmtsrvname=N'Your_TSN_Name',

  @useself=N'False',

  @locallogin=NULL,

  @rmtuser=N'YourUser',

  @rmtpassword='########'

  GO

  [font="Verdana"]Markus Bohse[/font]

• manus4u

  Ten Centuries

  Points: 1238

  More actions

  June 11, 2009 at 5:00 am

  #1007894

  I could find it...still, thanks a lot for the reply...

  In addition, i found that, you need to make the TNS entry into TNSNAMES.ORA and then try a pinging the server with TNSPING.

  Then create the linked server with its credentials...

  THANKS A MILLION!