MSSQL Server with Windows Credentials failing (DataGrip 2023.2.2)
Trying to connect to an MSSQL server with windows credentials is failing. Standard user/pwd auth works, so it is not a connection problem. Also: windows credentials works with Idera Rapid SQL and Microsoft SQL Server Manager.
请先登录再写评论。
https://youtrack.jetbrains.com/issue/DBE-15582/2800018452-Login-failed.-The-login-is-from-an-untrusted-domain-and-cannot-be-used-with-Integrated-authentication.
https://youtrack.jetbrains.com/issue/DBE-23103/Cant-connect-with-Required-Extended-Protection-and-Windows-Credentials
See if the following suggestions work:
1. In the data source properties under Advanced tab, set the following property `USENTLMV2=true`
2. Switch to Jetbrains .Net JDBC drivers as shown here (https://youtrack.jetbrains.com/issue/DBE-23103/Cant-connect-with-Required-Extended-Protection-and-Windows-Credentials#focus=Change-27-11896813.0-0)