CODEWITHSUNDEEP
ssissql-server-2012
Rick Glos
Rick Glos

Reputation: 2552

"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: 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.

Upvotes: 3

Views: 26143

Answers (1)

Rick Glos
Rick Glos

Reputation: 2552

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.

Upvotes: 11

Related Questions