Connection Error with Azure DMS

Nilesh Patel 111 Reputation points
2021-10-11T10:12:21.327+00:00

I'm getting the error while connecting the DMS with my source SQL server.
And, I'm using the free subscription.

Attaching the screenshot of the error.139425-error.png

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
538 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2021-10-12T03:04:35.897+00:00

    Hi @Nilesh Patel ,

    As the error message mentioned, please follow the steps from the MS document Resolving connectivity errors to SQL Server to resolve the issue.

    In addition, I read the other thread that you posted, it seems you want to migrate SQL Server to an Azure SQL Managed Instance using DMS. There are some prerequisites and note for this progress, such as Open your Windows Firewall to allow Azure Database Migration Service to access the source SQL Server, which by default is TCP port 1433. If your default instance is listening on some other port, add that to the firewall. Configure your Windows Firewall for source database engine access, etc. So please check the list from MS document to find that if you missing something that caused this issue.

    If i misunderstood your issue, please let me know.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments No 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.