Unable to migrate database from remote MSSQL server: Destination server does not have required login

Symptoms

• Migration of one of subscriptions fails with the following error message:

  Sync content 
  Failed to copy content of database 'example' 
  Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code. 
  command: "C:\Program Files (x86)\Plesk\admin\bin\dbbackup.exe" --copy -copy-if-logins-exist -with-data -src-server=203.0.113.2 -server-type=mssql -src-server-login=sa -src-server-pwd=***hidden*** -src-database=example -dst-server=203.0.113.3 -dst-server-login=sa -dst-server-pwd=***hidden*** -dst-database=exampledatabase 
  exit code: 23 
  stdout: Destination server does not have required login.
  stderr:
  

• Remote MSSQL server is used on target Plesk.

Cause

Remote MS SQL server credentials are not specified in migration session configuration.

Resolution

1. On remote MSSQL server Migration RPC Agent should be deployed manually by downloading from initial window of Migration Extension and running. The file C:\plesk_migrator\rpc-agent\config.ini should be edited as following:

   [GLOBAL]
   ...
   copy-mssql-content: native
   

   Then run C:\panel-migrator\panel-migrator-rpc-agent.exe .

2. On the target Plesk server in file `%plesk_dir%\var\modules\panel-migrator\sessions\<timestamp>\config.ini the following edits should be done:

   [GLOBAL]
   ...
   # [optional] external-db-servers
   # Comma-separated list of the sections describing external source database servers.
   # It is highly recommended to specify external database servers for remote MSSQL - otherwise there could be issues
   # when copying database content.
   
   external-db-servers: mssql1
   
   ...
   
   [mssql1]
   # This optional section defines settings of external MSSQL database server 'mssql1'.
   # Fill this section's settings and list it in the 'external-db-servers'
   # setting of GLOBAL section to get the MSSQL databases copied from this server with native MSSQL backup.
   # Remove this section otherwise.
   # [mandatory] os
   # Operating system on which external DB server runs. Could either "windows" or "unix"
   
   os:
   
   # [mandatory] host
   # The address of this database server, exactly as displayed in Plesk Panel (usually it equals to database server's IP address).
   
   host:
   
   # [mandatory] type
   # Type of the database server - either 'pgsql' or 'mssql'
   
   type: mssql
   
   # [mandatory] ip
   # An IP v4 address of this database server.
   
   ip:
   
   # [mandatory] windows-username
   # User name of the privileged system user on this centralized mail server. Default is 'Administrator'.
   # windows-username: Administrator
   # [mandatory] windows-password
   # Password of the privileged system user on this database server.
   
   windows-password:
   
   

3. Then migration with remote MSSQL server can be started, or continued using Re-sync of subscriptions function.