DBeaver Kerberos authentication errors: [user; USER] from con properties not available to garner authentication information from the user

In DBeaver’s SQL Server connection, one can use Windows authentication if the computer is joined to the domain and the integrated windows credentials can be used to authenticate to the SQL server. If the computer is not joined to the domain, then one of the alternatives is to use Kerberos authentication. Previously, one can code the User ID and Password in the SQL Server authentication option and switch to Kerberos. However, it seems that this is broken since a recent upgrade in DBeaver, and I am presented with this error:

Kerberos Login Error: Cannot get any of the properties: [user, USER] from con properties not available to garner authentication information from the user

The solution to fix this is to initiate the kinit BEFORE starting the DBeaver application. To initiate the kinit, one will need to open up a command prompt and go to <DBeaver Install Dir>\jre\bin. Run kinit <Kerberos ID> and enter the password in the prompt.

To check that the kerberos ticket is valid, you can use the command klist in the same directory to check if the kerberos token is created. Once the token is available, then you can start the DBeaver application and connect to the data source using Kerberos.

Hope that helps.

Leave a Comment