Open master key decryption by password = –‘Password used when creating SSISDB’Īlter Master Key Add encryption by Service Master Key Workaround: To do this, you should know the original passsword for the master key of the database. To address this specific error, you’ll need to open the master key. This usually happens when you restored SSISDB and did not open the master key afterwards. You receive the error because the master key on the SSISDB database is not open or does not exists. The error is succinct and direct to the point – Pleae create a master key in the database or open the master key in the session before performing this oepration. Your are deploying a SQL Server Integration Services Package to the SSIS Catalog and keeps on failing with the following error:

Let me know if you have any questions in the comments, and don’t forget to sign up for the next post.

I also don’t recommend skipping rules unless you understand what the rule is for, what you’re doing, and whether it’s safe to bypass or not. But as I mentioned, it doesn’t really matter since SSIS is a shared feature anyway. This will allow you to add the feature on the existing instance.

WorkaroundĪs with any rules for the setup, you can bypass the cluster rule by launching the setup from the command prompt with the command below. This will allow you to install the SSIS without any issues. On the feature selection, simply only check SQL Server Integration Services under the shared feature and don’t check the database engine. You can simply install it by choosing Add New Instance/Installation of SQL Server instead of choosing to Add Feature to an Existing Instance.

Note that SSIS is not a cluster-aware service and doesn’t really fall under the instance. By default, the cluster check will be part of the rules run during pre-checks for the installation. You are receiving this error because you chose to add the feature on the existing clustered instance. You chose to add the shared feature to the existing instance and received the error below and couldn’t proceed: Cause You’re trying to install SQL Server Integration Services to an existing SQL Server failover cluster.

Sql server backup service master key