Ad Widget

Collapse

connection ODBC MSSQL kerberos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fadas
    Junior Member
    • Feb 2020
    • 4

    #1

    connection ODBC MSSQL kerberos

    Hello everyone,

    We want to monitor our mssql database via the official zabbix template here
    To do this we have therefore configured the ODBC connection from our server

    odbc.ini :
    Code:
    [SQLSI]
    Driver = ODBC Driver 17 for SQL Server
    Description = ODBC connection via ODBC Driver 17 for SQL Server
    Trace = Yes
    TraceFile = /tmp/odbc.ini.log
    Server = serv-sqlsi
    Port = 1433
    Trusted_Connection=yes
    As you can see we use Kerberos authentication

    odbcinst.ini:
    Code:
    [ODBC Driver 17 for SQL Server]
    Description=Microsoft ODBC Driver 17 for SQL Server
    Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.8.so.1.1
    UsageCount=1

    So we tried to connect from the server
    Code:
    #isql SQLSI -v $USER $PASSWORD
    +---------------------------------------+
    | Connected! |
    | |
    | sql-statement |
    | help [tablename] |
    | quit |
    | |
    +---------------------------------------+
    SQL>
    No problem!!

    now when we apply the model on a mssql host
    here is what I get:

    Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][851968][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]SSPI Provider: No Kerberos credentials available (default cache: FILE:/tmp/]|[HY000][851968][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context]
    As if the he didn't want to connect via kerberos but only from zabbix because from RAS server.

    Could you help me?
    Last edited by fadas; 09-02-2022, 09:28.
  • fadas
    Junior Member
    • Feb 2020
    • 4

    #2
    i have send a request to the official site

    Comment

    Working...