Good morning,
I am using SQL Server 2016 Enterprise Edition. I was trying to add an encrypted database to the availability group. When I entered the password the option to check the check box was still grayed out. Any ideas?
Good morning,
I am using SQL Server 2016 Enterprise Edition. I was trying to add an encrypted database to the availability group. When I entered the password the option to check the check box was still grayed out. Any ideas?
Hi @Inka-4073,
I read your reference which you provide. The reference said that create a new always on group and add an encrypted database into the new always on group. Not add an encrypted database into an always on group which already has been created before. 

Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I was trying to use a wizard. I've read that SQL Server 2016 has this option.
Hi @Inka-4073,
Welcome to Microsoft Q&A!
If a database is encrypted or even contains a Database Encryption Key (DEK), you cannot use the New Availability Group Wizard or Add Database to Availability Group Wizard to add the database to an availability group. Please refer to Add an encrypted database to an Always On availability group to get more information.
In addition, you could use T-SQL to do it, please refer to How to add a TDE encrypted database to an Availability Group

Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I found an article from Microsoft stating that starting with SQ Server 2016 this is an option. Below is the link
However, that doesn't seem to work for me. I was wondering if it worked for anybody
14 people are following this question.