Skip to main content

Allow Windows authentication using SQL Server driver with DBeaver

DBeaver will allow Microsoft Windows single sign on access when connecting to Microsoft SQL Server using the SQL Server driver (rather than jTDS).  From the driver properties settings, set the integratedSecurity flag to true.

Open the Connection configuration panel and choose the Driver properties section.

Set the integratedSecurity flag to true.


A subtle, but important step is to not provide username and password credentials to the connection.

Comments

  1. Thanks! This worked like a charm.

    ReplyDelete
    Replies
    1. I'm glad it worked for you. I appreciate the confirmation.

      Delete
  2. Yup, this worked wonderfully for me as well!

    ReplyDelete
    Replies
    1. This post is a few years old now, but it seems to still be relevant. Thanks for posting!

      Delete
    2. Now DBeaver supports Windows authentication in MS SQL Server without such the tricks: https://github.com/dbeaver/dbeaver/issues/2077

      Delete
    3. Correct! It's a checkbox in the connection window now. This article is due for an update to mention that.

      Delete
  3. hello, thanks for tips, solve my problem with DBeaver + MS SQL Server

    very good!

    ReplyDelete

Post a Comment