Connection to MS SQL data source fails with 'Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.'

Problem

When connecting to a Microsoft SQL Server database, the connection fails with Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

Resolution

There could be two reasons causing this issue:

• DBE-15582 ([28000][18452] Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.)
• DBE-23103 (Can't connect with Required Extended Protection and Windows Credentials)

It's suggested to take the following steps into action:

• In the data source Properties under the Advanced tab, set the property USENTLMV2=true:

  

• Alternatively, switch to the JetBrains .NET JDBC driver: