Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: password encryption

    I have an Access .adp application and I need to store the passwords encrypted. I see that there are unsupported functions pwdencrypt() and pwdcompare() in SQL server 2K.

    Are there any other functions or methods in SQL Server 2000 that could be called that would provide this capability?
    Thanks,
    Bill

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by beeyule
    Are there any other functions or methods in SQL Server 2000 that could be called that would provide this capability?
    SQL Server 2000 encryption is pretty weak. 2005 is supposed to address this. In the meantime, you might consider this link:

    http://www.sqlservercentral.com/colu...encryption.asp

    (you may have to register, but registration is free).

    Alternatively, you could use the Micrsoft Crypto API (capicom.dll) or the .Net Encryption utilities (don't have more specific references on these).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •