Problem description
When you log on to an apsaradb for RDS SQL Server instance through DMS, the following error message is displayed:
Logon failed for login 'user' due to trigger execution
Cause
May be caused by the following reasons:
- The error message returned when the number of connections to the RDS SQL Server instance is full.
- The number of processes is blocked.
Solution
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted sensitive information such as the logon account and password in the Alibaba Cloud Management Console, we recommend that you modify such information in a timely manner.
- The number of connections exceeds its upper limit is typically due to a large number of idle or active connections. For more information about the causes and solutions, see handling of full connections to RDS for MySQL or handling of full connections to RDS for PostgreSQL.
- When an application frequently reads or writes a table or resource, it is prone to blocking. For solutions, see apsaradb for RDS SQL Server blocking solution.
Application scope
- Data Management
- ApsaraDB RDS for SQL Server