Home > Storage > PowerFlex > White Papers > Container Storage Modules for Dell PowerFlex : Authorization Module > SQL Server YAML file
The following code shows a sample SQL Server container YAML file:
apiVersion: apps/v1
kind: Deployment
metadata:
name: mssql01
spec:
replicas: 1
selector:
matchLabels:
app: mssql01
template:
metadata:
labels:
app: mssql01
spec:
terminationGracePeriodSeconds: 30
hostname: mssql01
securityContext:
fsGroup: 10001
containers:
- name: mssql01
command:
- /bin/bash
- -c
- cp /var/opt/config/mssql.conf /var/opt/mssql/mssql.conf && /opt/mssql/bin/sqlservr
image: mcr.microsoft.com/mssql/rhel/server:2019-latest
resources:
limits:
memory: 32Gi
cpu: 16000m
ports:
- containerPort: 1433
env:
- name: MSSQL_PID
value: "Developer"
- name: ACCEPT_EULA
value: "Y"
- name: SA_PASSWORD
valueFrom:
secretKeyRef:
name: mssql
key: MSSQL_SA_PASSWORD
volumeMounts:
- name: mssqldb
mountPath: /var/opt/mssql/data
- name: mssqllogs
mountPath: /var/opt/mssqlogs/logs
- name: mssql-config-volume
mountPath: /var/opt/config
- name: mssqltemp
mountPath: /var/opt/mssqltemp/tempdb
volumes:
- name: mssqldb
persistentVolumeClaim:
claimName: data-sql01
- name: mssqllogs
persistentVolumeClaim:
claimName: data-logs01
- name: mssqltemp
persistentVolumeClaim:
claimName: data-temp01
- name: mssql-config-volume
configMap:
name: config-mssql
---
apiVersion: v1
kind: Service
metadata:
name: mssql01
spec:
selector:
app: mssql01
ports:
- protocol: TCP
port: 1433
targetPort: 1433
nodePort: 30011
type: NodePort