Microsoft SQL DB monitoring by ODBC in zabbix

Yes, you will be able to monitor multiple databases once the discover rule of the template runs.

This guide helped me.

https://www.zabbix.com/integrations/mssql

Looking at my notes it's similar to what you outlined.

1. Setup db user and provide necessary permissions.

   TSQL to create and grant monitoring user appropriate permissions:

   USE [master]
   GO
   CREATE LOGIN zbx_monitor
   WITH PASSWORD=N'superSecurePassword', 
   DEFAULT_DATABASE=[master], 
   DEFAULT_LANGUAGE=[us_english], 
   CHECK_EXPIRATION=OFF, 
   CHECK_POLICY=OFF
   GO
   GRANT VIEW SERVER STATE TO zbx_monitor
   GO
   GRANT VIEW ANY DEFINITION TO zbx_monitor
   GO
   USE msdb;
   GO
   CREATE USER zbx_monitor
   FOR LOGIN zbx_monitor; 
   --EXEC sp_addrolemember @rolename='public', @membername=zbx_monitor;
   --EXEC sp_addrolemember N''db_datawriter'', zbx_monitor
   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;
   

2. Install MS SQL ODBC drivers and unixODBC (Found a guide online for Ubuntu)

   • update odbc.ini with DB DSNs

   • test connection and user

3. Install MS SQL DB Template

4. Assign Template to host