Skip to main content

Posts

Showing posts from August, 2020

How to install MSSQL in Mac using Docker?

MSSQL refers to Microsoft SQL which is more compatible with windows machines. What if we want it in our macbook. Well we do that using docker.  You should follow following steps in order to install MS SQL Server in your macbook. Download and install Docker. { docker download } Open terminal Enter following command. This command will install microsoft sql server in your mac --> docker pull microsoft/mssql-server-linux Now set up the server name and password for your sql server using following command in terminal. --> docker run -d --name your_sql_server_name -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=SetYourPassword123' -p 1433:1433 microsoft/mssql-server-linux Note that the password should contain capital letter, small letter and number, otherwise you will face the popular problem that your sql server automatically shuts down after few seconds of start. You may want to install sql cli that allows you to type sql commands in terminal. For that command is:  --> sudo npm