Ad Widget

Collapse

Run sql query for MSSQL Databases

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • benzer
    Junior Member
    • Aug 2020
    • 3

    #1

    Run sql query for MSSQL Databases

    I am new to zabbix and I am trying to create an Item with "Database monitor" type.

    On the Server there is Version 5.0.2 installed and on the Host Agent Version 5.0.2. So Active Checks are running well.
    ODBC Driver is also installed on the Zabbix server:

    --> /etc/odbcinst.ini
    Code:
     [ODBC Driver 17 for SQL Server]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1
    UsageCount=1
    Now which "Database driver" is needed for data source definition?
    --> /etc/odbc.ini
    Code:
    [test]
    Description = MSSQL test
    Database Driver = ??  
    Server = 127.0.0.1
    User = xxx
    Password = xxx
    Port = 143
    Thank you
Working...