1. 树叶云首页
  2. 技术资讯

CentOS7.4脱机安装SQL Server 2017

管理••技术资讯

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

1. 环境

Linux: CentOS Linux release 7.4.1708 (Core) Memory: 4 GB SQL 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 https://packages.microsoft.com/rhel/7/mssql-server/mssql-server-14.0.900.75-1.x86_64.rpm

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]:
y

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                                                                                                                                     

Complete!

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:

https://go.microsoft.com/fwlink/?LinkId=852741&clcid=0x409

The privacy statement can be viewed at:

https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409

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

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

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-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 Database Engine

  Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)

  Active:
active (running) since Thu 2017-12-14 18:25:03 CST; 1min 23s ago

    Docs: https://docs.microsoft.com/en-us/sql/linux

 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 <ipv6> 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 <ipv4> 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 database ‘tempdb’.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.61 spid9s      The tempdb database has 1 data file(s).

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.61 spid20s    The Service Broker endpoint is in disabled or stopped state.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.62 spid20s    The Database Mirroring endpoint is in disabled or stopped state.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.62 spid20s    Service Broker manager has started.

Dec 14 18:25:10 linuxidc sqlservr[56504]: 2017-12-14 18:25:10.63 spid6s      Recovery is complete. This is an informational message only. No user action is required.

Hint: Some lines were ellipsized, use -l to show in full.

2.5 停止、启动或重启 SQL Server 服务

systemctl stop mssql-server

systemctl start mssql-server

systemctl restart mssql-server

2.6 日志文件

/var/opt/mssql/log/errorlog

3. 安装 sqlcmd 和 bcp SQL Server 命令行工具

3.1 下载

wget https://packages.microsoft.com/rhel/7.3/prod/msodbcsql-13.1.6.0-1.x86_64.rpm

wget https://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

Password:

1> select name from sys.databases;

2> go

name                                                                                                                           

——————————————————————————————————————————–

master                                                                                                                         

tempdb                                                                                                                         

model                                                                                                                           

msdb                                                                                                                                                                                                                                           

(5 rows affected)

1>

1>create database TestDB;

2>go

1>

1> use TestDB;

2> go

Changed database context to ‘TestDB’.

1> create table t1 (id int, cname nvarchar(50))

2> go

1>

1> insert into t1 (id, cname) values (1,’abc’);

2> go

(1 rows affected)

1> select * from t1;

2> go

id          cname                                             

———– ————————————————–

          1 abc                                               

(1 rows affected)

1>

3.5 退出

1> quit

4. 安装SQL Server Agent

4.1 下载

wget https://packages.microsoft.com/rhel/7/mssql-server/mssql-server-agent-14.0.900.75-1.x86_64.rpm

4.2 安装

[root@linuxidc /opt/sqlserver2017]#
yum localinstall mssql-server-agent-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-agent-14.0.900.75-1.x86_64.rpm: mssql-server-agent-14.0.900.75-1.x86_64

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

Resolving Dependencies

–> Running transaction check

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

–> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================================================

 Package                                Arch                      Version                              Repository                                                    Size

===========================================================================================================================================================================

Installing:

 mssql-server-agent                    x86_64                    14.0.900.75-1                        /mssql-server-agent-14.0.900.75-1.x86_64                    8.9 M

Transaction Summary

===========================================================================================================================================================================

Install  1 Package

Total size: 8.9 M

Installed size: 8.9 M

Is this ok [y/d/N]:
y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

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

+——————————————————————————–+

Please restart mssql-server to enable Microsoft SQL Server Agent.

+——————————————————————————–+

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

Installed:

  mssql-server-agent.x86_64 0:14.0.900.75-1                                                                                                                               

Complete!

5. 在Windows上使用SSMS连接数据库

Figure-1：SSMS连接Linux下的数据库

Figure-2：查询版本信息

SELECT@@VERSION;
GO
Microsoft SQL Server 2017 (RC2) -14.0.900.75 (X64)
    Jul 27201708:53:49
    Copyright (C) 2017 Microsoft Corporation
    Developer Edition (64-bit) on Linux (CentOS Linux 7 (Core))

 

Figure-3：查询数据

发现Red Gate部分功能不能使用。rpm包安装无法指定安装目录。 

6. 参考

https://www.microsoft.com/en-us/sql-server/sql-server-2017

https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat

https://packages.microsoft.com/rhel/7/mssql-server/

https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-troubleshooting-guide

文章来源网络，作者：管理，如若转载，请注明出处：https://shuyeidc.com/wp/221698.html<

赞 (0)
管理的头像管理
00
上一篇2025-04-15 03:55
下一篇 2025-04-15 03:57

相关推荐

  • 云服务器和云虚拟主机怎么选？云服务器和虚拟主机区别技术资讯

    云服务器和云虚拟主机怎么选？云服务器和虚拟主机区别

    云服务器适合业务增长快、需弹性扩展的场景，而云虚拟主机适合预算有限、技术门槛低的小型静态网站或测试环境，二者核心区别在于资源独享性与运维复杂度，核心差异解析：从底层架构到使用体验很多人容易混淆这两者，觉得它们都是“买空间建站”，它们的底层逻辑完全不同，云服务器（ECS）就像是你租了一整栋别墅，水电网络独立，你想……

    管理的头像管理
    2026-06-29
    0
  • 赣州智慧旅游招聘是真的吗？赣州旅游人才招聘信息技术资讯

    赣州智慧旅游招聘是真的吗？赣州旅游人才招聘信息

    中级岗位（3-5年经验）月薪范围通常在6000-10000元，这类岗位需要独立负责项目模块，如独立运营一个抖音账号，或维护一个景区小程序的功能迭代,具备成功案例的候选人议价能力较强，高级岗位（5年以上经验）月薪范围通常在10000-20000元，部分核心管理岗可达更高，这类人才需要具备战略规划能力，如制定整个景……

    管理的头像管理
    2026-06-29
    0
  • 赣州智能物联网车位锁如何管理？智能车位锁管理系统多少钱技术资讯

    赣州智能物联网车位锁如何管理？智能车位锁管理系统多少钱

    赣州智能物联网车位锁管理的核心在于通过云端平台实现远程控锁、状态实时监控及自动计费，彻底解决传统车位“被占难管”与“找位难”的痛点，在赣州这样的城市,随着机动车保有量的持续增长，老旧小区、商业综合体以及私人固定车位的资源矛盾日益凸显，传统的机械地锁或简易遥控锁，不仅操作繁琐，更无法实现数据化管理，引入智能物联网……

    管理的头像管理
    2026-06-29
    0
  • 赣州智能消防栓好用吗，智能消防栓多少钱一个技术资讯

    赣州智能消防栓好用吗，智能消防栓多少钱一个

    赣州智能消防栓通过物联网技术实现实时监测与远程报警，能显著降低火灾响应时间并提升城市消防安全管理水平，是目前智慧城市建设中不可或缺的基础设施，赣州智能消防栓的核心价值与应用场景传统消防栓往往存在“看不见、摸不着、用不了”的痛点，在赣州这样地形复杂、老城区与新城区并存的区域，传统设施的管理难度极大，智能消防栓的出……

    管理的头像管理
    2026-06-29
    0
  • 云服务器和物理机到底有啥区别？技术资讯

    云服务器和物理机到底有啥区别？

    云服务器本质上是虚拟化资源池中的弹性实例，而传统物理服务器是独占的硬件实体，前者胜在弹性与运维便捷，后者强在物理隔离与性能稳定，具体选择取决于业务对成本、扩展性及安全合规的权衡，很多人初次接触服务器时,容易把“云服务器”和“传统物理服务器”混为一谈，觉得它们都是用来跑网站或存数据的盒子，这两者的底层逻辑完全不同……

    管理的头像管理
    2026-06-29
    0

发表回复

您的邮箱地址不会被公开。必填项已用 * 标注