Add Encrypt and TrustServerCertificate to Connection Strings

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud

MIT License

232 stars 52 forks source link

Add Encrypt and TrustServerCertificate to Connection Strings #92

Closed shellninja closed 4 years ago

shellninja commented 4 years ago

This PR adds the capability to use the Encrypt=true and TrustServerCertificate=true to connection properties. Tested against local databases using the following JSON:

 "ConnectionInfo": {
        "ServerName": "",
        "UseWindowsAuthentication": true,
    "Encrypt": true,
    "TrustServerCertificate":` true
      }

spaghettidba commented 4 years ago

Awesome addition, thanks! I'll test it as soon as possible and merge it. I had a look at the code and it seems pretty straightforward, so it should be quick.