-
Using unmodified MS SQL Server image
Execute connection scriptrun_sql_server_image.sh
to create SQL Server Developer container. This will result in a container with a fresh instance of SQL Server. That approach does not give a lot of customizability. -
Using custom image on top of MS SQL Server's image
Docker images are beeing created using Dockerfile containig build instructions. In order tu build an imagedocker build [args]
command is used, but Feel free to use
build_custom_sql_server_image.sh
script to perform the image build with predefined arguments. Thenrun_custom_sql_server_image.sh
script can be use to run the built image.
docker images
command displays all images stored on you local Docker image repository.
docker image rm tag/name
command deletes specified image from local Docker image repository
To establish connection between SQL Server Management Studio and SQL docker container containers name is used, probably due to internal docker DNS. Therefore it is recommended to give provide a name for container to maintain connectivity with SSMS.
ip_address\container_name,port
Microsoft SQL Server Dockerhub page
Stack Overflow issue resolving SSMS to SQL Server container connectivity
Microsoft Docs: Configure and Customize SQL Server Docker containers