在Rocky系统安装Mssql2017

最小安装Rocky之后已经具备了网络连接能力。

使用nmcli命令查看网络。

nmcli device status

使用nmtui配置网络。

nmtui

配置完成后，必须重启网络服务才能生效。

systemctl restart NetworkManager

安装MSSQL2017前准备

配置mssql源

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

安装MsSql2017之前，还要先安装python2。

yum -install -y python2 compat-openssl10
sudo alternatives --set python /usr/bin/python2

开始安装MSSQL2017

yum install -y mssql-server

或使用下面的命令进行本地安装。

sudo yum download mssql-server
sudo rpm -Uvh --nodeps mssql-server*rpm

安装后，配置MSSQL

sudo /opt/mssql/bin/mssql-conf setup

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

Enter the SQL Server system administrator password: 
Confirm the SQL Server system administrator password: 
Configuring SQL Server...

ForceFlush is enabled for this instance. 
ForceFlush feature is enabled for log durability.
Setup has completed successfully. SQL Server is now starting.

查看mssql的安装路径

[root@rocky ~]# find / -name mssql
/var/opt/mssql
/opt/mssql

查看mssql版本

[root@rocky ~]# rpm -qa |grep mssql
mssql-server-14.0.3421.10-2.x86_64

设置MSSQL开机启动

systemctl enable mssql-server

开启防火墙端口

firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --reload

控制命令

systemctl start mssql-server
systemctl restart mssql-server
systemctl stop mssql-server
systemctl status mssql-server

使用数据库

连接：使用Navicat等工具。

创建数据库：在Linux系列系统上要先创建/localdb目录，放置数据库的数据文件。

mkdir /localMSdb
chmod -R 777 /localMSdb

/**创建数据库 并且指定存储数据库的mdf和ldf文件**/
USE master
GO
CREATE DATABASE TestSQL ON PRIMARY
(
    NAME='TestSQL_data',--库文件逻辑文件名
    FILENAME='/localMSdb/TestSQL_data.mdf', --库文件文件名
    SIZE=5mb,--系统默认创建的时候会给库文件分配初始大小
    MAXSIZE=500MB,--库文件的最大值
    filegrowth=15%-- 库文件的增长幅度
)
LOG ON
(
    name='TestSQL_log',--日志文件逻辑文件名
    filename='/localMSdb/TestSQL_log.ldf',--日志文件文件名
    SIZE=5MB,--日志文件初始大小
    filegrowth=0 --启动自动增长
)
GO

配置环境变量

为方便本地管理SQL，安装SQL Server 命令行工具

1）下载Microsoft Red Hat 配置文件。

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

2）如果安装了早期版本的 mssql-tools，请删除所有旧的 unixODBC 包。

yum remove unixODBC-utf16 unixODBC-utf16-devel

3）使用 unixODBC 开发人员包安装 mssql-tools

yum install -y mssql-tools unixODBC-devel 

4）向 PATH 环境变量添加 /opt/mssql-tools/bin/ 。 这样可以在不指定完整路径的情况下运行这些工具。

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

测试本地连接:

sqlcmd -S localhost -U SA -P '<YourPassword>' 
#出现1>表示登陆成功