SQL-server安装

仅为记录自己SQLserver 安装过程

---------------------------------------------------

安装SQLserver

1.环境准备

Centos7.4虚拟机，内存2G

习惯性卸载firewalld，关闭selinux

2.配置SQLserver安装源

curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

3.安装SQLserver

yum -y install mssql-server

4.执行初始化设置

/opt/mssql/bin/mssql-conf setup

选择安装版本，设置语言，配置管理员密码

如果出现如下报错，请设置内存大小。

sqlservr: Thisystemctl status mssql-servers program requires a machine with at least 2000 megabytes of memory.

5.验证服务是否运行

systemctl status mssql-server

netstat -anptu | grep mssql

安装SQLserver命令行工具

1.配置安装源

curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

2.安装mssql工具

yum install -y mssql-tools unixODBC-devel

3.添加环境变量

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

source ~/.bashrc

4.测试连接

sqlcmd -S 127.0.0.1 -U SA -P'password'