麒麟V10部署 SQL Server 2022

温馨提醒

下载安装包

https://packages.microsoft.com/rhel/8/mssql-server-2022/

安装

1
dnf localinstall mssql-server-16.0.4230.2-7.x86_64.rpm -y

初始化 sqlserver

/opt/mssql/bin/mssql-conf setup

image-20260121130224046

查看服务状态

image-20260121130243179

命令行工具

  • 安装命令行工具

    1
    
    wget https://packages.microsoft.com/rhel/8/prod/Packages/m/mssql-tools18-18.6.1.1-1.x86_64.rpm
    1
    
    wget https://packages.microsoft.com/rhel/8/prod/Packages/m/msodbcsql18-18.6.1.1-1.x86_64.rpm
    1
    
    wget https://packages.microsoft.com/rhel/8/prod/Packages/u/unixODBC-devel-2.3.7-1.rh.x86_64.rpm

    dnf localinstall *.rpm

  • 配置环境变量

    1
    2
    3
    
    cat > /etc/profile.d/mssql.sh <<'EOF'
    export PATH="$PATH:/opt/mssql-tools18/bin"
    EOF

    source /etc/profile.d/mssql.sh

连接 sqlserver 数据库

image-20260121132205479