topic Re: Section Acess in QlikView

Section Acess

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

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

Re: Section Acess

Gysbert_Wassenaar — Wed, 03 Sep 2014 09:18:12 GMT

Did you enable the option Section Access on the Reload page for the document in the QMC and entered the user name and password there too?

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:23:32 GMT

Hi,

In this case make sure your service account belongs to Section access admin access.

If not please add it to admin.

Regards

ASHFAQ

Re: Section Acess

janardhan — Wed, 03 Sep 2014 09:25:33 GMT

Hi Gysbert ,

Thanks for reply , i have enabled the Section access and after that i had given NTNAME and Password.

still i m getting error like Bad UserName , Password. I have one doubt , in QMC Section Access part , what should be the username and password.

Jana

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:29:38 GMT

Hi,

It should be one of admin account of your section access. if you use inline or normal section access.

If you use Section access with NTLM authorization, Make sure to define/ add your service account to your Section access admin.

Regards

ASHFAQ

Re: Section Acess

janardhan — Wed, 03 Sep 2014 09:30:08 GMT

Hi Mohammed,

can u please explain about (service ACCOUNT)

Jana

Re: Section Acess

Gysbert_Wassenaar — Wed, 03 Sep 2014 09:31:22 GMT

Try including the domain name too: MYDOMAIN\MyUser. And perhaps the case is important too. MYUSER or myuser instead of MyUser maybe.

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:31:32 GMT

Hi,

Can you tell me what kind of section access you apply.

Service account is the one with which you run your QlikView services.

Regards

ASHFAQ

Re: Section Acess

deepakqlikview_123 — Wed, 03 Sep 2014 09:33:26 GMT

Hi Ashfaq,

can you please tell me how to add admin access.

thanks,

Re: Section Acess

janardhan — Wed, 03 Sep 2014 09:36:56 GMT

Hi Gysbert,

whatever u said i tried earlier , like with domain name and also without domain , still its not working

Re: Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:37:58 GMT

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

Re: Section Acess

janardhan — Wed, 03 Sep 2014 09:41:34 GMT

Hi Mohammed,

Inline

Access NTNAME Sheet

like this

Re: Section Acess

deepakqlikview_123 — Wed, 03 Sep 2014 09:43:06 GMT

thanks Ashfaq

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:43:52 GMT

Hi,

Can you post your section access script here.

Regards

ASHFAQ

Re: Section Acess

janardhan — Wed, 03 Sep 2014 09:49:08 GMT

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, DEPT_CODE

ADMIN, xxGROUP\QVADMIN,

USER, xxGROUP\UJANA, 101

];

Section Application;

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 09:55:01 GMT

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

Re: Section Acess

janardhan — Wed, 03 Sep 2014 10:15:56 GMT

Document open call failed. The document might require username

still i am getting error

Re: Section Acess

ashfaq_haseeb — Wed, 03 Sep 2014 10:20:39 GMT

Can you tell me how did you pass credentials.

Did you enter user name Prefixed with domain.

Mydomain\Service account

Regards

ASHFAQ

Re: Re: Section Acess

janardhan — Thu, 18 Sep 2014 16:53:07 GMT

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

Re: Section Acess

Bill_Britt — Fri, 19 Sep 2014 02:13:34 GMT

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