Zabbix Agent2 - Template: How to connect to MSSQL Named instance

[mike_a]

Hi all,

Has anyone had success monitoring a SQL Server named instance? I've tried adding each specific server name, along with the service name, but no luck.

The MSSQL.URI I've tried to use is: sqlserver://localhost\<named instance name>:<port number>
I also replaced local host with the instance (e.g. sqlserver://db-test\test01:1433)

The Zabbix agent error I receive is: Get Value from agent failed: cannot establish TCP connection to <IP>:10050 timed out

[Brambo]

My experience is use either the /instance OR port number not both. Maybe that helps (my instance has it's own port so using both fails)

[mike_a]

Thanks for the feedback! I tried, but we also use a non-default port #. I've tried variations of <server>/<instance> for the URI, along with <Server>:<port>, but no luck.