MSSQL monitor by Zabbix Agent 2

[majorbezportek]

Hi, i have Zabbix 6.0.29 version and i want to deploy database monitoring in network. I see there is a very fresh MSSQL Zabbix Template for Zabbix Agent 2 but:
I try to configure on MSSQL 2019, and with documentation MSSQL plugin is already compiled in ZA2 but i don't see ant *.conf file in plugins directory. Do i need put plugin or conf file some ware ?

When i do it with MySQL was only Login / Pass / Directory to database and finish.

[Singularity]

Check this : https://git.zabbix.com/projects/AP/repos/mssql/browse

[Singularity]

Check this : https://git.zabbix.com/projects/AP/repos/mssql/browse

[lmonasterio]

Hi @majorbezportek! Probably you need to install the Zabbix Agent 2 plugin. Please check https://cdn.zabbix.com/zabbix/binari...le/6.0/6.0.29/ for example
My regards!

[majorbezportek]

Thanks: lmonasterio and Singularity

I already installed and now i have macros:

$MSSQL.PASSWORD = <Some Pass>
$MSSQL.URI = sqlserver://<IP Address>:<Port>
$MSSQL.USER = <Some User>

I have TCP connection on MSSQL servers disabled. Do I need this communicate with Zabbix Agent 2 and MSSQL ? In Logs i have :

[MSSQL] Creating new connection to "sqlserver://<IP Address>:<Port>" with user <Some User> to database " ", with CA certificate " " .......

And still Zabbix not take values from MSSQL.

Ok, I confirm everything works fine thanks Singularity , what i did (Maybe will be good for someone)

- Check documentation - CORRECT NOT $MSSQL.URI = sqlserver://localhost:<Port>
- Increase log level on Agent to 4 -- Wrong password
- Correct password works better

[lmonasterio]

Thanks: lmonasterio and Singularity

I already installed and now i have macros:

$MSSQL.PASSWORD = <Some Pass>
$MSSQL.URI = sqlserver://<IP Address>:<Port>
$MSSQL.USER = <Some User>

I have TCP connection on MSSQL servers disabled. Do I need this communicate with Zabbix Agent 2 and MSSQL ? In Logs i have :

[MSSQL] Creating new connection to "sqlserver://<IP Address>:<Port>" with user <Some User> to database " ", with CA certificate " " .......

And still Zabbix not take values from MSSQL.

Ok, I confirm everything works fine thanks Singularity , what i did (Maybe will be good for someone)

- Check documentation - CORRECT NOT $MSSQL.URI = sqlserver://localhost:<Port>
- Increase log level on Agent to 4 -- Wrong password
- Correct password works better

You need MSSQL port open (default 1433). So, the URI is "sqlserver://localhost:1433"