Connect DBeaver to MS SQL Server with Kerberos Ticket Cache in Windows

The easiest way to connect DBeaver to MS SQL Server with Kerberos authentication is Kerberos ticket cache. It requests only 2 steps. The first step is to create Kerberos ticket cache and the second one is to add a new connection to DBeaver with default settings. There are variety of tool in Windows to create Kerberos ticket cache. Also, you can apply different techniques to generate ticket cache.

1. Create Kerberos Ticket Cache File

See Create Ticket Cache File for Kerberos Authentication in Windows article.

2. Add New MS SQL Connection

1. Open New Database Connection wizard from Database menu and select MS SQL Server driver.

   

2. On the next step, replace Host with your server name and choose Kerberos from Authentication list.

   

3. Click Finish button to complete wizard.

4. Next screen will request to download drivers. Just click Download button.

   

5. Be patient, it takes time to retrieve SQL server meta data.

   

3. Upgrade MS SQL Drivers

It's an optional step if you are not able to connect to MS SQL Server.

1. Download Microsoft JDBC Driver for SQL Server

2. Unzip driver and store in C:\Users\windowsuser\AppData\Roaming\DBeaverData\drivers DBeaver settings folder, for example, C:\Users\windowsuser\AppData\Roaming\DBeaverData\drivers\sqljdbc_8.2

3. Edit created connection

   

4. Click Edit Driver Settings button

   

5. Delete all files in Libraries tab

   

6. Click Add File button and select downloaded files

   a) JDBC driver corresponding your java version, for example, java 1.8 - mssql-jdbc-8.2.2.jre8.jar.

   b) Authentication library. It should be 64 bit - mssql-jdbc_auth-8.2.2.x64.dll.

   

7. Click OK button twice to complete setup.

8. Restart DBeaver to apply new drivers.