Ad Widget

Collapse

How to monitor MSSQL Database? - Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tewi
    Junior Member
    • Oct 2021
    • 4

    #1

    How to monitor MSSQL Database? - Error

    Hi everyone,
    i had a problem with monitor MSSQL database.

    My configuration:

    odbc.ini

    [CNSV030-OLAP]
    Driver = FreeTDS
    User = zabbix
    Password = Zabix123#
    ServerName = CNSV030-OLAP
    Port = 1433
    TDS_Version = 8.0

    odbcinst.ini

    [ODBC Driver 18 for SQL Server]
    Description=Microsoft ODBC Driver 18 for SQL Server
    Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1
    UsageCount=1

    [ODBC Driver 17 for SQL Server]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1
    UsageCount=1

    [FreeTDS]
    Description = FreeTDS
    Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

    freetds.ini

    # To reduce data sent from server for BLOBs (like TEXT or
    # IMAGE) try setting 'text size' to a reasonable limit
    ; text size = 64512

    # If you experience TLS handshake errors and are using openssl,
    # try adjusting the cipher list (don't surround in double or single quo>
    # openssl ciphers = HIGH:!SSLv2:!aNULL:-DH

    # A typical Sybase server
    [egServer50]
    host = symachine.domain.com
    port = 5000
    tds version = 5.0

    # A typical Microsoft server
    [CNSV030-OLAP]
    host = 10.0.0.30
    port = 1433
    tds version = 8.0


    Errors:

    ubuntu@cnsv041-zabbix:~$ isql CNSV030-OLAP -v
    [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


    But when i do this command i can connect to database:

    ubuntu@cnsv041-zabbix:~$ isql CNSV030-OLAP zabbix Zabix123#
    +---------------------------------------+
    | Connected! |
    | |
    | sql-statement |
    | help [tablename] |
    | quit |
    | |
    +---------------------------------------+
    SQL>


    Please help
    Last edited by tewi; 03-03-2022, 17:03. Reason: #zabbix #mssql #odbc #unixodbc
Working...