Trace shows the incorrect Session Login Name


The is more of an FYI blog post but I have read several blog and forum posts on this subject and I decided to dig into the behavior which revealed a trace bug.

For the vast majority of events the Session Login Name represents the originating session credentials where as the Login Name represents the current session credentials and everything works correctly.   The login name could be different for instance if there was an execute as in progress. 

I found was the Existing Connection event incorrectly produces the session login name of the user who is starting the trace instead of the user associated with the login information of the existing connection.

I have filed a defect to get this addressed in future releases of the SQL Server.

Bob Dorr – Principal SQL Server Escalation Engineer

Comments (3)

  1. Official Eagles Jersey says:

    I have filed a defect to get this addressed in future releases of the SQL Server.http://www.authenticeaglesjerseys.com

  2. Official Eagles Jersey says:

    http://www.authenticeaglesjerseys.com/I have filed a defect to get this addressed in future releases of the SQL Server.

  3. John says:

    Where's the connect bug/issue submission on this?  I'm not seeing anything online (be it open, closed, or otherwise), so it makes me wonder if you identified this is no longer an issue.