Steps to reproduce:

1. Install Zabbix Agent2 on Zabbix Host
2. Install Zabbix MSSQL Plugin on Zabbix Host
3. Add a SQL Server host
4. Add the MSSQL by Zabbix agent2 Template
5. Fill out the SQL Server host specific Macros

Result:
The TCP port monitoring item check always fails.

Expected:
The TCP port item check should not fail, as the agent is successfully connecting and polling the database.

SOLUTION:

1. The template needs an additional macro:
{$MSSQL.HOSTNAME}

2. The item in the template should use the following key instead:
net.tcp.service[tcp,\{$MSSQL.HOSTNAME},\{$MSSQL.PORT}]