Post reply

AES Encryption in 2008R2

  • December 30, 2011 at 2:51 am

    #248286

    can we decrypt data using PHP "mcrypt_decrypt - MCRYPT_RIJNDAEL_128 " from data encrypted by MSSQL 2008R2.

  • December 30, 2011 at 3:33 am

    #1426833

    The typical encryption / decryption application follows either of two scenarios.

    •Front End sends raw data & database server encrypts few fields based on requirements. In data retrieval, decryption happens at database server & Front End display same data.

    •Front End encrypts / decrypts data & database server store it as is.

    Why do you want to decrypt data on application side that is encrypted at database server?

  • December 30, 2011 at 4:19 am

    #1426856

    encrypted by MSSQL 2008R2.

    You mean TDE? No way. SQL Server handles that for you.

    Any other kind of encryption is managed by the applications. Find the app that encryped the data and decrypt it with that app.

    -- Gianluca Sartori

  • December 30, 2011 at 4:57 am

    #1426882

    Thanks for clarification.

    The data encrypted by both should be the same right?. for cross verification I am testing for that.

    Actually my application requires PHP decryption in some places. So I need confirm this.

  • December 30, 2011 at 5:01 am

    #1426885

    rmogeraya (12/30/2011)

    Thanks for clarification.

    The data encrypted by both should be the same right?. for cross verification I am testing for that.

    Actually my application requires PHP decryption in some places. So I need confirm this.

    If you have proper keys / certificates then Yes, it’s the same.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply