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