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.