I am trying to connect to SQLSERVER database from Metabase running on Debian.
I searched through the forums before and found the issue with Java authenicating to Kerberos , but this doesn’t work for my situation.
Niether the Windows Server with SQLSERVER or the Debian Metabase machine are on a domain
I have a krb.conf file on the Debian machine, and have used the IP Address for the SQLSERVER machine.
The JDBC auth is - trustServerCertificate=true;intergratedSecurity=true;authenticationScheme=JavaKerberos
The error message I recieve is -
message “com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database “*********” requested by the login. The login failed. ClientConnectionId:89367a15-719c-4729-b877-789d6dd7f82e”} - I have redacted the name of the server with asteriks