Symptoms
While adding a MS SQL database node at PCP > WebHosting Plesk > Shared Database Servers > New, the following warning is displayed:
Unable to connect to the database server. Continue anyway?
Details can be found in /var/log/shm-dispatcher/dispatcher.log on WebHosting Plesk dispatcher node:
[2019-10-08 20:35:08] doctrine.DEBUG: Execution context [POST https://10.0.0.1:6301/web/DbManager/b7e69e3f-3509-4b7b-9426-e5eabb03074d/checkConnection (ID: 25eaa5d88d94d52381ef5c16622d7139b4ea7679)]
SELECT t0.id AS id1, t0.uid AS uid2, t0.communication_ip AS communication_ip3, t0.public_hostname AS public_hostname4, t0.version AS version5, t0.status AS status6, t0.os FROM node t0 WHERE t0.os IN ('windows', 'linux')
[2019-10-08 20:35:08] dispatcher_requests.DEBUG: Execution context [POST https://10.0.0.1:6301/web/DbManager/b7e69e3f-3509-4b7b-9426-e5eabb03074d/checkConnection (ID: 25eaa5d88d94d52381ef5c16622d7139b4ea7679)]
#Response prepared by Dispatcher (Finished in 1.387010 s):
HTTP/1.1 200 OK
Cache-Control: must-revalidate, no-cache, private
Content-Type: application/json
Date: Tue, 08 Oct 2019 18:35:07 GMT
Expires: 0
X-Powered-By: APS PHP Runtime 7.4-112
{"isConnected":false,"errorCode":null,"errorMessage":null}
Cause
There are no available Windows Plesk server in PCP > WebHosting Plesk > Service Nodes.
Feature request #WHM-11123 has been submitted in order to improve error handling for DB node connection validation.
Resolution
Add a Win Plesk server and make sure that it has active status.