- Plesk 12.5 for Windows
Migration fails with the following error:
`- error: Failed to copy content of database 'database name'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: cmd.exe /C ""C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\dbbackup.exe" --copy -copy-if-logins-exist -with-data -src-server="mssql.example.com" -server-type="mssql" -src-server-login="sa" -src-server-pwd="********" -src-database="database_name" -dst-server="MSSQLDEST" -dst-server-login="sa" -dst-server-pwd="*hidden*" -dst-database="database_name""
exit code: 23
stdout: Unable to copy database 'database_name' to database 'database_name''
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The network path was not found
A network-related issue with connection to a database server.
Try to disable the firewall on a source server. This article posted by Microsoft can be used.
Make sure that connection to the database could be established from the target server. The connection can be tested using the following command on the target server:
"%plesk_bin%\mssqlmng.exe" --check "--server=203.0.113.2" "--login=user" "--password=password"
Note: in order to test a connection between a source and a target database server SQL Management Studio also can be used.