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.
This problem generally occurs in the RDS SQL Server database because the number of connections is full.
- 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.
- 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
- If there is a block, refer to the apsaradb RDS SQL Server blocking issue solution.
- ApsaraDB RDS for SQL Server