I have a linked server set up 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.