

Download and install Node.js, if you don't already have it.įrom the Terminal, install sql-cli globally, so you can use it anywhere. Sql-cli is a useful command-line tool for SQL Server. You can then use Kitematic to view the output of your containers, manage their settings, etc. The first time you click Open Kitematic, it will prompt you to download and install it. Kitematic is a nice desktop application for managing Docker containers. microsoft/mssql-server-linux: this final parameter tells Docker which image to use.SQL Server, by default, listens for connections on TCP port 1433. -p 1433:1433: this maps the local port 1433 to the container's port 1433.-e 'MSSQL_PID=Developer': this sets an environment variable to instruct SQL Server to run as the Developer Edition.

-e this sets an environment variable for the sa database password.This is required to run SQL Server for Linux. -e 'ACCEPT_EULA=Y: this sets an environment variable in the container named ACCEPT_EULA to the value Y.-name name_your_container: give your Docker container a friendly name, which is useful for stopping and starting containers from the Terminal.-d: this launches the container in daemon mode, so it runs in the background.You should now have SQL Server running on your Mac, ready for action! A few notes on Docker parameters docker run -d -name name_your_container -e 'ACCEPT_EULA=Y' -e -e 'MSSQL_PID=Developer' -p 1433:1433 microsoft/mssql-server-linux:2017-latest Now, launch an instance of the Docker image. docker pull microsoft/mssql-server-linux:2017-latest Open a Terminal window, and download the latest SQL Server for Linux Docker image. Next step, you'll need to increase Docker's available memory to 4GB or more. If you don't already have Docker installed, you'll need to download and install it. The answer (and an increasingly common answer, I might add) is Docker. My first question, of course: Can I run this on my Mac? The one that really got my attention was SQL Server for Linux. The 2016 Microsoft Connect() event included a lot of interesting announcements. This article has been updated to reflect changes in the latest General Availability (GA) release of SQL Server for Linux. Dogs and cats living together, mass hysteria!
