Sign up ×
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. It's 100% free, no registration required.

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

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.