操作系统:centos7.5 x64
mssql-server:2017
内存要求:3G及以上
一、服务端mssql-server安装
1、首先下载yum源
curl https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo > /etc/yum.repos.d/mssql-server.repo
2、yum安装mssql-server
yum install mssql-server
3、查看是否安装成功
rpm -qa | grep mssql-server
![78d3dcb8ac21e654a27f5035e9a4d267.png](https://img-blog.csdnimg.cn/img_convert/78d3dcb8ac21e654a27f5035e9a4d267.png)
4、初始化设置(默认安装至:/opt/mssql)
cd /opt/mssql/bin
![aafb5af9923fec3e31e3ee54a0db671e.png](https://img-blog.csdnimg.cn/img_convert/aafb5af9923fec3e31e3ee54a0db671e.png)
执行配置命令:
./mssql-conf setup
![0034e25a19435de949fb6c437b7b1d0f.png](https://img-blog.csdnimg.cn/img_convert/0034e25a19435de949fb6c437b7b1d0f.png)
此处我们选择开发者模式,免费
![6450a7d724e09b5be2d54c384fbeab7d.png](https://img-blog.csdnimg.cn/img_convert/6450a7d724e09b5be2d54c384fbeab7d.png)
设置管理员密码,看到最后一行successfully,证明配置成功,默认帐号是 sa
然后查看服务是否正常启动:systemctl status mssql-server
![fda863dd417c2d86d53e2493e2e8ee55.png](https://img-blog.csdnimg.cn/img_convert/fda863dd417c2d86d53e2493e2e8ee55.png)
以上就完成了服务端的配置
二、客户端sqlcmd安装
1、配置yum源
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
2、yum 安装sql-tool
yum install -y mssql-tools
3、配置环境变量
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
4、使用客户端sqlcmd登录数据库
sqlcmd -S localhost -U SA
![f639d2b58781ea0415885021f821150d.png](https://img-blog.csdnimg.cn/img_convert/f639d2b58781ea0415885021f821150d.png)
常见问题:
启动失败
![efbdcb9a14760b39b0427afade0c87ff.png](https://img-blog.csdnimg.cn/img_convert/efbdcb9a14760b39b0427afade0c87ff.png)
由于通过systemctl status 查看的日志信息较少,可以通过使用命令启动查看详细日志
![4cf644d4292afc6fa399a7f2921f45c2.png](https://img-blog.csdnimg.cn/img_convert/4cf644d4292afc6fa399a7f2921f45c2.png)
[root@master bin]# ./sqlservr startsqlservr: This program requires a machine with at least 2000 megabytes of memory../sqlservr: This program requires a machine with at least 2000 megabytes of memory
此处由于内存不足导致启动失败,加大内存即可!