The task named Update the database service settings of the webspace #111 fails with the error:
Database server mssql 172.16.0.5:1433 does not exist
The external database server was registered in Plesk Automation with its host name, but its IP address instead of host name was specified in the activation parameters of the corresponding resource.
- Apply the fix from the following article: KB127803
- Go to the PA panel > Products > Service Templates > your service template > Resources > your database resource > Activation Parameters
- Click Edit and replace database server IP address with its host name, save changes
- Cancel the failed task and then restart it.