I’ve connected the database in Server Explorer, and I’ve scaffolded the entire database. My entire context is built, however when running the app and trying to pull information from one of the tables I am getting the trust certificate issue… I have referred to the post:
“The certificate chain was issued by an authority that is not trusted” when connecting DB in VM Role from Azure website_
However no luck. TrustServerCertificate=true, Trusted_Connection=true, Encrypt=False all don’t work and all results in this same 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.)”
How is it that server explorer can connect and I can actually execute queries through visual studio, but in application ef throw this error everytime