MS Sql Server安装部署

环境要求

内存大于 2G

windows环境安装

1. 官网下载Developer版

2. 具体安装指导可查看该链接：

https://zhuanlan.zhihu.com/p/376812785
本地连接sql server注意点：
● 开启sql server远程连接，开启tcp协议
● 设置开启防火墙开启端口协议的连接
● 使用SSMS连接

linux环境安装

1. 确保Linux环境正常运行（部署验证环境：centos8）

2. 设置下载镜像源：

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

3.安装

yum install -y mssql-server

4. 配置

sudo /opt/mssql/bin/mssql-conf setup

执行后选择2 免费版 ，输入 yes确认
设置SA的密码
● 查看打印日志
显示SQL Server is now starting
● 查看当前sql server的启动状态

 systemctl status mssql-server

● 设置防火墙，开启远程连接

firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --reload

5. 连接

● 安装yum 源

wget -O  /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

● 若之前安装过mssql ，删除老的UnixODBC软件包

yum remove unixODBC-utf16 unixODBC-utf16-devel

● 安装mssql工具包和unixODBC开发人员软件包

yum install -y mssql-tools unixODBC-devel

● 添加PATH环境变量

yum install -y mssql-tools unixODBC-devel

● 使用sqlcmd连接，登录后使用相关数据库的命令

sqlcmd -S localhost -U SA -p
CREATE DATABASE [Test]
GO

Kuboard 安装（Docker）

---
apiVersion: apps/v1
kind: StatefulSet
metadata:
  annotations: {}
  labels:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: mssql
  name: mssql
  namespace: default
  resourceVersion: '588992'
spec:
  podManagementPolicy: OrderedReady
  replicas: 1
  revisionHistoryLimit: 10
  selector:
    matchLabels:
      k8s.kuboard.cn/layer: db
      k8s.kuboard.cn/name: mssql
  serviceName: mssql
  template:
    metadata:
      annotations:
        kubectl.kubernetes.io/restartedAt: '2022-11-02T10:17:55+08:00'
      creationTimestamp: null
      labels:
        k8s.kuboard.cn/layer: db
        k8s.kuboard.cn/name: mssql
    spec:
      containers:
        - env:
            - name: SA_PASSWORD
              value: Huazh2022
            - name: ACCEPT_EULA
              value: 'Y'
          image: 'mcr.microsoft.com/mssql/server:latest'
          imagePullPolicy: IfNotPresent
          name: mssql
          resources: {}
          terminationMessagePath: /dev/termination-log
          terminationMessagePolicy: File
          volumeMounts:
            - mountPath: /var/opt/mssql
              name: volume-ix6n7
      dnsPolicy: ClusterFirst
      restartPolicy: Always
      schedulerName: default-scheduler
      securityContext: {}
      terminationGracePeriodSeconds: 30
      volumes:
        - hostPath:
            path: sqldata
            type: DirectoryOrCreate
          name: volume-ix6n7
  updateStrategy:
    rollingUpdate:
      partition: 0
    type: RollingUpdate
status:
  availableReplicas: 1
  collisionCount: 0
  currentReplicas: 1
  currentRevision: mssql-74c5b4b89c
  observedGeneration: 3
  readyReplicas: 1
  replicas: 1
  updateRevision: mssql-74c5b4b89c
  updatedReplicas: 1

---
apiVersion: v1
kind: Service
metadata:
  annotations: {}
  labels:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: mssql
  name: mssql
  namespace: default
  resourceVersion: '2181'
spec:
  clusterIP: 10.43.19.204
  clusterIPs:
    - 10.43.19.204
  externalTrafficPolicy: Cluster
  internalTrafficPolicy: Cluster
  ipFamilies:
    - IPv4
  ipFamilyPolicy: SingleStack
  ports:
    - name: nsq6ab
      nodePort: 32049
      port: 1433
      protocol: TCP
      targetPort: 1433
  selector:
    k8s.kuboard.cn/layer: db
    k8s.kuboard.cn/name: mssql
  sessionAffinity: None
  type: NodePort
status:
  loadBalancer: {}