question

BellamManoj-1012 avatar image
0 Votes"
BellamManoj-1012 asked KalyanChanumolu-MSFT answered

Unable to connect to source server in azure database migration service

I am unable to connect to source server in azure migration service. I am doing a POC for migrating SQL Server database to azure sql MI using the Azure database Migration Service.

But when I create the New Migration Project and specify the source instance it gives me an error,

Error 53 - SQL connection failed.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The network path was not found

The SQL server is on my local machine itself.

azure-migrate
· 6
5 |1600 characters needed characters left characters exceeded

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

@BellamManoj-1012 Welcome to Microsoft Q&A platform and thanks for your query. Before starting the migration process, there are few prerequisites that needs to be adhered. This article documents the prerequisites to ensure Azure Database Migration Service runs smoothly when performing database migrations. Kindly check if the prerequisites are met and revert if you still face the issue.


0 Votes 0 ·

in windows firewall inbound and outbound rules i added tcp port 1433 to access the source database.
still i'm getting the same error.

please help

{ "resourceId":"/subscriptions/4424f888-90c5-4da5-ada8-c7a392adfdd8/resourceGroups/SQLWorkshop/providers/Microsoft.DataMigration/services/sqlmi-migration", "errorType":"Failed to connect, please check error details", "errorDetail":"Error 53 - SQL connection failed.Please use this interactive user guide to troubleshoot the connectivity issue: https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)The network path was not found" }

0 Votes 0 ·

in azure database migration service source iam giving my local ip address and authentication selected sql authentication.

0 Votes 0 ·

More detailed MI migration requirements provided below. Please let us know if you still run into any issues
https://docs.microsoft.com/en-us/azure/dms/resource-network-topologies

0 Votes 0 ·
Show more comments

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@BellamManoj-1012 Apologies for the delayed response.

If you are still not able to resolve the connectivity issue with Azure Database Migration Service, there are alternative methods you could consider for moving your on-premises SQL Server to Managed Instance. Like Backup and restore, Import Export Wizard/BACPAC etc

More details are here

Please let us know if you have further questions.


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

5 |1600 characters needed characters left characters exceeded

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