Onprem SQL Server password saved to KeyVault doesn't work on LinkedService

Question

Failed to get the secret from key vault, secretName: XYZ, secretVersion: 123, vaultBaseUrl: https://abc.vault.azure.net/. The error message is: An error occurred while sending the request.
Unable to connect to the remote server
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 20.62.134.229:443.

I created secret on the Keyvault for the onprem SQL server. For some reason the connection is not able to read it from the keyvault.

Answer 1

Hi Venkat Bommavaram,

Based on the error provided, it seems more like your application does not have network line of sight to the keyvault resource. To verify you can try Telnet to keyvault hostname abc.vault.azure.net at port 443 from your application/host.