17892

ﾃ

Product Name

Event ID

17892

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SRV_LOGON_FAILED_BY_TRIGGER

Message Text

Logon failed for login due to trigger execution.

Error 17892 is raised when a logon trigger code cannot execute successfully.

Logon Triggers

fire stored procedures in response to a LOGON event. This event is raised when a user session

is established with an instance of SQL Server. The following error message is reported to the

user:

Msg 17892, Level 14, State 1, Server , Line 1

Logon failed for login due to trigger execution.

The problem could occur if there is an error when executing trigger code for that specific user

account. Some of the scenarios include:

The trigger tries to insert data into a table that does not exist.

The login does not have permissions to the object that is referred to by the logon trigger.

ﾉ

Expand table