SSISDB Encruption key Reset

• DBA

  Old Hand

  Points: 371

  More actions

  June 9, 2022 at 8:07 pm

  #4047138

  Hi,

  I do not have SSISDB encryption key so while migrating this SSISDB, when I try to reset the key it throws the error. Please let me know if there is any workaround.

  alter master key

  add encryption by password = 'Somepasswordhere'

  Msg 15151, Level 16, State 1, Line 1

  Cannot find the symmetric key 'master key', because it does not exist or you do not have permission.

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 10, 2022 at 8:10 pm

  #4047739

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.