Error while performing a subscription re-sync: Failed to execute SQL query: Login failed for user ‘sa’

Dmitry Bystrov

10 months ago

Symptoms

An unfinished migration session is active on the destination server
A password for the MS SQL sa user was changed on the source server after the example.com subscription have been transferred
Trying to perform a re-sync of the example.com subscription's database fails with the following error:
Attempt #1 failed with the following error:
Failed to execute SQL query: Login failed for user 'sa'. DB-Lib error message 18456, severity 14:
General SQL Server error: Check messages from the SQL Server
DB-Lib error message 20002, severity 9:
Adaptive Server connection failed

An old password for the sa user is still cached on the source server

2. Navigate to Tools & Settings > Migration & Transfer Manager and select the active migration

3. Perform a re-sync of the example.com subscription with the following options:

4. After the business object re-sync has finished, proceed with re-syncing the example.com subscription's database

0 Shares