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
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.
Application scope
ApsaraDB RDS for SQL Server