"The login is from an untrusted domain and cannot be used with Windows authentication" when connecting to Microsoft SQL server

[Daniele_Purrone]

When connecting to a Microsoft SQL database from an untrusted domain, the result is a The login is from an untrusted domain and cannot be used with Windows authentication error.

Resolution

A possible two solutions exist. Choose one of the below:

Option One

If using Windows Authentication.

1. Open the Windows Services.msc
2. Right-click on SQL Services
3. Open Properties
4. Change Log On As from from Local System Account to an account with Local Administrator permissions which is set up with the correct permissions on both Qlik Sense and the SQL server. This account must have Log on locally security permission.

Option Two

Use SQL authentication.

Rather than using using Windows Authentication connecting to the SQL server, use SQL Authentication. 

For more information, see Choose an authentication mode.

Environment

• Qlik Sense Enterprise on Windows, any

[Ken_T]

thanks for sharing this info, very helpful.  we have found that using SQL Authentication is the best process for our connections