Unable to connect we encountered an error while trying to connect....

[Tanuja_PBI]

While trying to connect to SQL Server, i got this error message..please anyone can reply with proper solution..

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

[v-rzhou-msft · Accepted solution]

Hi @Tanuja_PBI 

What kind of credential did you choose to connect to SQL, windows,database or microsoft account?

1. Please check whether the account you use in yoru credential has access to SQL currently.

2. Please check Encrypt Connections in your Data Source Setting. If it is checked, uncheck it and try again.

File->Options and Settings -> Data Source Settings, choose your SQL Server data source and select Edit and uncheck "Encrypt Connections" option.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Tanuja_PBI]

wow! Thats great! it is working.....i did exactly what you mentioned in step-by-step..Thank you so much..

[amitchandak]

@Tanuja_PBI , refer these two

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-O...

https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-i...