Cannot use Windows Credentials since 2022 versions

Answered

Hi,

Before I updated to Datagrid and Rider 2022, I was able to connect to SQL Server using windows credentials. Since the update, the option is not available anymore. Any idea how to fix this ?

6 comments
Comment actions Permalink
Official comment

Hello,

It is a known issue, please see DBE-15456. The fix will be available in the next minor version which is scheduled to Friday.

As a temporary workaround, you can rollback to 2022.1.1 version (https://www.jetbrains.com/datagrip/download/other.html).

Comment actions Permalink

I have the same issue. Their documentation for Microsoft SQL Server as of April 2022 and for version 2022.1 says this:

But as you can see, it's literally not an option:

1
Comment actions Permalink

Mine only shows this

1
Comment actions Permalink

Was having exactly the same issue, @Nwkent mention of jetbrains documentation saying to use the JTds driver helped me.

To fix it I had to

1. Select Microsoft SQL Server (jTds) as the driver

2. Select No Auth as the authentication

Feels abit odd it being called No Auth its not exactly obvious I would have to select that for it to connect with windows credentials

1
Comment actions Permalink

When will the update be released? Daniil Maslov said Friday, but it's Monday now and no update. Thanks.

0
Comment actions Permalink

Jeff Prater, update is available. You can download a new version of DataGrip from https://www.jetbrains.com/datagrip/download/

Update for Toolbox installation will be available a bit later today.

Sorry for the inconvenience.

0

Please sign in to leave a comment.