Column Encryption Setting=enabled not working in Linked Service (Azure Data Factory)

Asked Jul 26 '17 at 17:46

Active Sep 14 '21 at 16:12

Viewed 1,367 times

I'm trying to implement a Custom Dot Net Activity which performs a stored procedure activity.

I've known that ADF already having a build in StoredProcActivity. But I want to insert into a table which has been already encrypted (using Always Encryption provider as the Azure Key Vault)

To workaround with always, Encryption using Azure Key vault requires the connection string to be like here

The thing I struct is the simple one While creating a AzureSqlLinkedService. I've added to my connection string with the Column Encryption Setting=enabled aalue. Actually, my connection string would be like:

Data Source=tcp:<ServerNAme>.database.windows.net,1433;Initial Catalog=<DBName>;User ID=<UserName>@<ServerNAme>;Password=<Password>;Integrated Security=False;Encrypt=True;Connect Timeout=30;Column Encryption Setting=enabled;

But, I got an error

Entity provisioning failed: Failed to connect to Linked service. Specified connection string is not valid.

edited Jun 17 '18 at 22:16

Daniel Mann

57,011
13
100
120

asked Jul 26 '17 at 17:46

Jayendran

9,638
8
60
103

So the question here, does ADF support the use of encrypted linked service? – Paul Andrew Aug 01 '17 at 12:35
Indirect yes .. no msdn sites told that adf doesn't support encrypted linked service – Jayendran Aug 01 '17 at 12:37
Good question. I'd be keen to know the answer. – Paul Andrew Aug 01 '17 at 12:37

Column Encryption Setting=enabled not working in Linked Service (Azure Data Factory)

0 Answers0