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

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

514 views0 comments
bottom of page