-
Change Request
-
Resolution: Unresolved
-
High
-
None
-
5.4.9
-
None
-
Virtual machin on Debian10
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?