question

NileshPatel-7672 avatar image
0 Votes"
NileshPatel-7672 asked GeethaThatipatri-MSFT commented

Unable to connect SQL Server multi instance from DMS

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

azure-database-migrationazure-virtual-machines-migration
· 3
5 |1600 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.

GeethaThatipatri-MSFT avatar image GeethaThatipatri-MSFT ·

Hi, @NileshPatel-7672 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

0 Votes 0 ·
GeethaThatipatri-MSFT avatar image GeethaThatipatri-MSFT GeethaThatipatri-MSFT ·

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

Regards
Geetha

0 Votes 0 ·
GeethaThatipatri-MSFT avatar image GeethaThatipatri-MSFT GeethaThatipatri-MSFT ·

Hi, @NileshPatel-7672 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

0 Votes 0 ·

0 Answers