SQL Server 2017 on Server 2012 R2 with TLS 1.2 RRS feed

  • Question

  • I'm getting error "Connection failed - SQL Server Error 772 - TCPIP Socket" when trying to connect ODBC to a MSSQL 2017 running on Server 2012 R2.

    Researching on the error, I found this site that points out TLS is the issue. I checked the registry and TLS 1.2 is enabled with the rest of the protocols disabledbydefault (HKLM\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\).

    The site mentioned above said "Work with the vendor to request the Database API in the application is updated to support the latest SQL Server  drivers"

    What is the solution to create the ODBC for an in-house applications?

    Thank you.

    Tuesday, January 21, 2020 4:06 PM


  • Hello Friend, 

    Try this: 

    Connection failed ... SQL Server Error: 772

    If this answer helped you, mark it as helpful so that someone with a question or similar problem can find an answer or help more easily. * Jefferson Clyton Pereira da Silva - [MCSA | MCP | MCTS | MTA | Database Analyst - Sql Server and Oracle]
    • Edited by Jefferson Silva DBA Tuesday, January 21, 2020 6:39 PM translate
    • Marked as answer by Ami2013 Tuesday, January 21, 2020 7:20 PM
    Tuesday, January 21, 2020 6:38 PM

All replies