Home Forums SQL Server 2008 SQL Server 2008 - General login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2 RE: login_name shows up as blank in sys.dm_exec_sessions but not in sp_who2

  • September 6, 2013 at 1:15 pm

    #1648214

    Try:

    SELECT original_login_name, *

    FROM sys.dm_exec_sessions

    where login_name = 'S-1-9-3-322691058-1310504681-3474585482-2036716736'

    I got the same issue, but do not know how to fix it so SQL Server shows the correct login name or SID. So does anyone know if the issue is directly from SQL Server, AD, or from the .NET application?