试图创建SSIS目录当“期间服务主密钥解密出错”(“An error occurred during

我想跟着导游，以创建SSIS目录上的SQL 2012年我的开发实例，我收到了如下错误：

===================================

An error occurred during Service Master Key decryption
Changed database context to 'SSISDB'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.5058&EvtSrc=MSSQLServer&EvtID=33094&LinkId=20476

------------------------------
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)

我已经无法通过搜索或任何指导，以解决它，我怎么可能会解决它。

Answer 1:

当我检查注册表，因为这建议后 ，我发现我根本没有在任何值， Security密钥：

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

当我检查一台机器在SSIS目录的创建成功得手，它有一个条目Entropy 。

所以我跑以下命令每SSMS中的邮政通知：

ALTER SERVICE MASTER KEY FORCE REGENERATE;

当我刷新，我现在有一个Entropy项和SSIS目录的创建成功。

文章来源: “An error occurred during Service Master Key decryption” when trying to create SSIS catalog