topic Re: Section access with ntname in QlikView

Section access with ntname

dbonilla — Fri, 19 Feb 2016 14:32:48 GMT

I trying to deploy an app with section access, but I'm having different behavior when opening in server.

I configured a file with : ACCESS,NTNAME,PASSWORD

when I open with my desktop client qlik it recognize my ntusername, but when opening on server it requests userid, but I did not have this field in my access file.

How could I fix this.?

Re: Section access with ntname

agni_gold — Sat, 20 Feb 2016 14:18:32 GMT

Can you please post your section access script?

Re: Section access with ntname

cristiand — Sat, 20 Feb 2016 15:57:02 GMT

Hello.

Have you included the domain name in the NTNAME field?

Are your server credentials based on NT?
When using section access with NTNAME you need to include the PC name in that field

For example, you should have this two lines/"users":
PERSONALPC\JOSE
SERVERNAME\JOSE

Depending on your implementation you don't need to include Password field. If the user is already logged into the server using NT credentials you should avoid it.

For example, you can use the following code:

SECTION ACCESS;

LOAD

ACCESS,

NTNAME,

FIELD2REDUCE,

FROM SectionAccess.qvd (qvd);

SECTION APPLICATION;

Re: Section access with ntname

marcus_sommer — Sun, 21 Feb 2016 06:00:23 GMT

PASSWORD belonged to USERID and not to NTNAME (which didn't need a password then the authentication is in this case NTNAME). Have also a look here: Section Access.

- Marcus

Re: Section access with ntname

dbonilla — Tue, 23 Feb 2016 14:08:28 GMT

Thank you all,

I did just as you recommended, I left out password in section access and it works perfectly on the server.

Re: Section access with ntname

dbonilla — Tue, 23 Feb 2016 14:10:54 GMT

Now look like this

SECTION Access;

LOAD ACCESS,
NTNAME,
EJECUTIVO
FROM tbl.xls