locked
How to enable TLS 1.2 on Sql server 2012 SP4 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Msdn,

    We recently installed SQL 2012 sp4 and trying to Enable TLS 1.2 On the same.

    Could you please let me know step by step process to check current TLS version and to enable TLS 1.2 on both windows server and SQL SERVER 2012 SP4.

    Thanks........

    Friday, April 26, 2019 6:08 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Adithya,

    To enable TLS1.2 on SQL server 2012 SP4, firstly, please check whether the patch for enabling TLS 1.2 is installed. Please refer to TLS 1.2 support for Microsoft SQL Server.
    SQL Server in Windows also supports TLS1.0 and TLS1.1. If you want to use only TLS 1.2 for client-server communication, please disable TLS 1.0 and 1.1 in Registry Editor.
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols, "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001.
    And then reboot your machine and test whether the connection can do well. By the way, you can see the blog to verify if a connection to SQL Server is Encrypted.
    Hope this helps you.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 29, 2019 7:00 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    SQL Server 2012 SP4 has support for TLS 1.2, what operating system version are you currently running?

    One easy way to check or enable/disable different server protocols is by using the free IIS Crypto software.

    Best regards,
    Leon

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, April 26, 2019 6:53 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    The OS is windows 2012 R2 standard, I know the process to check in server level, but how can I check at sqlserver level whether it is enabled.

    Regards,

    Adithya

    Friday, April 26, 2019 12:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Maybe this article could be helpful:

    https://blogs.msdn.microsoft.com/sqlreleaseservices/tls-1-2-support-for-sql-server-2008-2008-r2-2012-and-2014/

    Blog: https://thesystemcenterblog.com LinkedIn:

    Friday, April 26, 2019 1:03 PM
    Answerer
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Adithya,

    To enable TLS1.2 on SQL server 2012 SP4, firstly, please check whether the patch for enabling TLS 1.2 is installed. Please refer to TLS 1.2 support for Microsoft SQL Server.
    SQL Server in Windows also supports TLS1.0 and TLS1.1. If you want to use only TLS 1.2 for client-server communication, please disable TLS 1.0 and 1.1 in Registry Editor.
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols, "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001.
    And then reboot your machine and test whether the connection can do well. By the way, you can see the blog to verify if a connection to SQL Server is Encrypted.
    Hope this helps you.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 29, 2019 7:00 AM