Adding Linked Servers

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  October 17, 2005 at 8:56 am

  #166471

  Guys,

       To be able to access remote sql server 2000, I have activated DTC (Distributed Transaction Coordinator) on the server hosting sql server 2000

  Then I ran the following script to add the server

  EXEC sp_addlinkedserver

      'PROTOSRV\TYPE',

      N'SQL Server'

  then I tried to access data on this server by running the following query

  select * from [PROTOSRV\TYPE],[DBNAME].[dbo].[employee]

  I get the following error

  "

  Server: Msg 18456, Level 14, State 1, Line 1

  Login failed for user 'sa'.

  "

  I have tried to look up in help but it does not have any clear fix for this.

  Any suggestions/inputs would help

  Thanks

   

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  October 18, 2005 at 4:30 am

  #597868

  Hi,

   

  Have u enabled RPC in out.

  Map the logins and remote logins too.

  from

  Killer

• Maverick100877

  SSCertifiable

  Points: 5240

  More actions

  October 20, 2005 at 10:08 am

  #598804

  Hi

  Please check the sa login id and password u have given for the remote login.Probably it is not correct and so it is not allowing u to access.