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.

    DBeaver Select Database Step

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

    DBeaver MS SQL Server Connection Settings Step

  3. Click Finish button to complete wizard.

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

    DBeaver Download Driver Files

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

    DBeaver MS SQL Server Connection Established

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

    DBeaver Edit Connection Context Menu

  4. Click Edit Driver Settings button

    DBeaver MS SQL Server Connection Settings

  5. Delete all files in Libraries tab

    DBeaver Edit MS SQL Server Driver

  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.

    DBeaver MS SQL Server Driver Added

  7. Click OK button twice to complete setup.

  8. Restart DBeaver to apply new drivers.


comments powered by Disqus