Run RHEL-based container images All of the documentation on SQL Server Linux container images point to Ubuntu-based containers. Beginning with SQL Server 2019 preview, you can use containers based on Red Hat Enterprise Linux (RHEL). Change the container repository from mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu to mcr.microsoft.com/mssql/rhel/server:vNext-CTP2.0 in all of your docker commands. For example, the following command pulls the latest SQL Server 2019 preview container that uses RHEL: sudo docker pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2 docker pull mcr.microsoft.com/mssql/rhel/server:2019-CTP2.2. Mac os 8 emulator online.

Run SQL Server vNext CTP 1 as a Docker Container on a Mac Docker installation on Ubuntu Linux Docker is an open-source tool to create, deploy and run applications using containers. Host volume mapping for Docker on Mac with the SQL Server on Linux image is not supported at this time. Use data volume containers instead. Get started with SQL Server 2017 container images on Docker by going through the quickstart. Also, see the mssql-docker GitHub repository for resources, feedback.

Run production container images The quickstart in the previous section runs the free Developer edition of SQL Server from Docker Hub. Most of the information still applies if you want to run production container images, such as Enterprise, Standard, or Web editions. However, there are a few differences that are outlined here. • You can only use SQL Server in a production environment if you have a valid license. You can obtain a free SQL Server Express production license.

SQL Server Standard and Enterprise Edition licenses are available through. • The Developer container image can be configured to run the production editions as well. Use the following steps to run production editions: Review the requirements and run procedures in the. You must specify your production edition with the MSSQL_PID environment variable.

Tip You don't always have to specify the entire container id. You only have to specify enough characters to uniquely identify it. So in this example, it might be enough to use e6 or e69 rather than the full id. • Once inside the container, connect locally with sqlcmd. Note that sqlcmd is not in the path by default, so you have to specify the full path.

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ' • When finished with sqlcmd, type exit. • When finished with the interactive command-prompt, type exit. Your container continues to run after you exit the interactive bash shell. Run multiple SQL Server containers Docker provides a way to run multiple SQL Server containers on the same host machine. This is the approach for scenarios that require multiple instances of SQL Server on the same host. Each container must expose itself on a different port. The following example creates two SQL Server 2017 containers and maps them to ports 1401 and 1402 on the host machine.

Docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1401:1433 -d mcr.microsoft.com/mssql/server:2017-latest docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1402:1433 -d mcr.microsoft.com/mssql/server:2017-latest docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1401:1433 -d mcr.microsoft.com/mssql/server:2017-latest docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1402:1433 -d mcr.microsoft.com/mssql/server:2017-latest. The following example creates two SQL Server 2019 preview containers and maps them to ports 1401 and 1402 on the host machine. Docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1401:1433 -d mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1402:1433 -d mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1401:1433 -d mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=' -p 1402:1433 -d mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu Now there are two instances of SQL Server running in separate containers. Clients can connect to each SQL Server instance by using the IP address of the Docker host and the port number for the container. Sqlcmd -S 10.3.2.4,1401 -U SA -P ' sqlcmd -S 10.3.2.4,1402 -U SA -P ' sqlcmd -S 10.3.2.4,1401 -U SA -P ' sqlcmd -S 10.3.2.4,1402 -U SA -P ' Create a customized container It is possible to create your own to create a customized SQL Server container. For more information, see.