Cannot use Windows Credentials since 2022 versions Follow
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 ?
Please sign in to leave a 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).
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:

Mine only shows this
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
When will the update be released? Daniil Maslov said Friday, but it's Monday now and no update. Thanks.
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.