Take the 2-minute tour ×
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 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.

share|improve this question
add comment

1 Answer 1

Sorry to be responding to something so old...

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5044a52c-f09b-4ac2-8a85-df627e677c33/how-to-trace-to-see-if-a-linked-server-is-being-used?forum=sqldatabaseengine

Seems pretty straightforward. I'm going to be using trace to audit this... will update with my solution.

share|improve this answer
    
Hey, you're the first person to answer so no need to apologise! Now if only I could remember why I wanted to do this... :-) –  paulH Nov 21 '13 at 18:04
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.