Search Engine: Elastic

Article ID: 130838, created on May 19, 2017, last review on May 19, 2017

  • Applies to:
  • Operations Automation 7.0

Symptoms

A 'Gather disk space usage from MS SQL Server databases' task for a MS SQL 2014 server fails with following output:

Destination host 'MSSQL01.hosting.local' (#10), IP '10.10.10.100' : Provisioning request failed. Source path 'executeData/xml/rs:data' does not match any node. XPath location: /request[1]/procedure[1]/execute[1]/after[2]
Type: Parallels.Wpe.Utils.WpeXmlException.

Cause

The "BUILTIN\Administrators" group does not have the "sysadmin" role assigned on the MS SQL server.

Resolution

According to the Installing MS SQL Server 2014 documentation the "BUILTIN\Administrators" group should be added to the list of the SQL Server administrators. Adding it should resolve the issue.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF