You'll cover the following topics in this Module:

0.0 Prerequisites

In this module you will learn the prerequisites for this workshop.

The workshop does not assume a deep working knowledge of SQL Server or OpenShift. You should know how to use a Linux bash shell. All commands are provided to run the activities.

In order to go through the activities of this workshop you will need the following:

• Access to an OpenShift 4 cluster
• A client computer that has access to connect to the OpenShift cluster with the following software installed and configured:
  • A Linux bash shell
  • The OpenShift CLI (oc.exe)
  • Azure Data Studio. Install from https://docs.microsoft.com/en-us/sql/azure-data-studio/download
  • SQL Command Line Tools (sqlcmd). Check the For Further Study section for links to install these tools.
  • git client (only needed if you do not have the latest version of the workshop provided to you by the instructor)
  • In addition, the client computer must be able to connect to the Internet to download a sample file or your instructor must provide it for you (WideWorldImporters-Full.bak)

The workshop currently supports a single node OpenShift cluster but can be run on a multiple cluster environment. For cluster administrators building a cluster for this workshop, each user will need ~8Gb of RAM to run the containers in the workshop.

The scripts will pull container images for SQL Server 2019 based on Red Hat Enterprise Linux 8.

Note: If you are attending this course in-person, the instructor may provide you with a client environment and full access to an OpenShift cluster including login credentials.

With the above environment configured, you can now proceed to the first Activity for the course.

Activity: Set up Workshop

Navigate to your home directory ~ and enter the following command:

git clone https://github.com/microsoft/sqlworkshops-sqlonopenshift.git

Note: If you have used git clone to pull down the repo of the workshops in the past, run git pull to get the latest version.

Login to your OpenShift cluster, via a web browser, using the URL provided to you for the openshiftConsoleUrl.

Note: You may get warnings from the web page saying "This site is not secure". Click Details or Advanced and then "Go on to the webpage" or "Proceed to ...".

You will be presented with a login screen:

Type in the user name and password provided to you for OpenShift cluster access

Note: In-class, your instructor may call this openshiftAdminUsername and openshiftPassword.

You will now see a new web page:

Get the Login command

In the upper right hand corner, click on your user name and select Copy Login Command

Your clipboard now holds a complete oc login syntax with a security token.

Use the token

Open up a shell and paste in the token you copied using the right-click of your mouse or SHIFT-INSERT. The command should look similar to the following:

oc login https://[masterconsoleaddress]:443 --token=[tokenstring]

Press the Enter key. If you are promoted for "Use insecure connections? (y/n)" type in y

You should see results similar to the following. You are then placed back at the command prompt:

Logged into "https://[masterconsoleurl]:443" as "ocpadmin" using the token provided. You have access to the following projects and can switch between them with 'oc project projectname': * default kube-public kube-service-catalog kube-system management-infra openshift openshift-ansible-service-broker openshift-console openshift-infra openshift-logging openshift-monitoring openshift-node openshift-sdn openshift-template-service-broker openshift-web-console Using project "default".

You have now successfully logged into the OpenShift Cluster and can proceed with Next Steps below.

For Further Study

• Red Hat OpenShift
• oc CLI downloads
• Azure Data Studio
• SQL Command Line Tools for Linux
• SQL Command Line Tools for MacOS
• SQL Command Line Tools for Windows

Next Steps

Next, Continue to Deploy SQL Server on OpenShift.