October 22, 2024
Chicago 12, Melborne City, USA
SQL

Trigger Execution connection failure in SQL Server Management


Received following notification when trying to run query:

Logon failed for login ‘*LOGIN NAME’ due to trigger execution. Changed database context to ‘master’. Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)

Thanks

I have tried disabling the trigger execution as well as trying DAC login. None of these seem to resolve the issue. Could somebody provide some insights on how to resolve or get around this?



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video