Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have a document with section access based on NTNAME (not user and password)
based on the above a key field is being reduced to a certain value, or not if you are admin ('*')
the document won't reload and i learned there is a need to check the 'Section Access' checkbox as seen below.
what i don't know is:
1. what should i enter as user name and password? user name is for the QVS user ("Log on as"), right?
2. but what about the password? which password?
3. what about the section access? does this user also has to be part of the section access code?
4. does all of this is a MUST?
If you are using NTNAME (as outlined in your original posting), then you don't need to add a name and password into QMC. You need to include the server service account (the account under which publisher/QV server runs) in the section access list for the document.
If you are using server reloads you need to have the service account that QVS is running in Section Access as an ADMIN.
thanks Anil for the quick reply
i understood and as I meant, ADMIN is the user that log on as the QVS service.
BUT
1. what should be entered as password?
2. does ADMIN should be part of the section access code?
(assume that there are 10 users, hence 10 lines at the section access, 3 are managers which can view ALL Department field so they have '*' and the 7 other users are employees which allowed only for their Department so they have their value at the section access)
-> should i add another line to the section access for the 'user' ADMIN?
I would suggest to write it in the hidden script and at the reload Task you've to enable the Section Access and provide the User Name and Password.
And then try to use the Admin Password from your Section Access
hi again Anil, you wrote
"and at the reload Task you've to enable the Section Access and provide the User Name and Password"
but which password? does ADMIN becomes a user of the document, and hence, needs his own line at the section access?
Can you please confirm me, What do you want to achieve.
How is your Section access looking?
i have a document with section access.
i want to schdule its reload process via QMC task
on the machine i have user called Qlikviewadmin which logged on as the user for the QVS service (execute the tasks).
my question are:
1. what should i write in the password textbox at the reload tab (QMC)?
2. should I add another line to the section access code? see below the code i have (example)
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, COMPANY2
ADMIN, *, *, DOMAIN\Manager1, *
ADMIN, *, *, DOMAIN\Manager2, *
ADMIN, *, *, DOMAIN\Employee1, Dep1
ADMIN, *, *, DOMAIN\Employee2, Dep2
ADMIN, *, *, DOMAIN\Employee3, Dep3
Shay raber,
If you are using server reloads you have to have the service account that QVS is running in Section Access as an ADMIN.
Incase if you dont know how to find service account refer the below screenshot.
Refer this thread for screenshot and explanation Qlikview server won't load a document with Section Access
and refer Server reload problem with section access | Qlik Community
Regards,
Siva
If you are using NTNAME (as outlined in your original posting), then you don't need to add a name and password into QMC. You need to include the server service account (the account under which publisher/QV server runs) in the section access list for the document.
thanks shankarece,
i know which user is running the QVS service.
what i don't know is if I have to check the 'section access' checkbox or not? and if so, what would be the password?
secondly, i don't know if i have to include that user in the section access script?