• i would lean more towards a logic error in the trigger.

    the login trigger clearly rejected the login, but that might be because the login user does not have read permissions to sys.dm_exec_sessions, or the logic to write to a log might be killed due to permissions to write to the table, or goes down a logic tree of IF statements that raise the error, but don't write to your log.

    show us the trigger itself, and we can offer some peer review.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!