topic Re: User is asked for credentials second time still unable to go beyond the login screen in Reporting Service & Alerting

User is asked for credentials second time still unable to go beyond the login screen

PavankumarL — Wed, 13 Apr 2022 15:14:58 GMT

Hi all...h

I have a production issue that I need help on. A user can get into the Qlikview menu but once in the system she is asked for her credentials a second time and can’t get beyond that screen…

Please help me to fix the issue ... Thanks in advance.

Re: User is asked for credentials second time still unable to go beyond the login screen

vinieme12 — Mon, 18 Apr 2022 07:13:04 GMT

The App has section access defined with User and Password columns, you just need to use NTNAME, remove password from section access

Re: User is asked for credentials second time still unable to go beyond the login screen

Daniele_Purrone — Wed, 20 Apr 2022 05:24:01 GMT

Hi @PavankumarL

the login form you are seeing is a Section Access login form, which a security feature specific to the application. As @vinieme12 wrote, you will need to make sure that she is added to the document's section access table. If you want her to just come in as her active directory user, without having to enter a passwor d, you just need to use NTNAME.
More info here and here.

Cheers!

Re: User is asked for credentials second time still unable to go beyond the login screen

PavankumarL — Wed, 11 May 2022 11:12:47 GMT

Thank you for your response ....

I am posting the section access code here for your reference kindly guide me through the same...

-------------------------

USERTABLE:
LOAD
RECNO() as PERSONID,
'USER' as ACCESS,
'*' as USERID,
'*' as PASSWORD,

[NT USER] as NTNAME,

Global as GLOBAL,
Divisional as DIVISION,
Divisional2 as DIVISION2,
Site1 as Site1,
Site2 as Site2,
Site3 as Site3,
Site4 as Site4,
Site5 as Site5,
Kam as KAM,
Salesrep as SALESREP,
[Sales Manager] as SM

FROM
$(QVDRoot)SEQURITY\Security.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Section Access;
STAR is *;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, LEVEL1
ADMIN, QLIKVIEW2017, PASS, *,
ADMIN, *, *, QLIK,
ADMIN, *, *, QVLOAD,
USER, GLOBAL, *, *,
USER, DIVISION, *, *, 1
USER, DIVISION2, *, *, 1
USER, Site1, *, *, 6
USER, Site2, *, *, 6
USER, Site3, *, *, 6
USER, Site4, *, *, 6
USER, Site5, *, *, 6
USER, KAM, *, *, 5
USER, SALESREP, *, *, 4];

LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
' ' as LEVEL1
RESIDENT USERTABLE
WHERE GLOBAL='Y';

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE (NOT GLOBAL='Y') and (LEN(SALESREP) > 0 or LEN(KAM) > 0);

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(DIVISION) > 0 or LEN(DIVISION2) > 0;

LOAD
ACCESS,
USERID as USERID,
PASSWORD as PASSWORD,
NTNAME as NTNAME,
PERSONID as LEVEL1
RESIDENT USERTABLE
WHERE LEN(Site1) > 0 or LEN(Site2) > 0 or LEN(Site3) > 0 or LEN(Site4) > 0 or LEN(Site5) > 0;

Section Application;

--------------------------------------------

Re: User is asked for credentials second time still unable to go beyond the login screen

PavankumarL — Wed, 11 May 2022 11:19:30 GMT

Thank you for your response ....

I am posting the section access code here for your reference kindly guide me through the same...

The particular user id is "Global"

-------------------------

USERTABLE:
LOAD
RECNO() as PERSONID,
'USER' as ACCESS,
'*' as USERID,
'*' as PASSWORD,

[NT USER] as NTNAME,

FROM
$(QVDRoot)SEQURITY\Security.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Section Access;
STAR is *;

LOAD
ACCESS,
USERID,
PASSWORD,
NTNAME,
' ' as LEVEL1
RESIDENT USERTABLE
WHERE GLOBAL='Y';

--------------------------------------------