CentOS7上离线安装SQL Server

先下载安装包

点击下载安装包

安装包目录下运行此命令进行安装

yum install mssql-server-15.0.4023.6-2.x86_64.rpm

修改默认数据和日志目录位置

mkdir /data/mssqlserver/data -p
chown mssql /data/mssqlserver/data
chgrp mssql /data/mssqlserver/data
/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /data/mssqlserver/data

修改默认备份目录位置

mkdir /data/mssqlserver/backup -p
chown mssql /data/mssqlserver/backup
chgrp mssql /data/mssqlserver/backup
/opt/mssql/bin/mssql-conf set filelocation.defaultbackupdir /data/mssqlserver/backup

设置目录权限

chmod -v 777 /opt/mssql

mssql服务自启动

/opt/mssql/bin/mssql-conf setup
systemctl restart mssql-server.service

• sql 2019激活码

查看mssql服务状态

systemctl status mssql-server

防火墙开启1443端口

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

修改默认的DUMP目录位置

mkdir /data/mssqlserver/dump -p
chown mssql /data/mssqlserver/dump
chgrp mssql /data/mssqlserver/dump
/opt/mssql/bin/mssql-conf set filelocation.defaultdumpdir /data/mssqlserver/dump

修改默认错误日志目录位置

mkdir /data/mssqlserver/logs -p
chown mssql /data/mssqlserver/logs
chgrp mssql /data/mssqlserver/logs
/opt/mssql/bin/mssql-conf set filelocation.errorlogfile /data/mssqlserver/logs/errorlog