• if your database has already been restored you should be able
    OPEN MASTER KEY DECRYPTION BY PASSWORD = 'MyStrongPassword';
    ALTER MASTER KEY
        ADD ENCRYPTION BY SERVICE MASTER KEY;
    CLOSE MASTER KEY;

    where "MyStrongPassword" is the pw from the source database