Run Microsoft SQL Server Containerized in Docker

#SQLServer #Microsoft #Docker #Database

Full steps can be found at https://i12bretro.github.io/tutorials/0879.html

——————————————————————–
Installing Docker
——————————————————————–
   01. Log into the Linux host and run the following commands in a terminal window
         # install prerequisites
         sudo apt install apt-transport-https ca-certificates curl software-properties-common gnupg-agent -y
         # add docker gpg key
         curl -fsSL https://download.docker.com/linux/$(awk -F’=’ ‘/^ID=/{ print $NF }’ /etc/os-release)/gpg | sudo apt-key add –
         # add docker software repository
         sudo add-apt-repository “deb [arch=$(dpkg –print-architecture)] https://download.docker.com/linux/$(awk -F’=’ ‘/^ID=/{ print $NF }’ /etc/os-release) $(lsb_release -cs) stable”
         # install docker
         sudo apt install docker-ce docker-compose containerd.io -y
         # enable and start docker service
         sudo systemctl enable docker && sudo systemctl start docker
         # add the current user to the docker group
         sudo usermod -aG docker $USER
         # reauthenticate for the new group membership to take effect
         su – $USER
 
——————————————————————–
Running MS SQL Server Container
——————————————————————–
   01. Continue with the following commands in a terminal window
         # create working directory structure
         mkdir ~/docker/mssql -p
         # set owner of working directories
         sudo chown “$USER”:”$USER” ~/docker -R
         # allow the container to write to working directories
         sudo chmod a+rwx -R ~/docker/mssql
         # run the sql server docker container with persistent data
         docker run -d –name mssql -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=’Something$ecur3!’ -v ~/docker/mssql:/var/opt/mssql -p 1433:1433 –restart unless-stopped mcr.microsoft.com/mssql/server
   02. At this point the SQL Server instance is running and can be interacted with via the sqlcmd command line interface
         # connect to the database via sqlcmd
         # authenticate with the sa password set in the docker run command
         docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -U SA
         # output the SQL version
         select @@version;
         go
 
——————————————————————–
Installing SQL Server Management Studio (optional)
——————————————————————–
NOTE: SQL Server Management Studio (SSMS) is currently only available for Windows hosts
 
   01. Log into a Microsoft Windows host
   02. Download SQL Server Management Studio (SSMS)  https://aka.ms/ssmsfullsetup
   03. Navigate to the download directory and execute the downloaded SSMS Setup installer ≫ Click Install
   04. Once the installation completes, click Close
   05. Launch SSMS from the Start menu
   06. Complete the Connect to Server form with the following
         Server type: Database Engine
         Server name: ≪%Docker host DNS or IP%≫
         Authentication: SQL Server Authentication
         Login: sa
         Password: ≪%MSSQL_SA_PASSWORD%≫
 
Documentation:  https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-docker-container-deployment
 

### Connect with me and others ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro