MSSQL by ODBC with AD user instend of local user, it's possible?

[PatxiAndueza]

I have alredy accomplished to monitor my MSSQL Server over ODBC whit a local user from the database.

My question is, can I use a AD / Windows user to conect via ODBC instead of the local user?

====================================
My set-up:

zabbix-release_5.4-1 in a Debian 10
unixODBC 2.3.7


{$MSSQL.DSN} = <name>
{$MSSQL.PASSWORD} = <passwd>
{$MSSQL.USER} = zbx_monitor (local user,as the documentation says)

=====================================

At the moment all is working whitout any problem, but I want to know if there is any way to change it.

Thanks in advance.

Patxi.

[bbonno]

Yeah, it would be really nice if this was possible.

Sure, using MSSQL by Zabbix agent 2 supports using AD accounts, but requires that you put your queries in .sql files on the server where the agent is running. This breaks otherwise clean templates that could be applied to multiple databases with little effort.