I'm receiving error "SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process.", how do I fix it? Print

When trying to connect to our SQL servers you may receieve the following error:

SqlException (0x80131904): 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.)]

This is happening due to the setup of our hosting, all the traffic between the web servers and the database occurs internally using an internal IP address, due to this the SSL certificate does not match.

To resolve the above error please add the following line onto the end of your database connection string:

Encrypt=false;