Azure Data Studio SQL Migration waiting to start forever

Question

After installing and enabling azure sql migration extension in azure data studio it was unable to launch and throwing error as "Failed to start service" then I have updated the required proxy setting in Azure data studio, error is gone but Azure SQL migration extension is hung / taking forever to start with message "Waiting for SqlMigrationProvider component to start Source: Azure SQL Migration (Extension)".

Version is 1.5.7

version in json file is 5.0.20241024.1

Answer 1

Hi HassanET1,

Thank you for sharing your question, and welcome to Microsoft Q&A!

Please try the following steps to resolve the issue:

Verify Network and Proxy Configuration:
Ensure all necessary Azure endpoints are accessible, such as https://*.database.windows.net and https://*.azure.com.

Update Azure Data Studio:
Download and install the latest version of Azure Data Studio from this link:
Download Azure Data Studio.

Reinstall Azure SQL Migration Extension:

• Navigate to Extensions in Azure Data Studio.
• Uninstall the Azure SQL Migration extension and reinstall it from the marketplace:
  Azure SQL Migration Extension Documentation.

Review Logs:

• Open the Developer Tools in Azure Data Studio to check for errors:
  Help > Toggle Developer Tools > Console Logs.
• Inspect the SqlMigrationProvider logs for details.

Reset Azure Data Studio Settings:
Reset the settings to default configurations if any misconfiguration is suspected.

For additional troubleshooting and guidance, you may find these resources helpful:

• Assess SQL Server Databases for Migration
• Known Issues and Troubleshooting DMS

I hope this helps resolve your issue! If you need further assistance, feel free to comment below. I’d be happy to help!

Best regards,
Chakravarthi Rangarajan Bhargavi

• If you find the solution helpful, kindly accept the answer and upvote it to support the community. Thanks a lot!