CentOS 上 SQL Server 配置指南
一 环境准备与版本选择
二 安装与初始化
sudo yum update -ysudo yum install -y wget openssl11-devel libaio libcurl libxml2-devel bzip2-devel libjpeg-turbo-devel freetype-devel libpng-develsudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.reposudo rpm --import https://packages.microsoft.com/keys/microsoft.ascsudo yum install -y mssql-serversudo /opt/mssql/bin/mssql-conf setup,按提示选择版本(如 Developer/Express)并设置 SA 强密码sudo systemctl start mssql-server && sudo systemctl enable mssql-server三 客户端工具与连通性
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.reposudo yum install -y mssql-tools unixODBC-develecho 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profileecho 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrcsource ~/.bashrcsqlcmd -S localhost -U SA -P 'YourStrongPassword'SELECT @@VERSION; GOsudo firewall-cmd --zone=public --add-port=1433/tcp --permanent && sudo firewall-cmd --reload四 常用配置与性能优化
USE master;EXEC sp_configure 'show advanced options', 1; RECONFIGURE;EXEC sp_configure 'Agent XPs', 1; RECONFIGURE;EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'max server memory (MB)', 16384; RECONFIGURE;sudo /opt/mssql/bin/mssql-conf get network.tcpportsudo /opt/mssql/bin/mssql-conf set network.tcpport 1433sudo /opt/mssql/bin/mssql-conf set tls ...(生产建议启用并配置有效证书)sudo /opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /data/mssql/datasudo /opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /data/mssql/logsudo systemctl restart mssql-server五 常见问题与排查
sudo systemctl status mssql-server(应为 active (running))sudo ss -lntp | grep 1433 或 sudo firewall-cmd --list-portssudo /opt/mssql/bin/mssql-conf set-sa-passwordsource ~/.bashrc