I am encountering an error while attempting to connect to SQL Server Standard Edition through the on-premises data gateway. The issue seems to be related to the configuration or connection in Standard mode. I have provided the correct credentials, so the problem does not appear to be related to authentication.
Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details: Production Gateway: Microsoft SQL: 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.) Please have this information handy if you choose to create a support ticket.
Could you kindly assist in reviewing the setup or provide guidance on resolving this error?
2