All Products
Search
Document Center

A Logon failed for login 'user' due to trigger execution error occurs when you connect to the database

Last Updated: Dec 24, 2020

Problem description

The Logon failed for login 'user' due to trigger execution error is reported when the user uses the DMS console to connect to the database.

Cause

This problem generally occurs in the RDS SQL Server database because the number of connections is full.

Solution

  1. Check whether the number of connections is full. If the number of connections is large, seehow to handle the full number of RDS MySQL connections.
  2. If the number of connections is not reached, log in using SSMS(SQL Server Management Studio) and run the following SQL statement to confirm the number of processes and check for blocks.
    select * from sys.sysprocesses
  3. If there is a block, refer to the apsaradb RDS SQL Server blocking issue solution.

Application scope

  • ApsaraDB RDS for SQL Server