September 30, 2019 at 1:25 pm
Good morning all,
We have implemented the following architecture:
Server A: SQL 2014 Entreprise + Integration Services
Server B: SQL 2014 Entreprise+ Integration Services
We created an AlwaysOn availability group (Basics) using both servers as replicas, and protecting the SSISDB database.
The problem we are having is that during a flip-flop, we have to reopen the master key so that the SSIS packages can run.
OPEN master Key decryption by password = 'XXXXX' - Password used when creating SSISDB
Is there not a way to not have to reopen the master key to each rocker?
thank you in advance.
September 30, 2019 at 3:02 pm
This link may help
https://marcosfreccia.com/2017/04/28/adding-ssisdb-to-ag-for-sql-server-2016/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 30, 2019 at 3:36 pm
but this is from sql server 2016
I am with sql server 2014
September 30, 2019 at 3:43 pm
The same thing applies.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply