AWS DMS connection to Azure MySql database failed.

Darshan 21 Reputation points
2022-05-06T12:18:09.487+00:00

Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to connect ODBC general error., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HY000 NativeError: 0 Message: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Protocol error in TDS stream

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
992 questions
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,547 Reputation points Microsoft Employee Moderator
    2022-05-06T19:16:00.617+00:00

    Hi, @Darshan Welcome to the Microsoft Q&A forum, and thanks for reaching out.
    If my understanding is correct you are connecting to an SQL server, correct me if I am wrong since you mentioned Azure MySQL but the error message shows as SQL

    If you are connecting to a SQL Server. If so, you might have to enable TLS 2.0 by installing a CU, or alternately, you might have to disable validation for TLS 2.0 in DMS.

    Please let me know if you need any additional information.

    Regards
    Geetha


0 additional answers

Sort by: Most helpful

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.