Migration Project won't connect to Azure Managed Instance Target server

Alex Hatcher 6 Reputation points
2021-03-08T17:57:19.987+00:00

I have a running SQL managed instance that is useable via my on-Prem SQL Studio.

I can create and destroy databases via Portal and on-prem ssms

I made sure ports, 1433, 443, 445, 9354 and 12000 were open.

I can connect via SSMS with my azure AD AND with my Sql login.

I run through the DMS: connect to OnPrem, select a database, continue on to the connect to Target Server

I paste the FQBN of my azure migrated instance name, my sql login and password.

it fails after a couple minutes with Failed to connect, please check error details Error 10060 - SQL Server cannot connect to server.

Azure Database Migration service
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Hatcher 6 Reputation points
    2021-03-08T19:48:45.447+00:00

    problem was: port 1433 in from 172.28.0.0/22 (where the data migration instance is) to 172.28.5.0/24 (where the SQL MI is) wasn't allowed

    1 person found this answer 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.