Error trying to exec a sp on remote server

• Jan Wagner-460740

  SSC Eights!

  Points: 963

  More actions

  October 31, 2007 at 5:03 pm

  #179770

  Hi,

  I'm trying to execute a sp on a remote linked server, but I'm getting the following error:

  "Could not connect to server '[NameOfTheLinkedServer]' because '[UsernameThatIsUsedForConnecting]' is not defined as a remote login at the server. Verify that you have specified the correct login name. ."

  This user I'm using has full rights on the remote machine. Anyway, Select Statements are working but no executes on remote procedures.

  Any ideas?

  Regards,

  Jan

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736078

  More actions

  December 2, 2007 at 1:11 pm

  #756303

  How is the linked server configured? Are logins mapped? It is possible that there is a misconfiguration here.