I’m collecting SQL Stats by using using telegraf sqlserver plugin. Telegraf agent installed on the sql server. Also, same agent should be collecting the server metrics (perfmon).
Here is the problem. I don’t want to display sql user-password as clear text in the config file. So, I’ve created a service account in the active directory then run telegraf windows service with the service account.
Now, telegraf is not able to collect server metrics. What permisisons should I provide to the service account. I don’t want to make it admin if possible.