Jack Vamvas shows how to track SQL Server logins:
I have to capture logon information details for a specific logon on a SQL Server. Specifically – the client_hostname, nt_username & username. What i’m looking for is a log recording a successful connection made to the server. The event should be triggered a) when a connection is made & b) from a connection pool.
Click through to see how.