Installing Docker and SQL Server Management Studio 18

System Requirements

Docker

To install Docker, one of the following operating system requirements must be met;

Windows

• Windows 10, 64-bit operating system

  • Applies to Education, Enterprise, Home, and Pro distributions

  • Must be build 16299 or later

• Hyper-V

• 64-bit processor with Second Layer Address Translation

• Containers Windows feature must be enabled

• 4GB of system RAM

• BIOS-level hardware virtualization supported and enabled in the BIOS

For more information, please see the following link; https://docs.docker.com/docker-for- windows/install/

SQL Server SQL Server Management Studio 18

To install SQL Server SQL Server Management Studio 18, the following requirements must be met;

Windows 64-bit operating system

• Windows 7

• Windows 8 or 8.1

• Windows 10

1. 6GB of physical storage

2. 1GB of system RAM

For more information, please see the following link; https://docs.microsoft.com/en-us/sql/sql- server/install/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-ser ver15

Installing Docker

• Navigate to https://www.docker.com/products/docker-desktop

Open

• Select the appropriate operating system.

• On the bottom of the web browser, select the arrow to the right of the completed download. Select Open.

Open

• Ensure the following configurations have been selected. When prompted, select Ok.

• Allow the installer to unpack files.

• When prompted, select Close and Restart.

• Select the Docker icon on the desktop to ensure its successful installation.

Composing a .yml file and using PowerShell

• Create a new text file in the Documents folder.

• Open the New Text Document and insert the following code;

• On the upper left-hand corner, select Save as.

• Name the document docker-compose.yml in the Documents folder.

• Navigate to the Documents folder and ensure the file has saved correctly.

• In the Documents folder, press Shift on the keyboard and right-click simultaneously. Select

Open PowerShell window here.

• Ensure PS C:\Users\Username\Documents> appears in the PowerShell terminal.

• Input ls in the terminal. Press Enter. Ensure docker-compose.yml is present in the Documents folder.

• Input docker-compose up in the terminal. Press Enter.

• A pop-up may appear on the bottom right-hand side of the screen. If applicable, select Share it.

• The message, Recovery is complete. This message is an informational message only. No user action is required. will appear in the PowerShell terminal when completed.

• Open the Docker application.

• Locate the container on the main screen.

• Select the arrow to the left of the container name. The file mssql2019 will appear.

• Confirm the status of the container is Running.

• Close Docker and PowerShell.

Installing SQL Server Management Studio (SSMS)

• Navigate to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management- .

• Navigate to the Download SSMS section. Select Download SQL Server Management Studio (SSMS)

• On the bottom of the web browser, select the arrow to the right of the completed download. Select Open.

• When prompted, select Install.

• Allow the software to install.

• When completed, select Close.

Opening SQL Server Management Studio 18

In Windows Search, search SQL. Select Microsoft SQL Server Management Studio 18.

• The Connect to Server log-in information will appear.

• Change the log-in information to the following;

• Select Connect.

• The Object Explorer will be located on the left of the application.