SQL Server to Azure SQL Data Migration Fail

John Laidlaw 46 Reputation points
2020-11-21T23:27:20.597+00:00

On Premises SQL Server to Azure SQL database Offline Data Migration.

Fails at the Select Source stage with "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" }"

SQL Server is a default instance. It is running and listening on port 1433. I can ping FQDN of Server, it's name and ip address. The firewall seems properly configured. I can successfully connect using UDL file with multiple logins, using both Windows Authentication and SQL Authentication. I successfully ran the DMA and also successfully ran the schema only migration. I have used all the same logins as for the UDL tests and they all fail.

What else can I check?

Thank you

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,802 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,616 Reputation points
    2020-11-24T02:39:47.55+00:00

    Hi @John Laidlaw ,

    So you are trying to use the Microsoft Data Migration Assistant tool to migrate from the on-premises SQL Server to the Azure SQL database, but you cannot connect to the source on-premises SQL Server instance.
    It seems that the computer hosting the DMA tool is different from the server hosting the local SQL Server instance by your description. This seems to be a remote connection issue. For this, you can check the doc: Troubleshoot connecting to the SQL Server Database Engine.

    0 comments No comments