topic Re: Error on Reload Engine in QlikView

Error on Reload Engine

Mon, 26 Jan 2026 18:19:17 GMT

Hi There,

I have just set up Qlikview Server, I loaded QV desktop on the server to test reloads of the models from the server etc. When refreshing from Desktop on the New Server there are no errors and reload runs smoothly, as soon as i create a task for this model and try to set it to refresh every Hour it gives me an error, i had a look at the log file and got this:

13/10/01: Reload Executed By SV-QLIK2\administrator

13/10/01: Process Executing: QVB

13/10/01: Process ID: 12164

13/10/01: 0002 SET ThousandSep=','

13/10/01: 0003 SET DecimalSep='.'

13/10/01: 0004 SET MoneyThousandSep=','

13/10/01: 0005 SET MoneyDecimalSep=','

13/10/01: 0006 SET MoneyFormat='R #,##0,00;R-#,##0,00'

13/10/01: 0007 SET TimeFormat='hh:mm:ss'

13/10/01: 0008 SET DateFormat='YY/MM/DD'

13/10/01: 0009 SET TimestampFormat='YY/MM/DD'

13/10/01: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

13/10/01: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

13/10/01: 0013 directory D:\QlikView\QVData\PSP

13/10/01: 0063 ODBC CONNECT*

13/10/01: Error: SQL##f - SqlState: 28000, ErrorCode: 18452, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

13/10/01: General Script Error

13/10/01: Execution Failed

13/10/01: Execution finished.

Please advise, help is much appreciated.

Thanks.

Re: Error on Reload Engine

Tue, 01 Oct 2013 13:01:13 GMT

Obviously an error with the connection. Are you running this fine on your machine? This will be because you have the driver and authenication set up on your machine. You need to replicate this on the server itself - i.e. it looks like you need to install the driver on the Server. .

Hopefully that will get you up and running.

Steve

Re: Error on Reload Engine

Tue, 01 Oct 2013 13:06:45 GMT

Hi Steve, no i'm refreshing it manually from the server using Qlikview Desktop. When i set it to Automatically Reload using Reload Engine it gives me the error, Gives me errors if i use both OLE DB and ODBC connections. I'm sure it's got something to do with Server authentication?

Re: Error on Reload Engine

Bill_Britt — Tue, 01 Oct 2013 13:08:11 GMT

This is an issue with connectivity and ODBC. If you google the error you will find things to check on the SQL side.

Bill

Re: Error on Reload Engine

senpradip007 — Tue, 01 Oct 2013 13:09:27 GMT

Hi,

It shows that the error is generated due to ODBC connection. First you create a DSN and then go for the reload schedule. Hope it will help.

Best regards.

Re: Error on Reload Engine

Tue, 01 Oct 2013 13:17:32 GMT

Hi Richard

It could be that Qlikview is authenticating on your username when you run via desktop, but is using the QV administrator account when authenticating via the QMEC. Do all accounts have access to your source?

I'm a little outside my comfort zone here, but I remember suffering a similar issue a couple of years ago myself.

Regards

Steve

Re: Error on Reload Engine

Peter_Cammaert — Wed, 02 Oct 2013 08:19:42 GMT

From the error message, I get that SQL Server is refusing your login attempt (no problem with ODBC here) because the domain from which you try to login is not trusted. SQL Server is probably configured to use Windows authentication instead of SQL Server authentication. This means that SQL server uses sort of SSO to let you in.

When you do a desktop reload on the server, you're probably logged in into the same Windows domain (or at least a trusted one) as the SQL server, but QVS isn't. Have the QlikView services been configured to run under a local (e.g. machine) account?

Just a guess.

Peter

Re: Error on Reload Engine

Wed, 02 Oct 2013 11:52:48 GMT

You were spot on Steve, thanks. I changed the user account accessing the services to the Account i was logged in as. Everything is working fine.

Thank you for pointing me in the right direction.

Re: Error on Reload Engine

Wed, 02 Oct 2013 12:07:16 GMT

Glad I could provide a helpful answer.

All the best

Steve

Re: Error on Reload Engine

pentaxadmin — Wed, 27 Dec 2017 17:26:49 GMT

Had the same issue. Thanks for finding a solution. I was wondering if I can switch QS Services back to QSAdmin user account now? Have you tried it?

Re: Error on Reload Engine

sanchayan — Wed, 27 Dec 2017 18:35:44 GMT

Hi Richard,

As Peter pointed out that correctly may be the issue. So do one thing :

Make sure DSN to the DB is created in your server performing the reload
The credentials used in the DSN must be the one which is used to run the qlikview services.
On the server open a new qlikview document and try to Connect to the SQL DB using ODBC connection. (obviously use the same credentials which is used in the DSN to connect to the SQL DB i.e. the one which is running the qlikview services).
If the connection is successful, then copy this Connection string into the qlikview document where you are getting the error and this time I am sure it will connect.
If the connection is unsuccessful then make sure that the qlikview service account has authentication to connect to the SQL DB.

Regards,

Sanchayan