Post reply

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

  • 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

  • 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

  • January 13, 2018 at 7:52 am

    #1975828

    Thanks Sue!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply