Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

unable to connect to the sql server

Hi All,

 

I am working on a BI file my coleague has worked on. While connecting to the sql server I am getting the below error. 

 

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.) Details: DataSourceKind=SQL DataSourcePath=kwthqdwh01;Vision_MC 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.) ErrorCode=-2146232060 Number=-2146893019 Class=20
 
I was able to open a new file and connect to the sql server database. but on this file it throws the above error.
 
data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Changeing them from organisation to windows authentication did the trick.