Run Microsoft SQL Server Containerized in Docker
#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
Auf dieser Seite können Sie das Online-Video Run Microsoft SQL Server Containerized in Docker mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer i12bretro 20 März 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 6,407 Mal angesehen und es wurde von 47 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
