“服务主密钥解密期间发生错误"尝试创建 SSIS 目录时 [英] "An error occurred during Service Master Key decryption" when trying to create SSIS catalog

问题描述

我正在尝试按照指南在我的 SQL 2012 开发人员实例上创建 SSIS 目录，我收到以下错误:

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

我无法通过搜索或任何有关如何解决它的指导来解决它.

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

推荐答案

当我检查注册表时 正如这篇文章所建议的，我发现我在 下没有任何值安全键:

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

当我检查一台成功创建 SSIS 目录的机器时，它有一个 Entropy 条目.

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

因此，我按照 SSMS 中的帖子的建议运行了以下命令:

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

ALTER SERVICE MASTER KEY FORCE REGENERATE;

当我刷新时，我现在有一个 Entropy 条目并且 SSIS 目录的创建成功.

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

这篇关于“服务主密钥解密期间发生错误"尝试创建 SSIS 目录时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！