Cannot collect metrics from MSSQL Instances using telegraf

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• Telegraf agent has been installed on a Windows VM with the intention of collecting metrics from MSSQL.
• The Service has been configured in the UI to use a domain account for collection.
• The Telegraf agent logs on the endpoint (C:\VMware\UCP\ucp-telegraf\PluginErrorDetails.log) show Errors similar to the following: 
  
  query WaitStatsCategorized failed for server: <ServerName> and database: <empty-database-name> with Error: InitialBytes InitializeSecurityContext failed 8009030c,
query DatabaseProperties failed for server: <ServerName> and database: <empty-database-name> with Error: InitialBytes InitializeSecurityContext failed 8009030c,
query VolumeSpace failed for server: <ServerName> and database: <empty-database-name> with Error: InitialBytes InitializeSecurityContext failed 8009030c,
  

Environment

VMware Aria Operations 8.18.x

Resolution

Use a local MSSQL user instead of a domain account.