Run Microsoft SQL Server Containerized in Docker

Опубликовано: 20 Март 2023
на канале: i12bretro

6,471

#SQLServer #Microsoft #Docker #Database

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

--------------------------------------------------------------------
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...

Connect with me and others ###
★ Discord:   / discord
★ Reddit:   / i12bretro
★ Twitter:   / i12bretro

На этой странице сайта вы можете посмотреть видео онлайн Run Microsoft SQL Server Containerized in Docker длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь i12bretro 20 Март 2023, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 6,471 раз и оно понравилось 47 зрителям. Приятного просмотра!

141