October 21, 2024 at 12:10 pm
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.
October 22, 2024 at 4:50 am
hello ,
You should click on the 'refresh' button after entering the master key password.
October 22, 2024 at 6:53 am
Thank you Kind sir. I was able to add it to the AG. Much Appreciated.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy