[TOC]
[TOC]
官方文档位于:
[sqlserver对centos7支持的官方文档](https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017 "sqlserver对centos7支持的官方文档")
# 1.设置yum安装源
```shell
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
```
# 2.安装Mssql server
```shell
sudo yum install -y mssql-server
```
![](https://oss.showapi.com/doc/12/22/d840514218594d29a321061815ea3bf9.png)
# 4.进行配置
```shell
/opt/mssql/bin/mssql-conf setup
```
![](https://oss.showapi.com/doc/12/22/b4ad145bf0ff4063a8673c919a392056.png)
> **注意上图中 :选择SQL版本 Dev版本(免费版)输入2**
# 5.查看版本和安装路径
```shell
systemctl status mssql-server
```
# 6.启动服务
```shell
systemctl start mssql-server
systemctl enable mssql-server
```
# 设置防火墙
```shell
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload
```
------------
安装命令行管理工具
# 1.安装本地客户端命令行工具
```shell
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
yum install -y mssql-tools
```
# 2,配置SqlCmd环境变量
```shell
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
```
# 3,连接数据库
```shell
sqlcmd -S localhost -U SA -P ''
```
# 4,创建数据库并查询
```shell
CREATE DATABASE DataTest;
GO
SELECT Name from sys.Databases;
GO
```
![](https://oss.showapi.com/doc/12/22/6518ba9fd166472b8049e7f35a54dbf9.png)
# 5.使用jdbc驱动即可连接
![](https://oss.showapi.com/doc/12/22/37e54dba707c4fddb996e20816620ec7.png)
修改启动端口
```shell
vi /var/opt/mssql/mssql.conf
```
修改图中数字即可。
![](https://oss.showapi.com/doc/12/22/a43e7b9a6d5d42ccaf8e7ecfefd7a8f6.png)
记得要重启sqlserver
```shell
systemctl restart mssql-server
```
本次实例使用的jdbc驱动为 sqljdbc_7.0.0.0_enu