Unable to connect SQL Server multi instance from DMS

Nilesh Patel 111

Migrating on-premise SQL server to Azure SQL MI using Azure DMS.
My issue is related to connecting source sql server in Azure DMS. IP Address and host name is same for both default instance (servername) and multi instance (servername\instance1). We could able to connect default instance from DMS but multi instance is not working & getting error. Please advise how to fix or connect it.

Thanks,
Nilesh

GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2022-02-21T16:14:31.36+00:00

Hi, @Nilesh Patel Thanks for the ask and using the Microsoft Q&A platform.
As we understand the ask here is to connect mutil instances using DMS, Please do let me know if that is not accurate.
Can you please share with us the error screenshot which helps us to understand more, meanwhile you can try Servername.domain.com\instancename

Regards
Geetha
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2022-02-23T15:38:26.027+00:00

Hi, @Nilesh Patel We haven't heard back from you. Just wanted to check if you are still facing the issue?

Regards
Geetha
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2022-02-25T15:51:51.62+00:00

Hi, @Nilesh Patel We haven't heard back from you. Just wanted to check if you are still facing the issue? In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Regards
Geetha

Share via

Unable to connect SQL Server multi instance from DMS

Your answer