Post reply

Password encryption in sql server

  • May 23, 2017 at 4:48 am

    #323717

    Password encryption in sql server 
    Currently I am using encryptionpassbyphrase. But it does not work on different servers and decryption fails.
    Please suggest me if any alternate solution for this

  • May 23, 2017 at 5:14 am

    #1943737

    Are you asking about encrypting data and using a password to decrypt it, or about encrypting passwords?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 23, 2017 at 7:43 am

    #1943779

    ENCRYPTBYPASSPHRASE / DECRYPTBYPASSPHRASE should work if you supply the same exact passphrase parameter, even across different versions of SQL Server, since that phrase is what's used to generate the symmetric key.  What error or symptom were you encountering?

    If you want to encrypt/decrypt the same data on different servers by key instead of passphrase, you can do that by ensuring they have the same symmetric key:
    https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/create-identical-symmetric-keys-on-two-servers

Viewing 3 posts - 1 through 2 (of 2 total)

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