MSSQL Server on APPUiO¶
This example shows how to deploy the mssql linux docker image to APPUiO. For demo purposes only and we use the evaluation version.
Quick Summary¶
The basic deployment and configuration of a mssql database container is done by the following commands
oc new-app microsoft/mssql-server-linux --name=mssql-server-linux
oc env dc mssql-server-linux -e ACCEPT_EULA=Y -e SA_PASSWORD=somerandom.Pa55word
oc volume dc/mssql-server-linux --add --name=mssql-data --mount-path=/var/opt/mssql
In Detail¶
Deploy the mssql docker container
oc new-app microsoft/mssql-server-linux --name=mssql-server-linux
Configuration¶
To run this image you need to read and accept the End-User License Agreement and if accepted set the
environment variable ACCEPT_EULA
to Y
You also need to define a secure SA password
oc env dc mssql-server-linux -e ACCEPT_EULA=Y -e SA_PASSWORD=somerandom.Pa55word
You might want to adjust the resource limits.
Persistent Storage¶
You should also add a persistent volume and mount under /var/opt/mssql
Empty Dir for Test only
oc volume dc/mssql-server-linux --add --name=mssql-data --mount-path=/var/opt/mssql
Persistent Storage
oc volume dc/mssql-server-linux --add --name=mssql-data --type persistentVolumeClaim \
--claim-name=mssql-data --claim-size=256Mi --mount-path=/var/opt/mssql
Create Database¶
To connect to the database directly from your system you must create a port
forward into the container oc port-forward [POD] 1433:1433
Create a new database connection in your desired client (eg. squirelsql) using user sa and the given password. Execute the following commands to create the database
create database databasename;
GO
use databasename;
CREATE LOGIN dbuser WITH PASSWORD = 'dbuserPW', CHECK_POLICY = OFF;
CREATE USER [dbuser] FROM LOGIN [dbuser];
exec sp_addrolemember 'db_owner', 'databasename';
GO
Delete MSSQL¶
oc delete all -l app=mssql-server-linux -n [yourproject]