#Centos安装配置SqlServer  
https://blog.csdn.net/weixin_43625238/article/details/141333125
 
#官方文档  
https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-linux-ver15&tabs=rhel8

#操作部分:

#下载SQL Server2019镜像  
curl https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo > /etc/yum.repos.d/mssql-server.repo

#安装SqlServer程序包    
yum install -y mssql-server  

#按照提示安装SqlServer  
/opt/mssql/bin/mssql-conf setup

#查看运行状态
systemctl status mssql-server

#开端口  
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent

sudo firewall-cmd --reload 



#安装mssql相关工具包（非必须）
#下载镜像
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

#安装
yum install -y mssql-tools unixODBC-devel

#添加环境变量
echo 'export PATH=$PATH:/opt/mssql-tools/bin' >> /etc/profile

#重新加载环境变量
source /etc/profile

#本地连接测试  
[root@hecs-166225 ~]# sqlcmd -S localhost -U sa -p
Password:
1>