question

BrokenAsFork-6659 avatar image
0 Votes"
BrokenAsFork-6659 asked Cathyji-msft edited

ExternalAccountsAsyKey is not supported in Microsoft Azure SQL Database v12

Hi,

I'm trying to deploy a SQL Server Database using SQL Package, but I'm getting the following error message.

The element ExternalAccountsAsyKey is not supported in Microsoft Azure SQL Database v12.

The same deployment was successful to two other Azure SQL Databases, but this one fails for some reason.

I have also tried deploying using:

 <ExcludeAsymmetricKeys>True</ExcludeAsymmetricKeys>
 <ExcludeSymmetricKeys>True</ExcludeSymmetricKeys>


azure-sql-database
· 2
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.

89212-image.png




Same in Management Studio....

Works on one database, not on another.

Any ideas why?

0 Votes 0 ·
image.png (117.4 KiB)

Hi @BrokenAsFork-6659, welcome to Microsoft Q&A forum.

It seems like a limitation. As per the article, "Additionally, it is worth emphasizing that because the symmetric key & asymmetric key objects cannot be exported, data encrypted or signed can be lost when copied to a different database using the Import/Export (I/E) functionality in SQL Database which is based on logical data movementusing bacpac files and the DACFx API"

We can drop these keys and after deployment we can again create them.

You mentioned that same deployment worked with other Azure SQL Database, could you please tell is there if these databases have similar configurations?


0 Votes 0 ·

0 Answers