Blog Post

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

Original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating