topic Section Access without promting for username and password(Single singn on) in QlikView

Section Access without promting for username and password(Single singn on)

Fri, 05 Aug 2011 09:25:02 GMT

Hi,

We have enabled section Access in the QVW file and it is working fine. Also we have integrated AD Authentication in the Qlikview server. As of now it is working in this way

1.Access point will prompt for user name and password. End user will provide the credentials and once it is authenticated he will have access to QVW file for which he has the access.

2. User tries to open the QVW file (section access enabled). it will prompt for user name and password.Once it is provided it will reduce the data accordingly.

We want this to change in to the following way

1. User will provide the user credentials in the Access point and once it is authenticated the user credentials will be stored in Accesspoint page.

2. User tries to open the QVW file(Section Access enabled). And it should not prompt for username and password. Automatically the user credentails what has been provided to login to the Accesspoint has to be passed to section Access.

Any one done the same. Please suggest. And we need it for both IE and Ajax.

Section Access without promting for username and password(Single singn on)

kaushiknsolanki — Fri, 05 Aug 2011 09:30:18 GMT

Hi,

I dont know much about it, but in section access you can try NTNAME and NTDOMAINID.

Hope this can solve the issue.

Regards,

Kaushik Solanki

Section Access without promting for username and password(Single singn on)

SunilChauhan — Fri, 05 Aug 2011 09:32:27 GMT

Try ussing this

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTNAME

ADMIN, ADMIN, welcome, *

      USER, *, *, Domain\Username1
      USER, *, *, Domain\Username1
       USER, *, *, Domain\Username2
       ..
       ..
       ..

];

Section Application;

it will promt login for users wwho are unauthenticated

Section Access without promting for username and password(Single singn on)

Miguel_Angel_Baeyens — Fri, 05 Aug 2011 09:42:55 GMT

Hi there,

Internet Explorer and Plugin may provide the complete solution if you set them up properly. But step by step, this is what I would do:

Create and test the section access using NTNAME field instead of USERID and PASSWORD pair.
Configure the IE so the credentials with the user logs on are passed automatically on to the webpage without being prompted (as detailed here)
Set up the QlikView Server so the user always requires authentication and this authentication is provided using NTLM (In the QEMC, System, Setup, QlikView Servers and QlikView WebServer)

Once you have done this successfully, the user will never be prompted: the Server will use the logon credentials to grant or deny access to the server and the Section Access will use the same logon credentials to reduce data (if applicable) to show the corresponding records.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica