On-Premises Data Gateway Error

[VictorMed]

Hi All,

We encountered an issue with an on-premises data gateway connecting to a VM hosting an on-premises SQL Server.

For context, the solution has been running for almost 10 months without connectivity issues.

The first encountered error was:

We then fixed the issue by updating the data gateway agent to the latest version; the one used was from a year ago.

That fixed that issue, but then it brought a new one:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.),},],''Type=System.ComponentModel.Win32Exception,Message=The certificate chain was issued by an authority that is not trusted,Source=,'

We fixed the above by changing the connection to the SQL server to non-encrypted.

The question is, we never ticked the box of encrypted connexion. Is this a known case when updating the gateway? What could have caused the change?

Thanks,

Victor

[lbendlin · Accepted solution]

yes, you will want to consider hard before disabling encryption.  Better to update the certificate on the SQL server.

[v-pbandela-msft]

Hi @VictorMed,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @VictorMed,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @VictorMed,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-pbandela-msft · Accepted solution]

Hi @VictorMed,

Thank you for reaching out in Microsoft Community Forum.

Thank you @lbendlin  for the helpful response.

Please follow below steps to resolve the error;

1.Make sure the certificate is valid, not expired, and signed by a trusted certificate authority (CA).

2.Install any missing intermediate or root certificates on the gateway machine.

3.Make sure the gateway and SQL Server support SSL/TLS encryption, and the settings align.

4.Test the connection again with encryption enabled after fixing the certificate trust issues.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[lbendlin · Accepted solution]

yes, you will want to consider hard before disabling encryption.  Better to update the certificate on the SQL server.