Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have developed one application with section access and deployed that application into server (Without Publisher).
I have scheduled the extractor and application daily at 12AM. Extractor was running successfully but my application was failing. I saw the logs about failing , In the log file i got a message like : Require UserName and Password. I had given NTNAME and Password what i have specified in the section access part. Again it was throwing an error like Bad UserName and Password.
Can anyone help me , Thanks in Advance
Jana
Hi,
Go through this attached document
An Example
SECTION ACCESS;
LOAD
UPPER(Level) AS ACCESS,
UPPER(DomainName) AS NTNAME,
UPPER(PASSWORD) AS PASSWORD
FROM Access.XLSX;
SECTION APPLICATION;
You need to make sure your service account is added to Excel file and his access is define as ADMIN.
Regards
ASHFAQ
Hi Mohammed,
Inline
Access NTNAME Sheet
like this
thanks Ashfaq
Hi,
Can you post your section access script here.
Regards
ASHFAQ
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, DEPT_CODE
ADMIN, xxGROUP\QVADMIN,
USER, xxGROUP\UJANA, 101
];
Section Application;
Hi,
That's good
now modify it as below
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, DEPT_CODE
ADMIN, xxGROUP\QVADMIN,*
ADMIN, xxGROUP\Service Account,*
USER, xxGROUP\UJANA, 101
];
Section Application;
Note:
Here Service Account is the one that you run QlikView Services.
And add service account credentials in that part as specified by Gysbert Wassenaar.
Regards
ASHFAQ
Document open call failed. The document might require username
still i am getting error
Ok
Can you tell me how did you pass credentials.
Did you enter user name Prefixed with domain.
Mydomain\Service account
Regards
ASHFAQ
Hi Mohammed,
I am getting message like the document require userid and password.
I have attached the log file message.
Pls Help me out
Thanks
Janardhan
Hi,
The service account needs to be added to the access list with Admin rights. If you are doing data reduction you also need to put a * in the reduction filed.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, TEST
ADMIN, SERVICEACCOUNT, *
USER, USER1, RED
USER, USER2, WHITE
];
Section Application;
bILL