Connectivity to sql server express 2008 R2

[rouillardda]

I am trying to connect to my sql server database that is linked to my web application (2008 R2).  Though I can access the database using SSMS (both on development and production machine). Evry time I use credentials in Power BI, I get this 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.)"

I have unchecked encryption.  I think I may not understand certificates and why I need to address this for Power BI?  Can anyone give me some advice on this.  

[Anonymous · Accepted solution]

HI @rouillardda,

It seems like a SSL security related issue, please take a look at following link if it suitable for your scenario:

SSL Security Error with Data Source

Regards,

Xiaoxin Sheng