Symptoms
- An unfinished migration session is active on the destination server
- A password for the MS SQL
sauser 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
Cause
An old password for the sa user is still cached on the source server
Resolution
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:
- Re-sync business objects
- Re-sync external IDs
4. After the business object re-sync has finished, proceed with re-syncing the example.com subscription's database
with