T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password

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

26 views0 comments