search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

"Starting client failed" error when installing Sql Migration extension #24917

Open sgft001 opened 10 months ago

sgft001 commented 10 months ago

Steps to Reproduce:

  1. Install SQL Migration Extension
  2. View the output

Downloading https://github.com/Microsoft/sqltoolsservice/releases/download/4.10.0.9/microsoft.sqltools.migration-win-x64-net7.0.zip (54,448 KB)....................Done downloading Sql Migration Service Installing Sql Migration Service to c:\Users\sgfx\.azuredatastudio\extensions\microsoft.sql-migration-1.4.11\migrationService\Windows\4.10.0.9 Installed Sql Migration Service [Error - 6:12:14 PM] Starting client failed Error: spawn UNKNOWN at ChildProcess.spawn (node:internal/child_process:413:11) at Object.spawn (node:child_process:783:9) at c:\Users\sgfx\.azuredatastudio\extensions\microsoft.sql-migration-1.4.11\dist\main.js:2:741075 at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

kisantia commented 10 months ago

@sgft001 does this happen consistently? Did this only start happening with the latest release?

I just tried installing the Azure SQL Migration extension on the ADS 1.47.0 release today and did not run into this error. image

sgft001 commented 10 months ago

@kisantia, this is the first time I am using the product so I just installed the latest version since I need to run SQL Migration assessment against SQL Server database - please advise on troubleshooting approach.

kisantia commented 10 months ago

@cpichuka @stuti149 can you please help with this sql migration issue?

@sgft001 can you try uninstalling and reinstalling the extension and see if this is an intermittent issue?

sgft001 commented 10 months ago

@kisantia , I uninstalled/reinstalled/reloaded ADS a few times - same outcome

stuti149 commented 10 months ago

@sgft001 @kisantia.

I am able to install Azure SQL migration extension on ADS version 1.47.0 successfully as well. Version: 1.47.0 (user setup) Commit: c7c2b2f21505562d21972d4c135119d00806db4f Date: 2023-11-07T17:17:45.669Z VS Code: 1.82.0 Electron: 25.8.4 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.22621

image

@sgft001, Can you check if you are able to install the same on other versions of ADS?

sgft001 commented 10 months ago

Thanks - will do during the day Thu and update this post

sgft001 commented 10 months ago

@stuti149 @kisantia - I installed ADS 1.45.1 instead and migration extension got installed correctly and assessment started to work - not sure what's the issue with the latest version