In SSIS 2012, after a catalog is created, there are only few properties which can be modified from the GUI as shown below.
Some properties are greyed out.
Please note that Encryption algorithm name is greyed out.
Here are the steps to be followed to modify the property:
-
Make the SSISDB to be in single user mode
-
Then change the encryption type using TSQL command (using GUI wouldnt work as the database in single user mode and get this message)
-
Make the SSISDB to be in multi user mode
[cc lang=”sql”]
— single user
ALTER DATABASE SSISDB set single_user with rollback immediate
— change the property
USE SSISDB
EXEC catalog.configure_catalog @property_name=’Encryption_Algorithm’, @property_value=’TRIPLE_DES_3KEY’;
— multi user
ALTER DATABASE SSISDB SET MULTI_USER
[/cc]
Then verify that the catalog properties got modified for the SSISDB catalog as shown:
0 Comments.