Encryption strenght with SQL Server self-signed certificate RRS feed

  • Question

  • I have SQL Server 2008 R2 Standard (64-bits) on Windows Server 2008 R2 Enterprise (64-bits) and client computers running on Windows 7 Professional (64-bits). If I set "Encrypt=True;TrustServerCertificate=True;" in connection strings, I'm wondering what encryption level or strength (40bits, 128bits, or other) are the connections getting?

    Microsoft is not clear about this topic:

    "The level of encryption used by SSL, 40-bit or 128-bit, depends on the version of the Microsoft Windows operating system that is running on the application and database computers."

    I appreciate any comment.

    • Edited by XXXX2525 Tuesday, September 9, 2014 4:40 PM
    Tuesday, September 9, 2014 4:39 PM