My sql server database is set up to allow managed identity authentication only, no sql authentication is permitted (even for the admin), how/where do I copy the connection string from in that case? Goal is to save the sql connection as kv secret and use it to connect from ADF.thx
Yes, it's possible if you have "Azure role-based access control (recommended)" configured in "Access configuration". If you want to grant access to your ADF, you just need to add your ADF in IAM with the appropriate Role assignment. I chose the "Key Vault Secrets User" role for my ADF, and after that, the connection check passed.
Hi While creating linked service for SQL database using key vault getting an error that invalid database connection string provided ( The length of argument 'password' exceeds its limit of '128') Please help me with the issue
I created Azure Key Vault and secret as Access Key value of storage account. It is successful in creating linked service of storage account with KV. When I tried to connect the same with secret as connection string of storage account, It is getting failed in connecting through linked service. Error is "The specified account key is invalid. Check your ADF configuration. The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters."
Great video on the use of keyvault
Great work. Thanks !!!!!!!
Neat explanation, I know it would take time for me to do all these steps. Thanks
Thank you so much 😀
Thank you very much, good job.
superb..........
My sql server database is set up to allow managed identity authentication only, no sql authentication is permitted (even for the admin), how/where do I copy the connection string from in that case? Goal is to save the sql connection as kv secret and use it to connect from ADF.thx
Is it possible to do it via IAM instead of Policies?
Yes, it's possible if you have "Azure role-based access control (recommended)" configured in "Access configuration". If you want to grant access to your ADF, you just need to add your ADF in IAM with the appropriate Role assignment. I chose the "Key Vault Secrets User" role for my ADF, and after that, the connection check passed.
Why is video is getting blurred occasionally
Hi
While creating linked service for SQL database using key vault getting an error that invalid database connection string provided ( The length of argument 'password' exceeds its limit of '128')
Please help me with the issue
Got the same issue. Did you get any resolution?
Brilliant
I created Azure Key Vault and secret as Access Key value of storage account. It is successful in creating linked service of storage account with KV. When I tried to connect the same with secret as connection string of storage account, It is getting failed in connecting through linked service. Error is "The specified account key is invalid. Check your ADF configuration.
The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters."