Using SQL Server Management Studio to remote connect to docker container

sql-server docker digital-ocean
noobmaster69 picture noobmaster69 · Dec 27, 2017 · Viewed 25k times · Source

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 a Docker Container for MS SQL Server 2017 running on a DigitalOcean Ubuntu 16.04 box. From my Mac I can remote SSH in to the server, access the container and query the database.

However I wish to use SSMS on my Windows PC and am unsure how I begin to connect to the remote box. In the picture below, there are no options to specify an SSH key or to even login in to the Ubuntu box, only to access the SQL server.

enter image description here

Is this even possible?

Answer

paul stanton picture paul stanton · Jan 5, 2018

connect via SSMS using the public IP address, followed by comma separator and then the port (xxx.xx.xx.xxx,port)

You'll also need the sa credentials to make this work.

Related questions

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
Restore SQL Server database to Linux Docker

I need to restore a large SQL Server database on a Linux Docker instance (https://hub.docker.com/r/microsoft/mssql-server-linux/) I'm moving my .bak file to the docker and executing this command in mssql shell: RESTORE DATABASE gIMM_Brag …

Read More