Category: Docker

Docker Containers: Common Issues

Issue: 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. 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. Solution: Connect via SSMS using the public IP address, followed by comma separator and then the port (,port).You’ll… Read More

Docker Containers: Additional Commands

Rename a Container Change the SA password The SA account is a system administrator on the SQL Server instance that gets created during setup. After creating your SQL Server container, the MSSQL_SA_PASSWORD environment variable you specified is discoverable by running echo $MSSQL_SA_PASSWORD in the container. For security purposes, change your SA password. Choose a strong password to use for the SA user. Use docker exec to run sqlcmd to change the password using Transact-SQL. In the following example, replace the old password, <YourStrong!Passw0rd>, and the new password, <YourNewStrong!Passw0rd>, with your own password values. Remove your container If you want to remove the SQL Server container used in this tutorial, run the following… Read More

Docker Containers: Creating a SQL Server Demo Environment

Running SQL Server in a Docker Container In order to run our SQL Server container we have to execute the following code in PowerShell:  Note The password should follow the SQL Server default password policy, otherwise the container can not setup SQL server and will stop working. By default, the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols. You can examine the error log by executing the docker logs command. The following table provides a description of the parameters in the previous docker run example: Parameter… Read More

Docker Containers: Getting An Image

I will be working with Docker running on Windows (although sometimes on Linux). Docker appears to be the most popular and has a strong standard. You can go here to get the appropriate Docker installation. If you are unfamiliar with what a container is or why they are used Docker has a great explanation here. Basically, a container is a standard unit of software that packages up code and all its dependencies so the application runs quickly and reliably from one computing environment to another. A Docker container image is a lightweight, standalone, executable package of software that includes everything needed to… Read More

Docker Containers: Why?

Since discovering Docker, I rarely find my self directly installing software on my computer or home lab. Whether is it a database server (Microsoft SQL Server) or I am just wanting to explore something new  I try to find or build an appropriate Docker image. Installing software is not hard, however using Docker saves time and provides consistency by reducing the task of installing and running software to just two commands (docker run and docker pull). In my next post I will show this process in action by taking a step by step look at how easy and simple it… Read More