1. Create an MSSQL user for monitoring.
  View Server State and View Any Definition permissions should be granted to the user.
  Grant this user read permissions to the sysjobschedules, sysjobhistory, sysjobs tables.  
  For more information, see MSSQL documentation.
2. Set the user name and password in host macros ({$MSSQL.USER} and {$MSSQL.PASSWORD}).
  Do not forget to install Microsoft ODBC driver on Zabbix server or Zabbix proxy.
  See Microsoft documentation for instructions: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15.
  Note! Credentials in the odbc.ini do not work for MSSQL.
3. For named instance set the value of {$MSSQL.INSTANCE} macro as MSSQL$instance name.
The "Service's TCP port state" item uses {HOST.CONN} and {$MSSQL.PORT} macros to check the availability of the MSSQL instance.


You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/

Template tooling version used: 0.39