Login is untrusted domain - Reload fails

[#1]

Hello again.

I get this error in my log when trying to reload a task.

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.

However, I use an login which has access on my SQL database.

So i am not using a windows user, but an SQL user..

[#2]

I think i got it to work - Apparently it didnt register that i changed my credentials. But it does now.

However, when i reload it removes all my scripting??

[Bill_Britt]

Hi,

Gald to see you got it working. If you are reloading using publisher it does remove the script that is put out on the accesspoint. No, there isn't away to stop publisher from doing that.

Bill

[#4]

Okay, now im curious.

If it removes my script - How is anyone able to see my data then?

Cause when it removed my script, it also stops loading data.

Maybe im doing something wrong?

I can post my log file after it removed my script:

Before it removed my log contained all my scriptning, and i was able to see data in qvw file. But now there is only design elements and my expressions.

2013-05-31 12:39:53:      Execution started.

2013-05-31 12:39:53:      QlikView Version:11.20.11922.0

2013-05-31 12:39:53:      CPU Target                    x64

2013-05-31 12:39:53:      Operating System              Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

2013-05-31 12:39:53:      Wow64 mode                    Not using Wow64

2013-05-31 12:39:53:      MDAC Version                  6.1.7601.17514

2013-05-31 12:39:53:      MDAC Full Install Version     6.1.7601.17514

2013-05-31 12:39:53:      PreferredCompression          2

2013-05-31 12:39:53:      EnableParallelReload          1

2013-05-31 12:39:53:      ParallelizeQvdLoads           1

2013-05-31 12:39:53:      AutoSaveAfterReload           0

2013-05-31 12:39:53:      BackupBeforeReload            0

2013-05-31 12:39:53:      EnableFlushLog                0

2013-05-31 12:39:53:      SaveInfoWhenSavingFile        0

2013-05-31 12:39:53:      UserLogfileCharset            1200

2013-05-31 12:39:53:      OdbcLoginTimeout              -1

2013-05-31 12:39:53:      OdbcConnectionTimeout         -1

2013-05-31 12:39:53:      ScriptWantsDbWrite            false

2013-05-31 12:39:53:      ScriptWantsExe                false

2013-05-31 12:39:53:      LogFile CodePage Used:        1200

2013-05-31 12:39:53:       Reload Executed By XXXXXXX\qvadmin

2013-05-31 12:39:53:       Process Executing: QVB

2013-05-31 12:39:53:       Process ID: 4128

2013-05-31 12:39:53:      Execution finished.

[Bill_Britt · Accepted solution]

Hi,

The script is only used to load data. Once the data is loaded and the QVW is published you son't need the script. The Source file will still have the script for future reloads.

Bill

[#6]

But this here is what my source file looks like in my script:

// Write your script here. Note: Reload is disabled upon distribution. Enable by changing the checkbox at Settings->Document preferences->Security->Reload.

Is it because i have set the Documents and Source Doucments to the same path? So it maybe overwrites my Source doucment, and thereby deletes my scripting?

[Bill_Britt]

Yes, you should never so that.

Bill

[#8]

Thanks alot