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

相关推荐

  • 个人主题怎么制作？技术资讯

    个人主题怎么制作？

    制作个人主题是一个将个人风格、兴趣或专业领域转化为视觉化或结构化内容的过程，无论是用于个人博客、作品集、社交媒体账号还是品牌形象，核心都是围绕“个人特色”展开，以下从定位、内容规划、视觉设计、技术实现四个维度,详细拆解制作个人主题的完整流程，明确主题定位：找到个人特色的核心主题定位是所有工作的起点，需要先回答……

    运维的头像运维
    2025-11-20
    0
  • 社群营销管理关键是什么？技术资讯

    社群营销管理关键是什么？

    社群营销的核心在于通过建立有温度、有价值、有归属感的社群，实现用户留存、转化和品牌传播，其管理需贯穿“目标定位-内容运营-用户互动-数据驱动-风险控制”全流程,以下从五个维度展开详细说明：明确社群定位与目标社群管理的首要任务是精准定位，需明确社群的核心价值（如行业交流、产品使用指导、兴趣分享等）、目标用户画像……

    运维的头像运维
    2025-11-20
    0
  • 香港公司网站备案需要什么材料？技术资讯

    香港公司网站备案需要什么材料？

    香港公司进行网站备案是一个涉及多部门协调、流程相对严谨的过程，尤其需兼顾中国内地与香港两地的监管要求，由于香港公司注册地与中国内地不同，其网站若主要服务内地用户或使用内地服务器，需根据服务器位置、网站内容性质等，选择对应的备案路径（如工信部ICP备案或公安备案），以下从备案主体资格、流程步骤、材料准备、注意事项……

    运维的头像运维
    2025-11-20
    0
  • 如何企业上云推广技术资讯

    如何企业上云推广

    企业上云已成为数字化转型的核心战略,但推广过程中需结合行业特性、企业痛点与市场需求，构建系统性、多维度的推广体系，以下从市场定位、策略设计、执行落地及效果优化四个维度，详细拆解企业上云推广的实践路径，精准定位：明确目标企业与核心价值企业上云并非“一刀切”的方案，需先锁定目标客户群体，提炼差异化价值主张，客户分层……

    运维的头像运维
    2025-11-20
    0
  • PS设计搜索框的实用技巧有哪些？技术资讯

    PS设计搜索框的实用技巧有哪些？

    在PS中设计一个美观且功能性的搜索框需要结合创意构思、视觉设计和用户体验考量，以下从设计思路、制作步骤、细节优化及交互预览等方面详细说明，帮助打造符合需求的搜索框，设计前的规划明确使用场景：根据网站或APP的整体风格确定搜索框的调性，例如极简风适合细线条和纯色，科技感适合渐变和发光效果，电商类则可能需要突出搜索……

    运维的头像运维
    2025-11-20
    0

发表回复

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