Is it possible to Login to Microsoft SQL Server via Windows Login? I would like to create a MSA (Managed Service Account) in Active Directory for Telegraf, so it don’t need a password…
Thank you in advance
Is it possible to Login to Microsoft SQL Server via Windows Login? I would like to create a MSA (Managed Service Account) in Active Directory for Telegraf, so it don’t need a password…
Thank you in advance
Yes, you can.
Using the SQL Server input without specifying user and password in the connection string will connect to the instance using Windows Authentication.
You must run Telegraf (as a service) using the correct user.
more info can be found in the readme of the go library used for connecting to SQL Server