Hi,
We are running Zabbix 7 with proxy servers. We are using the out the box zabbix mssql template, macro have been set for the mssql.user and msssql.password. Zabbix agent 2 and mssql plugin has been installed on the client and permissioned the sql account as per https://git.zabbix.com/projects/ZBX/...at=release/6.4. The conf file of the mssql plugin was also modified , Plugins.MSSQL.Default.Uri=sqlserver://localhost:1433, Plugins.MSSQL.Default.User=domainaccount, and Plugins.MSSQL.Default.Password=password.
The MSSQL zabbix template is slightly modify because it was triggering to many alerts that we did not want to get notified for. Attached image shows the discovery rules changes. The strange thing is it works as expected on 2 of our MSSQL servers, but it does not work on the other 6 MSSQL servers. In the zabbix GUI, I see the host and there's no indication of any error\communication issue with the client. Its detects the operating system, drives, windows services, etc.... but does not detect the database. The correct SQL template is applied to client. have already uninstalled agents and re-installed with the same results. server rebooted as well. Im able to login to sql manager with the sql account and see the databases. Can anyone advise what the issue could be?
Thanks
We are running Zabbix 7 with proxy servers. We are using the out the box zabbix mssql template, macro have been set for the mssql.user and msssql.password. Zabbix agent 2 and mssql plugin has been installed on the client and permissioned the sql account as per https://git.zabbix.com/projects/ZBX/...at=release/6.4. The conf file of the mssql plugin was also modified , Plugins.MSSQL.Default.Uri=sqlserver://localhost:1433, Plugins.MSSQL.Default.User=domainaccount, and Plugins.MSSQL.Default.Password=password.
The MSSQL zabbix template is slightly modify because it was triggering to many alerts that we did not want to get notified for. Attached image shows the discovery rules changes. The strange thing is it works as expected on 2 of our MSSQL servers, but it does not work on the other 6 MSSQL servers. In the zabbix GUI, I see the host and there's no indication of any error\communication issue with the client. Its detects the operating system, drives, windows services, etc.... but does not detect the database. The correct SQL template is applied to client. have already uninstalled agents and re-installed with the same results. server rebooted as well. Im able to login to sql manager with the sql account and see the databases. Can anyone advise what the issue could be?
Thanks
Attached Files