MSSql Linux Container

Recently I was trying to follow a tutorial on EFCore that actively uses MSSql. I was using a Mac and hence decided to use Container.

Following are the steps I followed.

Ensure you have installed docker for mac. you can download it from here.

I am using the image : mssql-server-linux:2017-latest.

Now run the following docker command.

 docker run --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=1Secure*Password1' -e 'MSSQL_PID=Enterprise' -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest

Ensure that you are specifying a secure password that meets the SQL server criteria. I had issues in getting this instance up and running due to password criteria acceptance.

Now let us test our MSSql server by interacting with container OS.

docker exec -it sql_server_demo /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 1Secure*Password1

Now we should get the sqlcmd and try out following commands.

>CREATE DATABASE TestDB
>SELECT Name from sys.Databases  

The previous two commands were not executed immediately. You must type GO on a new line to execute the previous commands.

If everything goes well you should have an MSSql running in your Mac.

Enjoy coding… !