centos7安装sqlserver

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

wget -O /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

yum install -y mssql-server

/opt/mssql/bin/mssql-conf setup

systemctl status mssql-server

若果这时候报203则

cd /opt/mssql/bin/
chmod 777 sqlservr
这次权限分配完成，接着重新输入命令，再次安装
/opt/mssql/bin/mssql-conf setup
安装完成之后，再次检查SQL server的状态
systemctl status mssql-server

开放1433

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

firewall-cmd --reload

安装sqlserver命令行工具

下载微软官方的软件包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开发人员软件包（这一步命令会出现两次询问：是否接受许可条款，都输入yes，回车确定）

yum install -y mssql-tools unixODBC-devel

添加PATH环境变量

echo “export PATH=$PATH:/opt/mssql-tools/bin” >> /etc/profile

source /etc/profile

使用sqlcmd命令连接本地的sqlserver，输入之前设置的SA密码

sqlcmd -S localhost -U SA -p

有一次电脑异常关闭后，SqlServer启动不了了
提示： Unable to read instance id from /var/opt/mssql/.system/instance_id: 没有那个文件或目录 (2)
我们这样

 [root@node1 log]# cd /var
[root@node1 var]# cd opt
[root@node1 opt]# cd mssql/
[root@node1 mssql]# ls
data  log  mssql.conf  secrets
[root@node1 mssql]# ls -a
.  ..  data  log  mssql.conf  secrets  .system
[root@node1 mssql]# cd .system/
[root@node1 .system]# ls
instance_id  profiles  programdata  system
[root@node1 .system]# mv instance_id /var/opt/mssql/.system/instance_id.bak
[root@node1 .system]# ls
instance_id.bak  profiles  programdata  system
[root@node1 .system]# sudo systemctl restart mssql-server
[root@node1 .system]# sudo systemctl restart mssql-server
[root@node1 .system]# sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
   Active: active (running) since 一 2021-04-19 16:46:00 CST; 6s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 12701 (sqlservr)
    Tasks: 143
   Memory: 714.3M
   CGroup: /system.slice/mssql-server.service
           ├─12701 /opt/mssql/bin/sqlservr
           └─12703 /opt/mssql/bin/sqlservr