Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW

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

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniele_Purrone
Support

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

Last Update:

May 28, 2024 3:10:12 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 14, 2021 4:48:17 AM

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

 

 

Labels (1)
Comments
Ken_T
Specialist

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