MS-SQL Database Query Monitors

[deepaks]

Hi Friends,

I want to monitor MS-SQL Database by running remote database queries on the host from zabbix. I found something like "Database monitor" type in items section, but want someone to help me this.
How to configure items?
How to configure items on those items?

Thanks in advance.

[Colttt]

hello,

at first you need to install unixodbc on you distribution, and also a ms-sql-odbc-driver

if that conection works (you can try it with the command 'isql' ) than you can query this database in zabbix with the item database monitor.

further information:

https://www.zabbix.com/documentation/2.2/manual/config/items/itemtypes/odbc_checks

and an how-to:

http://lab4.org/wiki/Zabbix_Database_Monitor_English

[deepaks]

Hi Colttt,

I had installed the required drivers, but when I am trying to run isql command from server its showing me

isql -v DSN USERNAME PASSWORD

[S1000][unixODBC][Oracle][ODBC][ORA]ORA-12541: TNS:no listener
[ISQL]ERROR: Could not SQLConnect

Kindly what I should do to solve this issue.

Thanks in advance.