Unable to Connect due to Untrusted Certificate

[frodgers]

Error Received when trying to connect to on-prem SQL SERVER 2016 DB.

Unable to Connect

We encountered an error while trying to connect 

"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.)"

How can I resolve this>

[v-yuta-msft]

@frodgers ,

Are you login using the same server where SQL Server has been installed or other server? If the same, please check if the credentials are valid. In addtion, if you connect to SQL Server with remote connection, please check if the firewall policy allow the connection on both SQL Server side and your own server side.

Regards,

Jimmy Tao

[frodgers]

Hi Jimmy,

We resolved the installation issues by disconnecting our machine from the business network.  When we installed, it received no errors.  This goes for all Microsoft data-centric products (i.e. SSMS, data tools etc.).