Posts

Showing posts from February, 2021

How to run MSSQL in Linux

If you are a Microsoft fan or your company is relying on Microsoft technologies, in most of the cases, the database in use will be MSSQL. But if you want try out the things in a Linux based system like Redhat or Ubuntu it is convenient to run an MSSQL instance in the local machine itself. With docker we have a faster and feasible solution. Here I will share the relevant commands and instructions to get started right away. 1. Pull the docker image docker pull mcr.microsoft.com/mssql/server   This will download the latest mssql server tag. 2. To start the container docker run --name MSSQLLatest -d -p 1433:1433 -e "SA_PASSWORD= <StrongPassword>" -e "ACCEPT_EULA=Y" mcr.microsoft.com/mssql/server   These command options are case sensitive. We have mapped default port 1433 to itself of the host machine. You can choose another if that port is occupied. Choose a password of your own in place of '<StrongPassword>'. 3. To start and stop the MSSQL server y