<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to use asp (encrypted) password from database for user logon in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143460#M22698</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The encrypted password is probably never being decrypted. What the user enters as their password is encrypted and compared to the stored value.&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;But this is achievable in QV Server using a custom Directory Services Connector.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 06 May 2009 23:48:54 GMT</pubDate>
    <dc:creator />
    <dc:date>2009-05-06T23:48:54Z</dc:date>
    <item>
      <title>How to use asp (encrypted) password from database for user logon</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143459#M22697</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hello!&lt;/P&gt;&lt;P&gt;I want to use existing username &amp;amp; password information stored in a SQL database by an ASPnet application.&lt;BR /&gt;I can read all the user data into a table (from aspnet_users and aspnet_Membership)&lt;/P&gt;&lt;P&gt;But the password field is stored in encrypted format inside the database -for obvious security reasons.&lt;BR /&gt;The other ASP application is able to accept a username/password for login and somehow works out if the user can login.&lt;/P&gt;&lt;P&gt;That 'somehow' function is what i would like to access, or replicate in my qvw script.&lt;BR /&gt;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)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any thoughts / suggestions would be much appreciated.&lt;BR /&gt;Peter.&lt;/P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 06 May 2009 22:26:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143459#M22697</guid>
      <dc:creator>peter_turner</dc:creator>
      <dc:date>2009-05-06T22:26:30Z</dc:date>
    </item>
    <item>
      <title>How to use asp (encrypted) password from database for user logon</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143460#M22698</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The encrypted password is probably never being decrypted. What the user enters as their password is encrypted and compared to the stored value.&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;But this is achievable in QV Server using a custom Directory Services Connector.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 06 May 2009 23:48:54 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143460#M22698</guid>
      <dc:creator />
      <dc:date>2009-05-06T23:48:54Z</dc:date>
    </item>
    <item>
      <title>How to use asp (encrypted) password from database for user logon</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143461#M22699</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Jay,&lt;/P&gt;&lt;P&gt;Following up from your post, do you have any information you could send me?&lt;BR /&gt;If it is possible to use the existing asp stored password, then that would make a much cleaner solution for me.&lt;/P&gt;&lt;P&gt;Thanks,&lt;BR /&gt;Peter.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 30 Jun 2009 01:27:45 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143461#M22699</guid>
      <dc:creator>peter_turner</dc:creator>
      <dc:date>2009-06-30T01:27:45Z</dc:date>
    </item>
    <item>
      <title>How to use asp (encrypted) password from database for user logon</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143462#M22700</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Peter, any resolution to your issue? I have a similar scenario and would be interested in finding out what you did to accomplish your goal. Thanks.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 17 May 2011 20:14:19 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-use-asp-encrypted-password-from-database-for-user-logon/m-p/143462#M22700</guid>
      <dc:creator>sjoelsona8</dc:creator>
      <dc:date>2011-05-17T20:14:19Z</dc:date>
    </item>
  </channel>
</rss>

