I have a linked server with SQL Server configured with the security option "For a login not defined in the above list, connections will: Be made using the login's current security context".

What I want to do is start logging which logins are using the linked server, and preferably whether the connection succeeded or failed, and where the login came from (which database, stored procedure, etc.).

Is this possible? I can't find anything obvious.

  • Refer to How to Trace to See if a Linked Server is Being Used?. It seems pretty straightforward. I'm going to be using trace to audit this... – sam yi Nov 21 '13 at 17:55
  • That would be useful for a one-off or occasional check, but probably not so useful for creating a permanent audit log? – paulH Jan 13 '16 at 9:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.