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

541 views0 comments

Commentaires


bottom of page