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.
Labels:

Comments

  1. UnknownAugust 1, 2017 at 3:47 PM

    Thanks! This worked like a charm.

    ReplyDelete
    Replies
    1. Scott OrsburnAugust 1, 2017 at 3:49 PM

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

      Delete
  2. UnknownOctober 2, 2017 at 11:26 AM

    Yup, this worked wonderfully for me as well!

    ReplyDelete
    Replies
    1. Scott OrsburnOctober 2, 2017 at 2:07 PM

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

      Delete
    2. UnknownJanuary 18, 2018 at 10:17 AM

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

      Delete
    3. Scott OrsburnJanuary 18, 2018 at 10:20 AM

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

      Delete
  3. LacerdaOctober 13, 2017 at 10:38 AM

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

    very good!

    ReplyDelete

Post a Comment

Popular posts from this blog

Skype Now Supports Emergency Calls In the US

With the latest round of updates to Skype , it was noticed today that the instant messaging and VoIP phone service now supports emergency calling in the United States. The release notes for the most recent update to the Android version of Skype indicated that the service now allows calls to be made to US emergency calling systems via 911.  Telephony services like Skype, Google Voice , and Vonage typically don't offer this emergency calling ability without some sort of intermediate step like deferring to the phone's default dialer, as is the case with Voice, or setting up a physical address location ahead of time which is how Vonage handles it. The indication is that Skype will handle the 911 calls natively, but when verifying with an account that does not have a Skype phone number assigned to it, it was found that the instructions in the FAQ explaining how to turn on emergency calling are not accurate. Emergency calling support in Skype for the United States Interestingly, th...
Post a Comment
Read more

Chrome Itself Logs Into Google When Logged Into Company's Services

Google has taken the liberty of logging Chrome into the user's account whenever logged in to any Google service. Some time ago, Google introduced the ability to have its browser, Chrome, log into the user's Google account whenever the user authenticated for any Google service.  That is, log in to Google Docs, for example, and the browser would be logged in as well. The pitch was that this relationship between being logged in to a service and the browser also being logged in, can help mitigate confusion when a user logs out of a Google service but fails to realize the browser is still logged in.  The mystery can be eliminated if the browser keeps the two in the same state automatically. There is the added benefit that the browser would be better able to synchronize the user experience across each browser that was also logged into the user's account. For example, Chrome on a mobile device could have access to the history from Chrome on a laptop. The idea is not nove...
Post a Comment
Read more