jason walton

My feedback

  1. 30 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  12 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    jason walton commented  · 

    The security algorithm used to encrypt passphrases in SQL Server 2016 (or below) is SHA1, in SQL Server 2017 this has been updated to use SHA2.

    You can work-around this issue by enabling trace-flag 4631.

    But, the ultimate fix is going to be a total decryption > migration > re-encryption using a new certificate that is based on the newer algorithm

    jason walton supported this idea  · 

Feedback and Knowledge Base