Saturday, 15 August 2015

sql server 2012 - "An error occurred during Service Master Key decryption" when trying to create SSIS catalog -



sql server 2012 - "An error occurred during Service Master Key decryption" when trying to create SSIS catalog -

i'm trying follow guide create ssis catalog on developer instance of sql 2012 , i'm receiving follow error:

=================================== error occurred during service master key decryption changed database context 'ssisdb'. (.net sqlclient info provider) ------------------------------ 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 ------------------------------ programme location: @ microsoft.sqlserver.management.integrationservices.catalog.createmasterkey(integrationservices store) @ microsoft.sqlserver.management.integrationservices.catalog.create(boolean execssisstartup) @ microsoft.sqlserver.integrationservices.uitasks.createobjectcontroller.createobject() @ microsoft.sqlserver.integrationservices.uitasks.createobjectcontroller.perform(itaskexecutioncontext taskexecutioncontext) @ microsoft.sqlserver.management.taskforms.taskexecutionmanager.executetasksequence(isfcscriptcollector collector)

i've not been able resolve through searching or guidance on how might resolve it.

when checked registry as post advised, found did not have values under security key:

hkey_local_machine\software\microsoft\microsoft sql server\<instance name>\security

when checked machine creation of ssis catalog succeeded successfully, had entry entropy.

so ran next command advised per post in ssms:

alter service master key forcefulness regenerate;

when refreshed, had entropy entry , creation of ssis catalog succeeded.

ssis sql-server-2012

No comments:

Post a Comment