SQL Server error monitoring

[Eric25]

Hi.
Running zabbix server in a virtual machine running ubuntu. I installed an agent on windows and a host in zabbix server where I entered the IP address of the computer with the agent installed and the "windows by Zabbix agent" template. Currently the agent is downloading data from windows and I can browse them.
To monitor the SQL server on windows, I used this guide, i.e. I added the MSSQL DB by ODBC template to the host with the windows agent:
https://www.zabbix.com/integrations/microsoft_sql where I did the following points:
1) Using SSMS, I added a zabbix user with zabbix password and permissions View Server State and View Any Definition
2) I set up macros for login: zabbix and password: zabbix that I created earlier
I added a Microsoft ODBC driver using the Dockerfile
Dockerfile:

FROM zabbix / zabbix-server-pgsql: ubuntu-5.2-latest
USER root
RUN apt-get update
RUN apt-get -y install sudo
RUN sudo apt-get install curl
RUN sudo apt-get install -y gnupg2
RUN sudo curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
RUN sudo curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list> /etc/apt/sources.list.d/mssql-release.list
RUN sudo apt-get update
RUN sudo ACCEPT_EULA = Y apt-get install msodbcsql17

Docker-compose.yaml:

....
services:
zabbix-server:
build:
context:.
dockerfile: Dockerfile
ports:
- "10051: 10051"
....

3) I set values for macros
{$ MSSQL.INSTANCE} (using SSMS) MSSQL value $ DESKTOP-BGU8MRS \ SQLEXPRESS

The {$ MSSQL.PORT} macros have the default value of 1433 and the {HOSC.CONN} macros without the $ sign I could not add.

My problem is that I can't get any data from SQL Server and I keep getting the following error: The TCP port of the Ms SQL Server Service is currently unavailable.
I am asking for advice, what I am doing incorrectly, that I cannot read data from SQL Server


@Edit

In windows I added ODBC configuration where I set Data Source Name to sqlEryk and I set the same name in macro DSN. The problem is still the same

[Eric25]

no one has encountered such a problem?

[bitviper]

Hi Eric

were you able to resolve this issue?
I seem to have the same problem where MSSQL: Service's TCP port state is down.
I've setup the zabbix on a centos 8 and sql server on a windows 10. both on vmware workstation.
I did follow the guide provided by zabbix but can't seem to get it to work.