Share via

Unable to connect to Azure SQL or on-premises adventureworks database

Rambabu 231 Reputation points
2021-01-26T01:05:01.19+00:00

Hi - After i register Azure SQL in Purview and select 'New Scan' , I am getting below error
Error: (3860) Failed to access the Azure SQL database. Inner Code:20500

Below error for on-premises
Error: (20500) Failed to get the secret from key vault, secretName: , secretVersion: , vaultBaseUrl: https://<>keyvault1.vault.azure.net/. The error message is: The request URI contains an invalid name
60368-purviewonpremsqldb-scanerror.png

Thanks

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,018 questions
0 comments
Accepted answer
  1. Rambabu 231 Reputation points
    2021-01-26T02:27:57.077+00:00

    @Saurabh Sharma - Thanks for your detailed reply. we are doing PoC for our client with the help of MS team. I will reach out to you for further help.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rambabu 231 Reputation points
    2021-01-26T23:30:01.457+00:00

    Hi @Saurabh Sharma - Thanks for your help. It's working now. Restarted server after setting the On-Premises Server Security to mixed mode authentication.

    1 person found this answer helpful.
    0 comments
  2. Saurabh Sharma 23,776 Reputation points Microsoft Employee
    2021-01-26T01:52:12.393+00:00

    @Rambabu Thanks for using Microsoft Q&A !!

    I am able to reproduce your issue and I believe you are passing blank as a secret name in your credential.
    60404-image.png
    60446-image.png

    You need set up a secret in your azure key vault and pass the secretname to the credential, so, for example if you have created a secret with name "purview-user-secret" like below in Azure Key Vault then you need to use this name
    60387-image.png
    60445-image.png

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    0 comments