In a previous post, I wrote about setting up SQL Server 2019 via Docker container on Windows 10. Microsoft has championed the fact that they support more than just Windows. I decided to put that to the test and try running SQL Server 2019 on on Mac OS X using Docker. I figure Docker is Docker on pretty much everywhere it’s running, so this should be a piece of cake.
Expected behavior Start the Docker App on OSX Actual behavior Failure and diagnostic menu Information Full output of the diagnostics from 'Diagnose & Feedback' in the menu Diagnostic ID: 306AF89A-76AA-421C-AA92-AA9A78629B95 Output of Dia.
Feb 12, 2016.
Jul 03, 2018.
Assumption - Docker is already running on your Windows 10 computer. I’m making this assumption to avoid walking through install and setup of Docker on Mac OS X.
Install Docker For Mac
Step 1. Download the Software
Downloading the software works the same as it does on Windows or any other platform. At the time of this writing, the container label is “vNext-CTP2.0-ubuntu“ and it can be found on docker hub at “docker pull mcr.microsoft.com/mssql/server .”
Pull of the latest SQL Server 2019 docker container on Mac OS X
Step 2. Run the Downloaded Container
Docker Desktop Mac
Running the container is next. When the SQL Server container is run, the End User License Agreement (EULA) must be accepted and a password set for the container to execute. For the purpose of this demo, I’ll use a simple password of “Password1234'.” Such a simple password is not recommended for production.
The port for accessing the SQL Server instance in the container must also be set. Changing the port is useful for a number of reasons, The most useful one I’ve found is running multiple SQL Server containers on the same host. In this example, I’ll keep the port at the default of 1433.
The command to run the container is
Docker Run command for SQL Server 2019 on Mac OS X','raw':false},'hSize':null,'floatDir':null,'html':'','url':'https://youtu.be/UN06ockIwr4','width':854,'height':480,'providerName':'YouTube','thumbnailUrl':'https://i.ytimg.com/vi/UN06ockIwr4/hqdefault.jpg','resolvedBy':'youtube'}'>
Docker Run command for SQL Server 2019 on Mac OS X
The running state of the container can be checked by issuing the command
The SQL Server is available for connections once the state is confirmed as running.
Step 3. Connect to SQL Server
Microsoft recently renamed the SQL Operations Studio as Azure Data Studio. Azure Data Studio is available on Windows, Mac, and Linux. The connection will be made using the local sa account and the password supplied when running the container.
Docker Mac Os Image
Connecting to SQL Server 2019 Docker Container on Mac OS X using Azure Data Studio ','raw':false},'hSize':null,'floatDir':null,'html':'
Connecting to SQL Server 2019 Docker Container on Mac OS X using Azure Data Studio
That’s it! The container works and functions the same as any other SQL Server would behave. Containerized instances are simple to setup and allow for testing and experimentation on platforms that were previously off limits.
Install Docker On Mac Os
Key Features and Capabilities
The fastest way to design and deliver containerized applications and microservices on the desktop and cloud.
Simple Setup for Docker and Kubernetes
No need to fiddle with VMs or add a bunch of extra components; simply install from a single package and have your first containers running in minutes. You get certified Kubernetes and Docker, for developers of all levels of container expertise.
Certified Kubernetes
Setup a fully functional Kubernetes environment on your desktop with a single click and start developing and testing modern applications in minutes.
Docker On Osx
Application Templates and App Designer
Customize and share multi-service applications and service templates that are tailored to your organization. Pre-defined and customizable application templates adhere to corporate standards and automate configuration, eliminating error-prone manual setup. Intuitive Application Designer facilitates the packaging, installing, and managing of multi-service applications as a shareable package.