Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Michael Coles SQL 2000 DBA Toolkit Part 1 RE: SQL 2000 DBA Toolkit Part 1

  • August 9, 2010 at 3:14 pm

    #1204425

    Mark Salvador (2/3/2010)

    I am also having the same problem. I used the web site to encrypt/decryt credit card details but when i checked it with other machine, for example in Query Analyzer, it shows NULL result.

    Is it possible to remove this "per local machine" and to make it accessible to everyone?

    Can I also request for the source code for AES algorithm? Desperately need solution on this.

    Thanks,

    Mark

    Hi Mark,

    The code uses the local machine encryption key to protect your data encryption keys. You can conceivably remove this limitation, but you'd have to modify the code yourself to do this. The source code (including the source for all algorithms used) is posted here: http://www.sqlservercentral.com/Forums/Topic199534-236-14.aspx

    Thanks

    Mike C