Server-CentOS7.4脱机安装SQL-2017 (server是什么意思)

SQL Server on Linux也发布一段时间了，官方上支持Red Hat, SUSE, Ubuntu。手上没有以上Linux版本，选用了与Red Hat最接近的Centos7.4来进行安装和测试。

1. 环境

Linux: CentOS Linux release 7.4.1708 (Core)Memory: 4 GBSQL Server: SQL Server 2017 (RC2) – 14.0.900.75 (X64)

2. 安装mssql-server

2.1 下载rpm包

[root@linuxidc /opt]# mkdir -p /opt/sqlserver2017

[root@linuxidc /opt]# cd /opt/sqlserver2017/

[root@linuxidc /opt]# wget

2.2 yum安装

[root@linuxidc /opt/sqlserver2017]# yum localinstall mssql-server-14.0.900.75-1.x86_64.rpm Loaded plugins: fastestmirror, langpacks

Repository base is listed more than once in the configuration

Repository updates is listed more than once in the configuration

Repository extras is listed more than once in the configuration

Repository centosplus is listed more than once in the configuration

Examining mssql-server-14.0.900.75-1.x86_64.rpm: mssql-server-14.0.900.75-1.x86_64

Marking mssql-server-14.0.900.75-1.x86_64.rpm to be installed

Resolving Dependencies

–> Running transaction check

—> Package mssql-server.x86_64 0:14.0.900.75-1 will be installed

–> Finished Dependency Resolution

Dependencies Resolved

Package Arch Version Repository Size

Installing:

mssql-server x86_64 14.0.900.75-1 /mssql-server-14.0.900.75-1.x86_64 870 M

Transaction Summary

Install 1 Package

Total size: 870 M

Installed size: 870 M

Is this ok [y/d/N]:

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : mssql-server-14.0.900.75-1.x86_64 1/1

Please run ‘sudo /opt/mssql/bin/mssql-conf setup’

to complete the setup of Microsoft SQL Server

Verifying : mssql-server-14.0.900.75-1.x86_64 1/1

Installed:

mssql-server.x86_64 0:14.0.900.75-1

2.3 配置

[root@linuxidc /opt/mssql/bin]# /opt/mssql/bin/mssql-conf setup

The license terms for this product can be found in

/usr/share/doc/mssql-server or downloaded from:

The privacy statement can be viewed at:

Do you accept the license terms? [Yes/No]:

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) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at

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-7): 2

Enter the SQL Server system administrator password:

Confirm the SQL Server system administrator password:

Configuring SQL Server…

This is an evaluation version. There are [40] days LEFT in the evaluation period.

Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service.

Setup has completed successfully. SQL Server is now starting.注意评估版本有使用期限。

2.4 验证服务

[root@linuxidc /opt/mssql/bin]# systemctl status mssql-server

● mssql-server.service – Microsoft SQL Server>active (running)since Thu 2017-12-14 18:25:03 CST; 1min 23s ago

Docs:

Main PID: 56504 (sqlservr)

CGroup: /system.slice/mssql-server.service

├─56504 /opt/mssql/bin/sqlservr

└─56525 /opt/mssql/bin/sqlservr

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.36 Server Server is listening on [ ::1 1434].

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.37 Server Server is listening on [ 127.0.0.1 1434].

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.37 Server Dedicated admin connection support was established for listening locally on port 1434.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.38 spid19s SQL Server is now ready for client connections. This is an informational message; … required.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.42 spid9s Starting up>3. 安装 sqlcmd 和 bcp SQL Server 命令行工具

3.1 下载

wgetHTTPs://packages.microsoft.com/rhel/7.3/prod/mssql-tools-14.0.5.0-1.x86_64.rpm

3.2 安装

yum localinstall msodbcsql-13.1.6.0-1.x86_64.rpm

yum localinstall mssql-tools-14.0.5.0-1.x86_64.rpm

3.3 添加到环境变量

[root@linuxidc /opt]# echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bash_profile

[root@linuxidc /opt]# source ~/.bash_profile

[root@linuxidc /opt]# echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bashrc

[root@linuxidc /opt]# source ~/.bashrc

3.4 本地连接

[root@linuxidc /opt/mssql/bin]# sqlcmd -S localhost -U sa

1> select name from sys.databases;

(5 rows affected)

1>create>3.5 退出

4. 安装SQL Server Agent

4.1 下载

wget安装

[root@linuxidc /opt/sqlserver2017]# yum localinstall mssql-server-agent-14.0.900.75-1.x86_64.rpm

 (RC2) .::)  Linux (CentOS Linux  (Core))