Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
USE [SSISDB];
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = N'[old_password]'; -- Specify old SSISDB catalog password
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = N'[newpassword]';
GO
Comments