Qlik® | Support Portal
Quick Links
Contact
Find Answers

Join Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support knowledge database or request assisted support for your highly complex issues.

Submit a Case
Talk with a Representative

Critical Issues

Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.

Contact Us
My Account
Welcome Guest
×
Knowledge

Error: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

Article Number: 000004106 | Last Modified: 2018/06/12

Description

A QlikView Publisher reload task fails on a reload with the below error in the document/script log:
"ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."




Cause

Using local account to operate between machines.

Resolution

This error indicates an authentication issue to the MicroSoft SQL Server and is not a QlikView error. For more information see Microsoft knowledge base article 555332
  • Ensure that the account which is being used to access SQL Server is a domain account.
    • If the account being used is a local account on the client machine, then this error message will occur because the SQL Server machine and the Domain Controller cannot recognize a local account on a different machine.
    • The next step for this is to create a domain account, give it he appropriate access rights to SQL Server, and hen use that domain account to run the client application. 

Was this content helpful?

   

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case
Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.