"An error occurred during Service Master Key decryption" when trying to create SSIS catalog

I'm trying to follow the guide to Create the SSIS Catalog on my Developer instance of SQL 2012 and I'm receiving the follow error:

=================================== An error occurred during Service Master Key decryption Changed database context to 'SSISDB'. (.Net SqlClient Data Provider) ------------------------------ For help, click: ------------------------------ Server Name: .\SQL2012 Error Number: 33094 Severity: 16 State: 1 Line Number: 1 ------------------------------ Program Location: at Microsoft.SqlServer.Management.IntegrationServices.Catalog.CreateMasterKey(IntegrationServices store) at Microsoft.SqlServer.Management.IntegrationServices.Catalog.Create(Boolean execSsisStartup) at Microsoft.SqlServer.IntegrationServices.UITasks.CreateObjectController.CreateObject() at Microsoft.SqlServer.IntegrationServices.UITasks.CreateObjectController.Perform(ITaskExecutionContext taskExecutionContext) at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector) 

I've not been able to resolve it through searching or any guidance on how I might resolve it.

1 Answer

When I checked the registry as this post advised, I found that I did not have any values under the Security key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance Name>\Security 

When I checked a machine where the creation of the SSIS catalog succeeded successfully, it had an entry for Entropy.

So I ran the following command as advised per the post in SSMS:

ALTER SERVICE MASTER KEY FORCE REGENERATE; 

When I refreshed, I now had an Entropy entry and the creation of the SSIS catalog succeeded.