CentOS7.4脱机安装SQLServer2017

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 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 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 27 2017 08: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

当前文章：CentOS7.4脱机安装SQLServer2017
文章链接：http://www.shufengxianlan.com/qtweb/news12/476762.html

网站建设、网络推广公司-创新互联，是专注品牌与效果的网站制作，网络营销seo公司；服务项目有等

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联

猜你还喜欢下面的内容

网站改版知识

行业网站建设

成都免费建网站　　 　品牌网站建设　　 　南宁旺客科技　　 　网站建设　　 　成都木托盘　　 　租用服务器　　 　成都画册快印　　 　企业画册设计制作　　 　成都400电话　　 　做网站公司　　 　德信企业管理　　 　重庆建站　　 　成都企业网站定制　　 　微信小程序开发　　 　分类目录网站　　 　移动机房服务器托管　　 　成都定制网站　　 　手机APP开发　　 　seo优化排名　　 　传美奇电器