Section Access problem when using external log in via Redhat / Lifray

[#1]

Hi, we are changing our document from using solely an excel sheet for section access to using a combined excel and database.  The reason for this is that we need local developers to have access as well as the users externally.

The code I have in loading the section access is

Section Access;

LOAD
COMPANYCODE,
NTNAME,
Upper(trim ("SCOPE")) as SCOPE,
Upper(trim( "ACCESS_")) as ACCESS,
SURNAME,
FORENAME
  ;
SQL SELECT *
FROM "CT_PORTAL_UAT_DUP1".QVSECTIONACCESS
;

 

Concatenate


LOAD NTNAME,
upper(trim(SCOPE)) as SCOPE,
ACCESS as ACCESS
FROM
[..\New_Qlikview_Live\Shared\Source\Security\Qlikview Access_XX_ONLY_test.xlsx]
(ooxml, embedded labels, table is Sheet3);

Section Application;

When we test a user logging in tot he external portal  that is listed in excel, they authenticate straight away, however the user logging in who is in the database gets a lo in pop up box. 

Do you think it is the Qlikview document or setting, or do you think it is connected to the external authentication.

Any advise would be appreciated