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 :
As you can see we use Kerberos authentication
odbcinst.ini:
So we tried to connect from the server
No problem!!
now when we apply the model on a mssql host
here is what I get:
As if the he didn't want to connect via kerberos but only from zabbix because from RAS server.
Could you help me?
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
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>
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]
Could you help me?
Comment