Share via

Unable to login to SQL Server 2016 database through ODBC after enabling TLS 1.2

Kazi Ariful Haq 161 Reputation points
2020-10-10T05:16:21.567+00:00

Hi,

Recently we have enabled TLS 1.2 in our SQL Server 2016 environment. After that database service got up and we can login through SQL Server management studio. But we are not able to login to database through ODBC. Can anyone help for workaround for this.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 110.3K Reputation points
    2020-10-10T11:55:56.02+00:00

    How does your connection string look like? Out of the blue, I would guess that you are using the ODBC driver that ships with the OS and which is very old. You should be using the most recent version of the SQL Server ODBC Driver, which you find here: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

    0 comments
  2. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2020-10-12T02:56:40.47+00:00

    Hi @Kazi Ariful Haq ,

    What the version of ODBC for SQL Server are you using? You can use this Powershell script to check if client components are TLS 1.2 compatible.
    In addition, here is an article about ODBC Driver for SQL Server connection strings which might help.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.