How to connect Docker with Azure Data Studio?

sql-server docker azure-data-studio
Jonzz picture Jonzz · Nov 5, 2018 · Viewed 7.2k times · Source

I install docker container on mac(OS X) and install Microsoft SQL 2017 image file on docker.So, I try to connect docker with Azure Data Studio but didn't connect it. Can I connect docker with Azure Data Studio and How to configure it? Please help me, thank a lot.

Answer

Gary Krause picture Gary Krause · Jan 12, 2019

Use 127.0.0.1,1433 instead of 127.0.0.1:1433

This syntax is what my ASP.NET Core app uses as syntax so I figured MS liked that format for connection strings and such.

This worked for me. Hope it helps.

Related questions

Using SQL Server Management Studio to remote connect to docker container

Context: I am trying to build a development SQL Server that I can continue to learn SQL on and use Microsoft SQL Server Management Studio (SSMS) to access on a Windows PC. So I have the AdventureWorks database sitting on …

Read More
How to use windows authentication with SQL server docker container

I have gone through all the examples I could find online for building docker container based applications. I would want to run two services running in two docker containers: A windows container running ASP.NET A windows container running SQL …

Read More
Docker + mssql-server-linux: How to launch .sql file during build (from Dockerfile)

I am trying to create my own Docker image with MSSQL DB for development. It's based on microsoft/mssql-server-linux image. During the build I want to copy some .sql files into the container and then run these scripts (to create …

Read More