MS SQL monitoring not started

[kwzabbixlearner]

Hello;

I installed the FreeTD, UnixODBC, and the Zabbix agent on my MS SQL server, also configure the /etc/odbc.ini for odbc connection to my MS SQL, also done the permission configuration for the database user account. But, I still cannot see the SQL activities to be monitored. What am I missing?

Pls help me if you have experience to configure Zabbix to monitor MS SQL server.

thx

[kal]

https://www.zabbix.com/documentation/4.4/manual/config/templates_out_of_the_box/requirements/mysql

[kwzabbixlearner]

Hi;

Thank you Kal, the provide URL is for MySQL, I am using Microsoft SQL, any step by step reference that I can follow?

[Hamardaban]

Which template do you use? Figure out by stages how data is received in it, how items work.

[kwzabbixlearner]

Hi;

I am using the "Template/Database", the default template in Zabbix

[Hamardaban]

Check the connection to mssql from the command line on the zabbix server using tsql and isql.
After the connection is successfully verified, proceed to configuring macros in the template.
Follow the instructions https://www.zabbix.com/integrations/mssql#mssql_odbc

[kwzabbixlearner]

thx! Yes, I was following that site to do my setup and tried this but still not able to see any graphs regarding MSSQL database, for example; the MSSQL Database Pages graph is empty.

use msdb
GRANT SELECT ON OBJECT::msdb.dbo.sysjobs TO ZBX_monitor
GRANT SELECT ON OBJECT::msdb.dbo.sysjobservers TO zbx_monitor
GRANT SELECT ON OBJECT::msdb.dbo.sysjobactivity TO zbx_monitor
GRANT EXECUTE ON OBJECT::msdb.dbo.agent_datetime TO zbx_monitor

[Hamardaban]

Is the connection working?
Have you checked?
Try to get from the command line the query result that is used in items or lld.

[kwzabbixlearner]

thank you for your reply.

How can I test the connection on my Zabbix server? I am using the Oracle linux.

[Hamardaban]

As I wrote earlier
«Check the connection to mssql from the command line on the zabbix server using tsql and isql»

[kwzabbixlearner]

thank you for reply


tsql -S 192.168.1.100 -U sa
locale is "en_CA.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1>

when I run isql, I got this


isql -v TS username password

[root@localhost ~]# isql -v sqlserver username password
+---------------------------------------+
| Connected!
|
| sql-statement
| help [tablename]
| quit
|
+---------------------------------------+

Monitored for a day and it is showing on Dashboard

MSSQL: Failed to fetch info data (or no data for 30m)