Cannot connect to migrate sql workloads azure sql database assessment. Keep retrying connection

Question

I completed the training for migrating sql workloads to azure and when I try to access the assessment it gets into a loop saying "retrying connection"

Answer 1

If you are experiencing a continuous "retrying connection" loop when trying to access the SQL workload migration assessment in Azure, it may indicate connectivity issues between your SQL Server instance and Azure. Here are some steps to troubleshoot the problem:

1. Check SQL Server Status: Ensure that your SQL Server instance is powered on and accessible.
2. Verify Connection Status: Make sure that the connection status of the SQL agent in Azure Migrate is marked as Connected. You can also check the last heartbeat to ensure it is up-to-date.
3. Firewall and Network Settings: Ensure that outbound connections on port 443 (HTTPS) are allowed, as this is necessary for communication with Azure services.
4. Check Azure Migrate Configuration: Confirm that all SQL instances are properly configured and that the Azure Migrate connection status for all SQL instances is Connected in the discovered SQL instance pane.
5. Retry After Waiting: If you see a notification advising you to wait, keep the page open, as the portal may automatically retry the operation after five minutes. If the issue persists, consider refreshing the page after the wait time.

If these steps do not resolve the issue, further investigation into the specific error messages or logs may be required.

---

References:

• Troubleshoot assessment - FAQ
• Error notifications requiring users to wait five minutes