Error: Login Failed for User. Reason: The Password of the Account Must Be Changed

Issue

While setting up a connector, the following error appears:

SQLServerException: Login failed for user. Reason: The password of the account must be changed

Environment

Connector: SQL Server

Resolution

To resolve this issue, do the following:

1. In SQL Server, change the password for the user referenced in the error message. See Microsoft's Alter Login documentation for more information.
2. In Fivetran, go to your SQL Server connector page.
3. Select the Setup tab.
4. Click Edit connection.
5. Enter your new password in the Password field.
6. Click Save & Test.

Cause

This issue occurs when authorizing user's password has expired or must be changed due to SQL Server's password policy.