<div>
Is this as simple as just specifying a new password for the DMK? &nbsp;Obviously if nobody knows the old password we cannot remove it and it will remain active but can I just specify a new DMK this way?<br />
<br />
use &lt;database&gt;<br />
go<br />
alter master key <br />
add encryption by password = 'newpassword'<br />
go
</div>


Is this as simple as just specifying a new password for the DMK?  Obviously if nobody knows the old password we cannot remove it and it will remain active but can I just specify a new DMK this way?

use <database>
go
alter master key
add encryption by password = 'newpassword'
go

<div>
<div class="content wysiwyg-content">
Someone created an SSISDB database and catalog on one of our SQL 2012 servers. &nbsp;The master key was not documented during creation. &nbsp;What is the process to obtain this master key or reset it?<br />
<br />
<a href="https://arnosqlserver.files.wordpress.com/2014/06/061914_0941_settingupan2.png?w=960" rel="ugc">https://arnosqlserver.files.wordpress.com/2014/06/061914_0941_settingupan2.png?w=960</a>
</div>
</div>


Someone created an SSISDB database and catalog on one of our SQL 2012 servers.  The master key was not documented during creation.  What is the process to obtain this master key or reset it?

https://arnosqlserver.files.wordpress.com/2014/06/061914_0941_settingupan2.png?w=960

How to reset the SSISDB catalog master key if lost?  SQL 2012

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.