Azure-docs: Service Account- Self Hosted IR - Unable to find the keypath

[ask-imran]

I am using a service account, I have my self hosted IR configured. I have the .p12 key path on the IR machine. when I reference the path on the linked services and try to connect it throws an error as "Failed to connect to the database. Error message: ERROR [HY000] [Microsoft][DriverSupport] (1140) Unable to load CA certificates from certs file location. Please ensure the file exists, has read permission, and has the correct PEM format."

---

Document details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: f9172af5-4e2f-0026-9052-9197e01d1f54
• Version Independent ID: eb1e1f01-6e5c-5add-58ce-d034f4f0d9f2
• Content: Copy data from Google BigQuery by using Azure Data Factory
• Content Source: articles/data-factory/connector-google-bigquery.md
• Service: data-factory
• GitHub Login: @linda33wj
• Microsoft Alias: jingwang

[KranthiPakala-MSFT]

@ask-imran Thank you for reaching out and bringing this to our notice. At this time we are reviewing the ask and will provide an update as appropriate

[KranthiPakala-MSFT]

Hi @ask-imran, Could you please double check the below settings in your linked service.

Are you using the system trust store or a specified .pem file?

By looking at the error message it says that the CA certificates are unable to load due to any of the below two reasons

1. Either .pem file does not exist in the specified path.
2. .pem file specified is not accessible.

Could you please check these two things.

[KranthiPakala-MSFT]

We will now proceed to close this thread as we have not heard back from you. If there are further questions regarding this matter, please tag me in your reply and reopen the issue. We will gladly continue the discussion.

[ask-imran]

@KranthiPakala-MSFT Thanks for the response, Yes it was due to the .pem file.

[KranthiPakala-MSFT]

@ask-imran Are you still experiencing the issue?

[ask-imran]

@KranthiPakala-MSFT No, I am able to proceed without any issues.

@ask-imran Are you still experiencing the issue?

No, I am all good. Thanks

[KranthiPakala-MSFT]

@ask-imran Glad to know that your issue was resolved. Thanks for confirming. :)