topic Re: SSO doesn't work when changing Excel to QVD in QlikView

SSO doesn't work when changing Excel to QVD

dafnis14 — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We use SSO, where the users data are retrieved from Excel. Everything is running fine.

I have created a QVD file based on the Excel. But, when loading the users data from QVD, the SSO doesn't work, and the user is prompt

for the application user & password.

Here is the script:

Supps:
LOAD ACCESS,
USERID,
PASSWORD,
SERIAL,
NTNAME,
SUPPCODE
FROM
[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]
(qvd);

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SERIAL, NTNAME, SUPPCODE

…..Deleted

];

Concatenate

LOAD

ACCESS,

USERID,
SERIAL,
PASSWORD,
NTNAME,
SUPPCODE

Resident Supps;

Section Application;

STAR is *;
DROP Table Supps;

Does anyone have an idea why using the QVD disables the SSO?

Thsnks!

Re: SSO doesn't work when changing Excel to QVD

Clever_Anjos — Thu, 17 Dec 2015 14:51:10 GMT

You can´t access a table from a Application Section inside a Section Access, your should move your qvd load to inside "Section Access"

…..Deleted

];

Concatenate

LOAD

ACCESS,

USERID,
SERIAL,
PASSWORD,
NTNAME,
SUPPCODE

Resident Supps; // This will not work because this table was created outside Section Access

Section Application;

STAR is *;
DROP Table Supps;

Re: SSO doesn't work when changing Excel to QVD

dafnis14 — Thu, 17 Dec 2015 16:45:51 GMT

Hi,

I had to do that after receiving general script error..

I can't understand why..

Thanks!

17/12/2015 18:42:26: 0065 Concatenate

17/12/2015 18:42:26: 0066 LOAD ACCESS,

17/12/2015 18:42:26: 0067 USERID,

17/12/2015 18:42:26: 0068 PASSWORD,

17/12/2015 18:42:26: 0069 SERIAL,

17/12/2015 18:42:26: 0070 NTNAME,

17/12/2015 18:42:26: 0071 SUPPCODE

17/12/2015 18:42:26: 0072 FROM

17/12/2015 18:42:26: 0073 [..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]

17/12/2015 18:42:26: 0074 (qvd)

17/12/2015 18:42:26: 6 fields found: ACCESS, USERID, PASSWORD, SERIAL, NTNAME, SUPPCODE, General Script Error

17/12/2015 18:42:26: Execution Failed

17/12/2015 18:42:26: Execution finished.

Re: SSO doesn't work when changing Excel to QVD

dafnis14 — Fri, 18 Dec 2015 17:53:00 GMT

I found the solution here:

Section Access Reload from QVD fails

loaded the section access table in an unoptimized form:

FROM
[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]
(qvd) Where 1=1;