Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
308 questions
SQL server databases migration to Azure SQL VM using Azure Data studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjeev Koppella
0
Reputation points
Hello,
I am migrating the SQL server databases to Azure SQL VM using Azure data studio but step 6 - validating the connectivity failed with below error.
I am able to connect to SQL server using SSMS from same server.
I can be able to see the "Microsoft.DataMigration" has already registered in subscription.
I opened the connectivity from DMS to Source server (open the 1433 port).
Please help to resolve this error.
Failed to connect to the database. Error message: Cannot connect to SQL Database.
Please contact SQL server team for further support. Server: 'servername', Database: '', User: 'sa'.
Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
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)
Access is denied
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva 245 Reputation points Microsoft Vendor2024-10-16T14:17:46.1366667+00:00 Hi @Sanjeev Koppella,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
It seems like there is an issue with the connectivity issue during your migration process.
Here are a few steps you can take to troubleshoot and resolve this error:
Verify Network Configuration:
- Ensure that the firewall rules on both the source and target servers allow traffic on port 1433.
- Check if there are any network security groups (NSGs) or other network configurations that might be blocking the connection.
Check SQL Server Configuration:
- Confirm that the SQL Server instance is configured to allow remote connections. You can do this in SQL Server Management Studio (SSMS) by right-clicking on the server, selecting “Properties,” and then checking the “Connections” tab, ensure that "Allow remote connections to this server" is checked.
- Make sure the SQL Server and SQL Server Browser services are running.
Validate Credentials:
- Double-check the credentials you’re using to connect. Ensure that the username and password are correct and have the necessary permissions.
Review Linked Service Configuration:
- Make sure the linked service configuration in Azure Data Studio is correct. Verify the server name, database name, and other connection details.
Check Integration Runtime:
- If you're using self-hosted integration runtime is properly configured and running. It should have access to both the source SQL Server and the target Azure SQL VM.
Test Connectivity:
- Use tools like telnet or ping to test connectivity to the SQL Server from the machine where Azure Data Studio is running. This can help identify if there are any network issues.
Review Logs:
- Check the logs for more detailed error messages. This can provide additional insights into what might be causing the connectivity issue.
I would request you to refer the below mentioned links for more information.
I hope this information helps. Please do let us know if you have any further queries.
-
Sanjeev Koppella 0 Reputation points
2024-10-17T06:08:32.8066667+00:00 Thanks @Anonymous
Verify Network Configuration: Yes i opened the both 1433 and 443 ports on Integration run time server and SQL VM.
Check SQL Server Configuration: Yes remote connection enabled and running browser services on VM
Validate Credentials: Yes I can able to connect from SSMS from same machine ( DMS )
Review Linked Service Configuration: Linked server means, Source server name and logins credentials, right
Check Integration Runtime: How to validate( I can able to ping the server from Intergration server)>
Test Connectivity: I can able ping the SQL server from Integration run time server
Integration run time logs:
The gateway did not receive a response from 'Microsoft.DataMigration' within the specified time period.
I have also checked Microsoft.DataMigration already registered on subscription.
I am sure there is connectivity issues between Source SQL server to Integration run time but i have already opened the 443, 445 and 1433 ports on SQL server and integration run time servers.
Source: Azure SQL VM
Destination: Azure SQL VM
Intergration run time installed on Azure VM, all are in same NSG.Please let me know if i need to open any other ports.
Sign in to comment
Sign in to answer