Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniele_Purrone
Support
Support

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

Last Update:

Apr 14, 2021 4:48:17 AM

Updated By:

Daniele_Purrone

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.

 

Environment

 

Resolution

You must use either of the following to authenticate correctly:

  • Go to Services.msc, right click on SQL Services and go to properties, change Log On as “Local System Account” or “NT Authentication”.
  • An NT account with Local Administrator permissions that can authenticate on Qlik Sense or any Qlik Applications, Local Administrator permissions must include Log on locally security permission.
  • SQL authentication.
    Workaround:
    To connect to SQL Server, use SQL Authentication instead of Windows Authentication.

 

Cause:

This is a limitation on Microsoft's side. For more information, see http://technet.microsoft.com/en-us/library/ms144284.aspx.

 

 

Labels (1)
Version history
Last update:
‎2021-04-14 04:48 AM
Updated by: