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

• Waseem_Zakir

  SSC Enthusiast

  Points: 116

  More actions

  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.

• abdalah.mehdoini

  Ten Centuries

  Points: 1023

  More actions

  October 22, 2024 at 4:50 am

  #4471413

  hello ,

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

  

• Waseem_Zakir

  SSC Enthusiast

  Points: 116

  More actions

  October 22, 2024 at 6:53 am

  #4471457

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