How to use asp (encrypted) password from database for user logon
Hello!
I want to use existing username & password information stored in a SQL database by an ASPnet application. I can read all the user data into a table (from aspnet_users and aspnet_Membership)
But the password field is stored in encrypted format inside the database -for obvious security reasons. The other ASP application is able to accept a username/password for login and somehow works out if the user can login.
That 'somehow' function is what i would like to access, or replicate in my qvw script. It must be something todo with the Password and PasswordSalt fields in the aspnet_Membership table, but I don't know if this is even possible in QlikView. (also have no knowledge of asp)
Any thoughts / suggestions would be much appreciated. Peter.
The encrypted password is probably never being decrypted. What the user enters as their password is encrypted and compared to the stored value.
You won't be able to achieve this using a local QVW, because the section access has no support for performing operations on the entered password before comparing to the stored PASSWORD field values.
But this is achievable in QV Server using a custom Directory Services Connector.
Following up from your post, do you have any information you could send me? If it is possible to use the existing asp stored password, then that would make a much cleaner solution for me.
