Error: Login Failed for User
Issue
Setup tests fail. The following error appears:
Login failed for user. ClientConnectionId:xxx
Environment
The following SQL Server database connectors:
- Generic SQL Server
- Amazon SQL Server RDS
- Azure SQL Database
- Azure SQL Managed Instance
- Google Cloud SQL for SQL Server
Resolution
To resolve this issue, ensure the information you provide in the setup form's User and Password fields is correct and the User field value is correctly formatted. For information on how to format the value in the User field, see the applicable setup guide for your SQL Server database:
- Generic SQL Server
- Amazon SQL Server RDS
- Azure SQL Database
- Azure SQL Managed Instance
- Google Cloud SQL for SQL Server
Cause
This issue occurs if you provide an incorrect username and password in the setup test's User and Password fields or format the username incorrectly.