Results 1 to 4 of 4

Thread: Remote login

  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: Remote login

    Hi,

    I have messed around with some remote login stuff and really screwed things up, now all of my jobs that execute prcedures on the remote server all fail saying the login failed for user 'sa'.

    I need to get this working again and could really do with some help.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Depending on how you've got your security configured, you need to clear out the remote login matrix on either the local or the linked server. Pop into Enterprise Mangler, and remove any local to remote mappings with constant values (I don't think you can delete the "passthrough" mapping, but don't even try just in case you could).

    -PatP

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    These are listed as remote servers not linked servers.

    How do I remove remote mappings in Enterprise Mangler?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check BOL.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •