DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then

[emveha]

hi all,

since this morning i suddenly have this message "DataSource.Error: 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.)". Am using a SQL db connection and use a Microsoft account to logon. Unfortunately, the connection refuses to work ( Message=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.)
Number=-2146893019
Class=20)

Hope you can help me out

thanks

M

[tamsan]

hello There, 

I have the same error message- I retrieve data into Power BI desktop from a query in Excel, but when refreshing the data in Power BI i get the error

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 solve?

thank you so much in advance

tamsan

[emveha · Accepted solution]

hi Qiuyun,

i do not think it was related to the connection, this morning i changed from organisational account to windows account and the issue was solved.... So, thank you very much for your support, the issue is been solved.

M

[v-qiuyu-msft]

Hi @emveha, 

Does the issue happen in Power BI desktop or service? It looks like you are using the encrypted connection to connect to SQL database then causes the error. 

Please refer to this similar thread to troubleshoot the issue: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-i...

Best Regards,
Qiuyun Yu