Search Engine: Elastic

Article ID: 131467, created on Sep 16, 2017, last review on Feb 7, 2018

  • Applies to:
  • Operations Automation 7.1
  • Operations Automation 7.2

Symptoms

When a user tries to add an MS SQL Server database node, they encounter the error "Unable to connect to the database server". However, if they run the same command, but explicitly specify the default MS SQL port (1433), no connection errors occur.

In /var/log/shm-dispatcher/dispatcher.log on the Plesk node, the following errors can 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",

Additionally, a task titled "Execute operation 'provisionWebsite'" can fail with the following error recorded in "/var/log/shm-dispatcher/dispatcher.log`:

Body: {"code":500,"message":"Error occurred during request to WHP API on service node 172.0.0.1: \"mssqlmng failed: SQL Server Network Interfaces: Connection string is not valid [87]. 

Login timeout expired\r\n at (VADOConnection::open line 48)\r\n at Unable to connect with connection string: Provider=SQLNCLI11;Initial Catalog=master;Data ...at execute "C:\Program Files (x86)\Plesk\admin\bin\mssqlmng\" --check \"--server=172.0.0.1\\mssqlserver\" \"--login=sa\" \"--password=*\"(vconsoleapp::run line 139)\n(Error code 1)\".",
"type":"WhpApiException","details":{"errorCode":1023,"error":"PmShm.Sdk.Exception_DbServerConnectionFailed",

Cause

Software-related issue #WHM-10260: "Cannot add shared MSSQL node: "SQL Server does not exist or access denied" if a Microsoft SQL Server is installed as the default instance".

Odin Automation passes incorrect commands to Plesk. It affects only "Default" instances. A Microsoft SQLServer instance configured as "Named" can be connected normally.

Resolution

Contact pta@odin.com or TAM to track the status of the issue.

Workaround: use "Named" instances of MSSQL.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 8c199f0ee4305da1a577740620df4a51 1941880841f714e458ae4dc3d9f3062d 31987597efff5a3a9ce779cc203bbe5e

Email subscription for changes to this article
Save as PDF