question

AlexHatcher-7592 avatar image
0 Votes"
AlexHatcher-7592 asked ·

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

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
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlexHatcher-7592 avatar image
1 Vote"
AlexHatcher-7592 answered ·

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 ·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NavtejSaini-MSFT avatar image NavtejSaini-MSFT ·

@AlexHatcher-7592 - We are glad you were able to resolve this and thank you for posting the answer as well.

Regards
Navtej S

0 Votes 0 ·