When customer tries to add MS SQL database node,
Unable to connect to the database server error appears.
However, if one runs the same command, but explicitly specifying the default MS SQL port (1433), no connection errors appear.
/var/log/shm-dispatcher/dispatcher.log on Plesk node the following errors could be seen:
whp_requests.INFO: Execution context [POST https://10.7.2.60:6301/web/DbManager/ffbebb82-03e9-4d04-a8e6-e139cf874e6c/checkConnection (ID: 9f66cdfd63e8b8799cb56fa50fd5f62187219106)] HTTP/1.1 500 Internal Server Error "errorMessage": "mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.\r\n at (VADOConnection::open line 48)\r\n at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial Catalog=master;Data ... "error": "PmShm.Sdk.Exception_DbServerConnectionFailed",
Due to software-related issue WHM-10260, OA passes incorrect commandline to Plesk.
Issue could be workarounded in the following way:
- After system shows error 'Unable to connect to the database server. Continue anyway?' press OK.
- Go to PCP
- Services > WebHosting Plesk
- Switch to tab Service Nodes
- Click "Tools and Settings" of Windows Service Node
- Database Servers -> Add Database Server
Add database with the following parameters:
Database server type: MS SQL Host name or IP address: <IP address of node with MS SQL Server> Administrator's username: <user name (usualy "sa") Administrator's password: <password> Confirm password: <password>
After this steps it is possible to provision Websites with on Windows Plans with shared MS SQL Servers and manage databases on these sites as usual.