I have a database i need to add to AG. lets name it "TestDB", now TestDB already has a master key and i do not have the password for it, so i add a new database master key to it using the following query -
USE [TestDB];
ALTER MASTER KEY ADD ENCRYPTION BY PASSWORD = 'xxx';
GO
Then i run the wizard to add database to AG
At the window i am required to select the database i enter the password of the new Master Key.
After giving the password the check box to select the database remains greyed out. (Please refer attached image)
Can someone help me identify what the issue is.
Attachments:
You must be
logged in to view attached files.