Unable to access data after securring the database

[Matt Brown]

If we use the following setting in the config file, we are able to access the data in the database.

<add key="app" value="server=server001;port=3306;database=db;uid=readonly;pwd=readonly;" />

This gets flagged in a Fortify scan. We can connect to the DB via an SSL certificate in Workbench. We change the value string in the above to the below, and suddenly we can't get the data to come up in our site.

<add key="app" value="server=server001;port=3306;database=db;uid=readonly;pwd=readonly;Encrypt=yes;TrustServerCertificate=yes" />