MSSQL BY ODBC

[thiomed]

Hello everyone, hope you doing good,
I'm new in monitoring and i start using zabbix, i found it usefull and i want to monitor microsoft sql server using zabbix but whene i add the MSSQL BY ODBC themplate i didn't get any information my server, and everything is configured right i'v trying a week now with no solution if you can help,,,,, i'm using zabbix server on debian, and ms sql server is installed on windows server 2012 r2, the connexion between zabbix server and windows server work successfully using zabbix agent or snmp.
Help pls asap

[cyberphantom]

when you try the command: isql -v [your-dsn-here]
what is the return?

[thiomed]

cyberphantom
root@iniqdev:/etc# isql -v medtest
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[ISQL]ERROR: Could not SQLConnect
root@iniqdev:/etc#

but when i use root@iniqdev:/etc# isql medtest sa PassworD1

it work successfully

[cyberphantom]

so isql is working!!
and on your zabbix... did you already changed the template macros (if it have any..but problaby does) values according to your environment?
You can create an item just for test too, with some simple command to your database. Try to create it and use:
item type: database monitor
key: db.odbc.get[,medtest,]
username:your-db-username
password:your-db-password