Friday, March 9, 2012

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.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|||These are listed as remote servers not linked servers.

How do I remove remote mappings in Enterprise Mangler?|||Check BOL (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/entrmgr/em_62p8.asp).

-PatP

No comments:

Post a Comment