Forum Discussion
On-Premises Data Gateway Error
yes, you will want to consider hard before disabling encryption. Better to update the certificate on the SQL server.
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.
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.