I’ve grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It’s a fairly human look at what’s involved in sailing on a Trident missile submarine…
To change the Integration Services Catalog (SSISDB) database Master Key encryption password, run the following Transact-SQL statement:
USE [SSISDB]; GO OPEN MASTER KEY DECRYPTION BY PASSWORD = N'[old_password]'; -- Password used when creating SSISDB ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = N'[new_password]'; GO
In the above Transact-SQL fragment, we first open the Integration Services Catalog (SSISDB) database Master Key with the existing password, and then regenerated it with a new one.