Service Master Key issue on AG
Posted by Simon Cho on 09/22/2016
https://blogs.msdn.microsoft.com/mattm/2012/09/19/ssis-with-alwayson/
https://technet.microsoft.com/en-us/library/ms182754%28v=sql.110%29.aspx
Temporary solution : Alter master key again with service master key
OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘x’ — Should be encrypted! See below
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
Here is SQL server 2016 AG setting.
It seems like working with SQL 2014 as well.
Service Broker may not work after Failover in AG. « Simon's SQL said
[…] Service Master Key issue on AG […]