Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Access denied on qvw.

Hi All,

I am facing below error while I am created section access on my qvw with NTNAME.

when I am created section access without  NTNAME the qvw file opened but when I put  NTNAME then below error is coming.

Thanks

Prashant

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Prashant,

Not sure why but working fine for me:

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, QVADMIN, 12345, asaini

    USER, QVUSER, 12345, asaini

];

NTNAME I'm using here as my domain name .

Thanks,

AS

View solution in original post

14 Replies
its_anandrjs
Champion III
Champion III

In the script check for

DomainName\Username this are correct for name that you are are accessing the QVW on the system.

Regards

Anand

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In addition, this message can pop up whenever the data is reduced to nothing and strict exclusion has been enabled. But I don't think you're testing data reduction already.

Care to post your Section Access script?

Peter

manojkulkarni
Partner - Specialist II
Partner - Specialist II

Make sure your name or the user name from which you are trying to open QVW is included in section access of application.

Not applicable

your section access credential may be wrong,or there must be something wrong to implement security,find a file in attachment to implement section access

prma7799
Master III
Master III
Author

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, QVADMIN, 12345, Prashantm-PC

    USER, QVUSER, 12345, Prashantm-PC

];

Section Application;

Thanks

Prashant

amit_saini
Master III
Master III

Prashant,

Not sure why but working fine for me:

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, QVADMIN, 12345, asaini

    USER, QVUSER, 12345, asaini

];

NTNAME I'm using here as my domain name .

Thanks,

AS

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Remove USERID and PASSWORD columns (you can do with just the NTNAME and ACCESS fields), and add a windows account name to what looks like just a domainname in the NTNAME field.

As Anand said before, NTNAME should contain two pieces of AD information in the format domainname\accountname. If you omit the domainname, QlikView will use the local domain instead.

Peter

prma7799
Master III
Master III
Author

Hi Amit,

I am also did same thing but still is not working ..

Do the needful.

Thanks

Prashant

amit_saini
Master III
Master III

Could you please  with Prashantm as NTNAME

Thanks

AS