Unable to migrate remote MSSQL database: DB-Lib error message 20002, severity 9

Symptoms

• Unable to migrate Plesk with remote MSSQL database with the following error returned by Plesk Migrator:

  PLESK_ERROR: General SQL Server error: Check messages from the SQL Server
  DB-Lib error message 20002, severity 9:
  Adaptive Server connection failed

• Disk D: is used for temporary directory on the source server
• Remote MSSQL server does not have disk D:

Cause

Plesk bug PMT-4162 : Unable to specify temp folder for source remote MSSQL server.

Resolution

As a workaround, use disk C: for storing temporary files for migration by specifying it in a configuration file of migration session config.ini :

CONFIG_TEXT: [source]
...
session-dir = "C:\plesk_migrator"