Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 at 9:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.