I can connect to my SQL development server locally and via SMSS however whenever I try to connect via my mobile client I get this SQL error:
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.)
It also only sometimes throws this error and occasionally will return what I ask it for. I have also read other posts outlining a similar issue however, adding different combinations of trust and encryption settings to the connection string has no effect.
I read that somebody could only solve this issue by completely rebuilding their entire database. I don't want to do that so I wonder if anybody has any other insight?
For context my server is a ASP.NET Core Web API and I have done a lot of scaffolding with entity framework.
