Help with ODBC 18

[danatomazett]

Hi. Need help with ODBC


My settings:

• Zabbix Server 7 installed on Debian 12, IP Address: 192.168.99.92
• SQL Server 2012 (11.0) installed on Windows 2012R2 IP: 10.6.52.201

File /etc/odbcinst.ini:
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.4.so.1.1
UsageCount=1

File: /etc/odbc.ini
[CETUS_DTC] Driver=SQLSERVER
Server=tcp:10.6.52.201,1433
Encrypt=YES
TrustServerCertificate=YES
Database=SFINANCEEM

#isql -v CETUS_DTC xxxxx XyXyXyXy
[08001][unixODBC][Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746
[08001][unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection [ISQL]ERROR: Could not SQLConnect

#sqlcmd -S 10.6.52.201 -U xxxxx -P XyXyXyXy
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.

It's not a network error, because traceroute and telnet commands complete without issues

# traceroute 10.6.52.201
traceroute to 10.6.52.201 (10.6.52.201), 30 hops max, 60 byte packets
1 _gateway (192.168.99.1) 0.398 ms 0.385 ms 0.372 ms
2 10.6.30.101 (10.6.30.101) 1.614 ms 2.707 ms 2.106 ms
3 10.6.50.58 (10.6.50.58) 5.633 ms 5.750 ms 5.810 ms
4 10.6.35.29 (10.6.35.29) 1.000 ms 1.017 ms 0.989 ms
5 * 10.6.52.201 (10.6.52.201) 0.989 ms *

# telnet 10.6.52.201 1433
Trying 10.6.52.201...
Connected to 10.6.52.201.
Escape character is '^]'.
^C

Connection closed by foreign host.