Connection Zabbix to MSSQL

[PiotrJ]

Hi
I'd like to do a table on my dashboard where i can see which backup (job) failed.
Database is on virtual machine in the same network with zabbix and its on MSSQL.
Zabbix is on another virtualmachine with debian and its by the docker compose.
Now i want cojnect database with zabbix and pull from the data base information about job (making backup) and placed it on the dashboard.
Please help
Im sorry for my weak engish.
Regards

[SanMonitor]

Hello Piotrj,

we monitor our MSSQL using this template: https://www.zabbix.com/integrations/mssql
Read the setup carefully, you have to create a user on your database with read rights & you have to install the Microsoft ODBC Driver on your Zabbix server.

It monitors a lot, including jobs and last backup.

[PiotrJ]

I followed the steps in order but I can't connect to the database that is on another computer in the same network. Don't I have to enter the IP address of the computer with the database somewhere?

[cyber]

I followed the steps in order but I can't connect to the database that is on another computer in the same network. Don't I have to enter the IP address of the computer with the database somewhere?

That probably should be in your ODBC config...

[PiotrJ]

That means I can't connect without editing odbc.ini?

[cyber]

If you don't want to edit all the items... yes..
Please consult docs... https://www.zabbix.com/documentation...abbix-frontend

[PiotrJ]

I have to up my zabbix on another virtual machine and my zabbix server is not avaible.
please help.