Unable to connect to SQL Server docker container

[gbritton1]

Issue Type: Bug

1. start SQL Server container:

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=" -p 1443:1433 -d mcr.microsoft.com/mssql/server:2019-latest

2. Start VS Code

3. Click on "Open a remote window" (bottom left of window)

4. follow prompts to connect to container from step 1

error message given:

Cannot create directory
mkdir: cannot create directory '/home/mssql': Permission denied

VS Code version: Code 1.62.2 (3a6960b964327f0e3882ce18fcebd07ed191b316, 2021-11-11T20:56:38.428Z)
OS version: Windows_NT x64 10.0.22000
Restricted Mode: No
Fetching remote diagnostics for 'Container mcr.microsoft.com/mssql/server:2019-latest (nifty_kapitsa)' failed.

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-8650U CPU @ 1.90GHz (8 x 2112)
GPU Status	2d_canvas: enabled gpu_compositing: enabled multiple_raster_threads: enabled_on oop_rasterization: enabled opengl: enabled_on rasterization: enabled skia_renderer: enabled_on video_decode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	15.88GB (6.20GB free)
Process Argv	--crash-reporter-id 982ba36c-2648-444f-a455-5d46c3de801b
Screen Reader	no
VM	0%

Fetching remote diagnostics for 'Container mcr.microsoft.com/mssql/server:2019-latest (nifty_kapitsa)' failed.

Extensions: none

[chrmarti]

The /home/mssql folder is missing in the image. As a workaround, you can create it manually using docker exec -u root -it <container id> /bin/bash.

[chrmarti]

Filed microsoft/mssql-docker#729. Keeping this issue to track here.

[gbritton1]

The /home/mssql folder is missing in the image. As a workaround, you can create it manually using docker exec -u root -it <container id> /bin/bash.

That doesn't work. Only gets a little further down the path:

[5345 ms] Start: Installing VS Code Server
[5345 ms] Start: Run in container: mkdir -p /home/mssql/.vscode-server/bin/ccbaa2d27e38e5afa3e5c21c1c7bef4657064247_1637592843196
[5349 ms] 
[5349 ms] mkdir: cannot create directory '/home/mssql/.vscode-server/bin': Permission denied
[5349 ms] Exit code 1
[5350 ms] Command in container failed: mkdir -p /home/mssql/.vscode-server/bin/ccbaa2d27e38e5afa3e5c21c1c7bef4657064247_1637592843196

Note that the last directory above changes with each connection attempt so you cannot pre-create it.

[chrmarti]

Make sure /home/mssql is owned by the mssql user.

[gbritton1]

works!

[chrmarti]

Closing as upstream. Thanks.