Below are the steps to follow the movement of SSISDB from one environment to another:
-- opening the existing Database master key in SSIDB using password(We got this password from the I drive in production)
OPEN master KEY decryption BY password = 'SSISCatalogDBPassword'
go
-- Removing the additional encryption by service master key of backup instance SSISDB
ALTER master KEY DROP encryption BY service master KEY
go
-- Regenerate the service master forcefully in the restored instance SSISDB. We need to force it to work.
ALTER service master KEY force regenerate;
go
-- Add encryption by the newly regenerated master key of previous step
ALTER master KEY ADD encryption BY service master KEY
go
Subscribe to:
Post Comments (Atom)
How to Handle SSIS Database movement from one environment to another
Below are the steps to follow the movement of SSISDB from one environment to another: -- opening the existing Database master key in S...
-
We can execute SSIS packages deployed in SSIS Catalog using stored procedure based approach as given below: DECLARE @execution_id I...
-
When we want to see how many files are using a specific keyword, we can use below powershell script to do this. This will be helpful if we w...
-
Below are the steps to follow the movement of SSISDB from one environment to another: -- opening the existing Database master key in S...
No comments:
Post a Comment