Docker Community Forums

Share and learn in the Docker community.

I need help connecting Mac to Azure Data Studio using docker

I was able to do the docker pull but the

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=yourStrong(!)Password" -e "MSSQL_PID=Express" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest 

won’t run for me.

Can you explain a bit more what dosnt work? Any errors?

Thanks for your help, I can’t get the docker container to connect. TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)

Here is the error exact.

is the container running? (docker ps)

Yes, it is running. I’ve deleted it and started a new one a few times as well.

In the topic title you wrote “connecting Mac to Azure Data Studio” but as I see, you want to connect from Azure Data Studio running on MacOS to MSSQL Server running in a Docker container. Am I right? And if I am right, where is the Docker container running? Is it on the same Mac or on an other machine?

update:

I tried Azure Data Studio on MacOS and MSSQL server on MacOS. The MSSQL server could not start because the host VM had incompatible kernel settings. I managed to run it on a Linux machine using your command and connect to it from Azure Data Studio on MacOS.

Yes, you are correct. I am on a mac. How do I connect it to Linux?

As you would connect to any machine. Can you explain what is the problem?

I think I figured out the issue, I need to find the
Host
Port
User name
for my Mac and for Docker.
This way I can connect them. Hope this makes sense. Thanks for you help!