Post reply

SQL 2012 - SSISDB Catalog Change Password

  • December 13, 2016 at 6:08 pm

    #332709

    Hi

    Can you please let me know how to change the encryption password after creating the SSISDB in SQL 2012/2014 Version? I know the initial password when creating the DB.

    Thanks

    Shuaib

  • May 1, 2017 at 1:09 pm

    #1940595

    ShuaibV - Tuesday, December 13, 2016 6:08 PM

    HiCan you please let me know how to change the encryption password after creating the SSISDB in SQL 2012/2014 Version? I know the initial password when creating the DB.ThanksShuaib

    Did you try this:
    (from: https://blogs.msdn.microsoft.com/mattm/2012/03/23/ssis-catalog-backup-and-restore/

     USE SSISDB
     BACKUP MASTER KEY TO FILE = 'c:\DMK\SSISDB\key'
     ENCRYPTION BY PASSWORD = 'SS1SC@talogMKBKUP'
    USE SSISDB
     RESTORE MASTER KEY FROM FILE = 'D:\MasterKeyBackup\SSIS-Server1234\key'
     DECRYPTION BY PASSWORD = 'SS1SC@talogMKBKUP'
     ENCRYPTION BY PASSWORD = 'NewC@talogPassw0rd'
     FORCE

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

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