title: SSIS and Availability group
body: <p>I wonder if someone could help me with a small problem…I’m setting up my server with alwaysOn and I’ve added the SSIS catalog in the availability group. When I failover, it works but I need to run a command to re-encrypt the Master Key on the failover node:</p>
  
  <p>Alter Master Key Add encryption by Service Master Key</p>
  
  <p>I’d like to know is there’s a way to run a command when the secondary node comes online to automate this process…</p>