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

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

Writer's picture: rajendra guptarajendra gupta
Jan 28, 20221 min read

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

624 views0 comments
bottom of page