Migration of the domains with MSSQL databases failed with error below:
#/usr/local/bin/ppa-transfer transfer-accounts config.ini Error message or request description : Connections between source and the destination database server nodes │ │ │ └ error: Unable to connect from the PPA node #ID (192.168.0.30) to MSSQL server '192.168.0.100' (user 'sa') located on the source Plesk server 'plesk' (192.168.0.100). │ │ Please check that: │ 1) There are no firewall rules blocking MSSQL connections from the PPA node to the source Plesk node. │ 2) Remote connections to MSSQL server are allowed. │ 3) MSSQL server is running. │ │ Connection error message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
PPA uses powershell script to check connection, when you run the following PS script from PPA node mentioned in error, it fails with error below:
PS powershell -ExecutionPolicy Unrestricted -File "C:\migrator\check_mssql_connection.ps1" -dataSource 192.168.0.100 -login sa -pwd **** Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
MSSQL server has a lot of data or connection to MSSQL server is too slow, as a result command exceeded timeout.
Download fixed script check_mssql_connection.ps1.tgz.
/usr/lib/python2.7/site-packages/parallels/plesks_migrator/scripts/check_mssql_connection.ps1and replace it with the fix.