Article ID: 117724, created on Oct 5, 2013, last review on Aug 12, 2014

  • Applies to:
  • Plesk Automation

Symptoms

  1. 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.
    
  2. 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.
    

Cause

MSSQL server has a lot of data or connection to MSSQL server is too slow, as a result command exceeded timeout.

Resolution

  1. Download fixed script check_mssql_connection.ps1.tgz.

  2. Backup file /usr/lib/python2.7/site-packages/parallels/plesks_migrator/scripts/check_mssql_connection.ps1 and replace it with the fix.

Search Words

Unable to migrate MSSQL domains

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF