https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn

Solution: add the line below to your connection string

TrustServerCertificate=True