Failed to start SQL Tools Service

[jewelyk]

Type: Bug

Error when starting ADS - 'Failed to start SQL Tools Sevice'.

Existing connections just keep spinning and do not connect. Cannot create new connections either.

• Azure Data Studio Version: 1.47.0
• OS Version: MacOS Sonoma 14.1 (23B2073)

Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:19:19.203Z) OS version: Darwin arm64 23.1.0 Restricted Mode: No Preview Features: Enabled Modes:

System Info

Item	Value
CPUs	Apple M3 Pro (12 x 24)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled
Load (avg)	3, 2, 2
Memory (System)	18.00GB (0.04GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none

[cheenamalhotra]

Hi @jewelyk

Do you see any error in logs? You can open SQLTools.log using F1 > MSSQL: Show Log File command.

[jewelyk]

The SQL Tools Service.log is empty

[cheenamalhotra]

Noticed below error in the log file:

2024-01-10 16:46:31.485 [error] Activating extension Microsoft.mssql failed due to an error:
2024-01-10 16:46:31.485 [error] Error: Command failed: uname -m
/bin/sh: uname: command not found

	at ChildProcess.exithandler (node:child_process:430:12)
	at ChildProcess.emit (node:events:513:28)
	at maybeClose (node:internal/child_process:1091:16)
	at Socket.<anonymous> (node:internal/child_process:449:11)
	at Socket.emit (node:events:513:28)
	at Pipe.<anonymous> (node:net:322:12)

I believe this is related with missing Rosetta library. Please ensure you have it installed as documented for ARM64 machines: https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?tabs=macOS-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall#install-azure-data-studio

[jewelyk]

I get this error message and still have problems with Azure Data Studio

% /usr/sbin/softwareupdate --install-rosetta --agree-to-license

By using the agreetolicense option, you are agreeing that you have run this tool with the license only option and have read and agreed to the terms. If you do not agree, press CTRL-C and cancel this process immediately. 2024-01-11 09:05:29.989 softwareupdate[1065:13069] Package Authoring Error: 042-41726: Package reference com.apple.pkg.RosettaUpdateAuto is missing installKBytes attribute Install of Rosetta 2 finished successfully

[cheenamalhotra]

Hi @jewelyk

Please reach out to Apple support to resolve issues installing Rosetta. Once that gets fixed, ADS should work normally.

[jasonhowarth]

I get the same error ("Failed to start SQL Tools Service") when starting up ADS v1.49.1 on macOS 13.5 on an Intel-based Mac (not Apple silicon). Rosetta cannot be installed on Intel-based Mac. I also can not open MSSQL logs - ADS throws "Command 'MSSQL: Show Log File' resulted in an error".

[kburtram]

@jasonhowarth could you please confirm you are using the ADS build that is specific to the Intel chipset? Specifically, for 1.49.1 this build is available from https://go.microsoft.com/fwlink/?linkid=2282379.

[jasonhowarth]

@kburtram Yes, I confirm I am using 1.49.1 for Intel Chip.