How to run SQL Server from Docker

Run a docker file that contains :
FROM microsoft/mssql-server-windows-developer

D:\Dev\DockerSQL>docker image build –tag myserversql d:\dev\dockersql

Sending build context to Docker daemon 3.072kB
Step 1/1 : FROM microsoft/mssql-server-windows-developer
latest: Pulling from microsoft/mssql-server-windows-developer 3889bb8d808b: Already exists
449343c9d7e2: Pull complete
08883151461d: Pull complete
bafeb45a72fc: Pull complete
f5c5aa235c5b: Pull complete
158fead2ffa0: Pull complete
746db9597cec: Pull complete
9e96edbd8781: Pull complete
c6dabab6234f: Pull complete
975d0dccd859: Pull complete
5b747cfb01b7: Pull complete
c77992bbfd0f: Pull complete
Digest: sha256:a3e77eb7ac136bf419269ab6a3f3387df5055d78b2b6ba2e930e1c6312b50e07
Status: Downloaded newer image for microsoft/mssql-server-windows-developer:latest
—> 19873f41b375
Successfully built 19873f41b375
Successfully tagged myserversql:latest

The, run the image:
docker run -d -p 1433:1433 -e sa_password=P@ssw0rd -e ACCEPT_EULA=Y -v C:/temp/:C:/temp/ -e attach_dbs=”[{‘dbName’:’NorthWind’,’dbFiles’:[‘C:\\temp\\NORTHWND.mdf’,’C:\\temp\\NORTHWND.ldf’]}]” myserversql

Obtain the ip address using:
docker ps -a

Take the first item and ask for IP :
D:\Dev\DockerSQL>docker inspect -f “{{ .NetworkSettings.Networks.nat.IPAddress }}” 7dfe63dd7615

Then open the SQL Server Management Studio and connect to this IP. You’re done !

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: