Symptoms
-
MSSQL on source server is using custom port under SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVERXXXX (where **XXXX **is the MSSQL version) > TCP/IP > Properties
-
Migration of MSSQL Databases from source server fails with the following message:
PLESK_WARN: Migration tools tried to perform operation in 3 attempts: Failed to execute SQL query: Net-Lib error during Unknown error
Query: BACKUP DATABASE [example_db] TO DISK=%(file)s
Arguments: {‘file’: ‘C:plesk_migratormssql-dumpsexample_db.sql’}
Server: .MSSQLSERVER2016,1444
User: sa
Cause
The issue is caused by Plesk Migrator extension bug with ID #PMT-3538, which is planned to be fixed in future product updates.
Resolution
As a workaround.
-
Connect to the source server via RDP.
-
Backup the Plesk database:
C:> plesk db dump psa > C:psabackup.sql
- List all database servers registered in Plesk:
C:> plesk db “SELECT host,port FROM DatabaseServers”
- Add the custom port number to the default MS SQL Server. In this example we’re using port 1444:
C:> plesk db “UPDATE databaseservers SET host = ‘.MSSQLSERVER2016,1444’ WHERE id=3”
- Resync the migration of the databases affected.