-AlwaysEncrypted not supported "Keyword not supported: 'column encryption setting'."

[ericfran]

Hi,
we try to connect to a Azure SQL
$server = Connect-DbaInstance -SqlInstance $DatabaseServer -Database $Database -SqlCredential $cred -AlwaysEncrypted

and receive the following message:
New-Object: C:\Users\xxxx\OneDrive\PowerShell\Modules\dbatools\1.1.89\allcommands.ps1:5099:41
Line |
5099 | … onnection = New-Object -TypeName Microsoft.SqlServer.Management.Commo …
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Exception calling ".ctor" with "1" argument(s): "Keyword not supported: 'column encryption setting'."

What is the issue ? How to resolve it ?

Regards,

[ericfran]

when I try to use:
Invoke-DbaQuery -SqlInstance $conn -Query "exec sp_set_session_context 'GlobalCustomerCode', 'ALC'; select top(1) * from Associate;"

I receive the following message :
WARNING: [17:16:56][Invoke-DbaQuery] [sql-alg-q-weu-hrxcalc-01.database.windows.net] Failed during execution | Failed to decrypt a column encryption key. Invalid key store provider name: 'AZURE_KEY_VAULT'. A key store provider name must denote either a system key store provider or a registered custom key store provider. Valid system key store provider names are: 'MSSQL_CERTIFICATE_STORE', 'MSSQL_CNG_STORE', 'MSSQL_CSP_PROVIDER'. Valid (currently registered) custom key store provider names are: . Please verify key store provider information in column master key definitions in the database, and verify all custom key store providers used in your application are registered properly.

What need to be done ?

thanks
Regards,