question

Inka-4073 avatar image
0 Votes"
Inka-4073 asked CarrinWu-MSFT edited

Always On Availability and Encrypted Database

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?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

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.
104485-1.png
104463-2.png


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.




1.png (102.9 KiB)
2.png (50.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Inka-4073 avatar image
0 Votes"
Inka-4073 answered

I was trying to use a wizard. I've read that SQL Server 2016 has this option.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

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

104077-1.png


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.



1.png (49.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Inka-4073 avatar image
0 Votes"
Inka-4073 answered

I found an article from Microsoft stating that starting with SQ Server 2016 this is an option. Below is the link

https://techcommunity.microsoft.com/t5/sql-server-support/sql-server-2016-alwayson-availability-group-enhancements-support/ba-p/318809

However, that doesn't seem to work for me. I was wondering if it worked for anybody

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.