How to open a Qvw file having section access by taking login details from access point

[kkkumar82]

Hi every body,

Problem statement:

I have a requirement regarding a qvw file(having section access) to be opened by taking username and password from access point.

In detail:

1. All of us know that when we open access point it asks for usrname and password.

2. and if a qvw file is there with section access , again we have to provide a usrname and password too.

My requirement:

Can we get the usrname and password of access point into the qvw  by which when we want to open qvw(which is having section access) it should not ask again the password.

Are there any functions in qlikview or scripting by which we can do this.

Thank you.

[Bill_Britt]

I would try putting the AccessPoint URL in trusted sites. That should pass the user/password when you login also.

Bill

[Peter_Cammaert]

And just in case it applies, change your USERID/PASSWORD-type Section Access into an NTNAME-type Section Access.

[jpapador]

What kind of directory are you storing your QV users in?  (local directory on server, custom user directory in QVS, etc)?

[kkkumar82]

Actually Iam new to QV server but any how I will go through the type of security we are using.

Thank you all for sparing time.

Does single sign on(SSO) help me  in this regard, if not , what is the difference between my issue and SSO.

[kkkumar82]

I came to know about the users, they are all windows users in the server(os) and all are having named cal, and using the admin user we have set properties to the qvw files who has to see which qvw and afer that we required section access for qvws because a qvw file can have access to n number of users .

coming to my requirements my users dont wont to have enter two times the user name and password once in

1.access point

2.section access

How to avoid authorization in section access?

is NTNAME the final solution, guide me in this regard.

[Peter_Cammaert]

Of course SA with NTNAME field is the solution, otherwise you won't have SSO (= Single-Sign-On meaning you'll enter your credentials only one time, and they'll be used from then on)

Just throw out USERID/¨PASSWORD in your section access and replace it with an NTNAME field containing DOMAINNAME\ACCOUNTNAME values for all users that should be granted access.

Best,

Peter

[Peter_Cammaert]

Oh and BTW, you can use both in the same SA table. With the added disadvantage that the document will always prompt for credentials if the Windows user isn't recognized as a valid document user (unknown NTNAME value)

Still, the best thing you can do is throw out USERID/PASSWORD entirely. Life will become much easier.

[kkkumar82]

Yeah I will sure try it but I have small doubt regarding domain name, the server os is windows server 2008 R2, do we have domain name concept in that ( I am not sure).

[Peter_Cammaert]

If your environment isn't making use of AD (Active Directory) then use the machine domain (usually the server name) instead. Or simply omit the DOMAINNAME\ part from the NTNAME values.

Peter