
Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"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:
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.
- Open the Windows Services.msc
- Right-click on SQL Services
- Open Properties
- 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
8,479 Views
Comments

Specialist
2024-11-26
03:02 PM
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
thanks for sharing this info, very helpful. we have found that using SQL Authentication is the best process for our connections