Post reply

Adding Database to AG After Adding A New Master Key To Database

  • October 21, 2024 at 12:10 pm

    #4471130

    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.

  • October 22, 2024 at 4:50 am

    #4471413

    hello ,

    You should click on the 'refresh' button after entering the master key password.

    Sans titre

  • October 22, 2024 at 6:53 am

    #4471457

    Thank you Kind sir. I was able to add it to the AG. Much Appreciated.

  • October 25, 2024 at 5:38 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply