Encrypt connections(data on transit/motion) to Azure SQL db

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  January 12, 2018 at 6:02 am

  #327134

  Hi Folks,

  I wanted to make sure my data is encrypted when retrieving from azure sql db as there is secure info that we are accessing. Do enabling following parameters on connection string automatically enables the data in transit encryption?
  Encrypt=True and TrustServerCertificate=False

  I'm accessing using SSMS & SSRS. Please share your thoughts.

  Many Thanks.
  SQL DBA

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 12, 2018 at 10:12 am

  #1975751

  SQL!$@w$0ME - Friday, January 12, 2018 6:02 AM

  Hi Folks,

  I wanted to make sure my data is encrypted when retrieving from azure sql db as there is secure info that we are accessing. Do enabling following parameters on connection string automatically enables the data in transit encryption?
  Encrypt=True and TrustServerCertificate=False

  I'm accessing using SSMS & SSRS. Please share your thoughts.

  Many Thanks.
  SQL DBA

  Correct. It's explained in the following documentation:
  Securing your SQL Database

  Sue

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  January 13, 2018 at 7:52 am

  #1975828

  Thanks Sue!