Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSISDB in Cluster Setup Issue - Master Key

Author  Topic 

Analyzer
Posting Yak Master

115 Posts

Posted - 2014-11-20 : 10:35:36
Hi,

Our Clustered setup which host a SSISDB encounters an issue when we failover to Node B. Due to the master key issue we get the below error message

Please create a master key in the database or open the master key in the session before performing this operation.

Any ideas how to mitigate this. Does it require a custom as seen in this article for AlwaysOn. http://blogs.msdn.com/b/mattm/archive/2012/09/19/ssis-with-alwayson.aspx

Thanks in advance

   

- Advertisement -