Then connect with sqlcmd to create your first database and run queries. It can be used with the Docker Engine 1. The Windows image is not covered, but you can learn more about it on docker run vs exec. This is the default for most users. If you find that you are not using this storage provider and need to change, please see the instructions and warnings in the. If you want to pull a specific image, you add a colon and the tag name for example, mcr. To see all available images, see. For the bash commands in this article, sudo is used. On Linux, if you do not want to use sudo to run Docker, you can configure a docker group and add users to that group. 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 command. The process for running production editions in containers is slightly different. If you run more than one container, you cannot reuse this same name. The -h host name parameter is also useful, but it is not used in this tutorial for simplicity. This changes the internal name of the container to a custom value. To instead use container images based on RedHat, see. If you want to pull a specific image, you add a colon and the tag name for example, mcr. To see all available images, see. For the bash commands in this article, sudo is used. On Linux, if you do not want to use sudo to run Docker, you can configure a docker group and add users to that group. If you run more than one container, you cannot reuse this same name. The -h host name parameter is also useful, but it is not used in this tutorial for simplicity. This changes the internal name of the container to docker run vs exec custom value. Replace and with your own password values. In the following example sql1 is name specified by the --name parameter when you created the container. Sqlcmd is not in the path by default, so you have to specify the full path. Your container continues to run after you exit the interactive bash shell. The same principles apply when using other tools, but the process of connecting is unique to each tool. On Linux, use ifconfig or ip addr. In this example, that is the same port, 1433, on the host machine. If you specified a different mapped port on the host machine, you would use it here. If you need to preserve your data, or use a. The following video shows how Docker docker run vs exec be used in a continuous integration and deployment scenario.