CentOS 7 安装 SqlServer2017 SqlServer2019 图形化操作界面

1.安装 Microsoft SQL Server 2019

# 下载 Microsoft SQL Server Red Hat 存储库配置文件
[root@192 ~]# sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo% Total    % Received % Xferd  Average Speed   Time    Time     Time  CurrentDload  Upload   Total   Spent    Left  Speed
100   231  100   231    0     0    662      0 --:--:-- --:--:-- --:--:--   663# 通过yum 安装 SQL Server
[root@192 lnmp1.6]# yum install -y mssql-server# 配置 Microsoft SQL Server
[root@192 ~]# sudo /opt/mssql/bin/mssql-conf setup
usermod: no changes
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) - CPU Core utilization restricted to 20 physical/40 hyperthreaded7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum8) 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=0x409Use 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):2Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409Use 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=0x409The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409Do you accept the license terms? [Yes/No]:YesEnter the SQL Server system administrator password: 
Confirm the SQL Server system administrator password: 
Configuring SQL Server...# 查看是否安装成功
[root@192 ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database EngineLoaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)Active: active (running) since Sun 2019-11-10 17:22:34 CST; 27s agoDocs: https://docs.microsoft.com/en-us/sql/linuxMain PID: 3476 (sqlservr)CGroup: /system.slice/mssql-server.service├─3476 /opt/mssql/bin/sqlservr└─3508 /opt/mssql/bin/sqlservrNov 10 17:22:39 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:39.49 spid23s     SQL Server is now ready for client connections. This is an informational message; no user a...is required.
Nov 10 17:22:39 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:39.57 spid12s     Clearing tempdb database.
Nov 10 17:22:39 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:39.58 spid10s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only....is required.
Nov 10 17:22:40 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:40.29 spid12s     [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
Nov 10 17:22:40 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:40.29 spid12s     Starting up database 'tempdb'.
Nov 10 17:22:41 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:41.19 spid12s     The tempdb database has 4 data file(s).
Nov 10 17:22:41 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:41.23 spid25s     The Service Broker endpoint is in disabled or stopped state.
Nov 10 17:22:41 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:41.24 spid25s     The Database Mirroring endpoint is in disabled or stopped state.
Nov 10 17:22:41 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:41.28 spid25s     Service Broker manager has started.
Nov 10 17:22:41 192.168.0.105 sqlservr[3476]: 2019-11-10 17:22:41.29 spid10s     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. 安装图形化数据库操作软件 Azure Data Studio

[root@192 ~]# cd /usr/local/src
[root@192 src]# wget https://azuredatastudiobuilds.blob.core.windows.net/releases/1.13.0/azuredatastudio-linux-1.13.0.tar.gz[root@192 src]# tar -xvf ./azuredatastudio-linux-1.13.0.tar.gz -C /usr/local
[root@192 src]# cd ../
[root@192 local]# echo 'export PATH="$PATH:/usr/local/azuredatastudio-linux-x64"' >> ~/.bashrc
[root@192 local]# source ~/.bashrc# 启动图形化数据库操作界面
[root@192 local]# azuredatastudio# 配置非root用户使用
[root@192 local]# exit
[gjp@192 local]# echo 'export PATH="$PATH:/usr/local/azuredatastudio-linux-x64"' >> ~/.bashrc
[gjp@192 local]# source ~/.bashrc# 此处需要安装 libXScrnSaver 依赖 否则会报找不到 libgtk-3.so.0
[root@192 local]# yum install libXScrnSaver# 注意 此处使用的是图形化安装的CentOS7
[gjp@192 local]# azuredatastudio# windows访问时记得关闭防火墙
[root@192 ~]# systemctl stop firewalld
[root@192 ~]# systemctl disable firewalld

3. CentOS7 使用Azure Data Studio连接  Microsoft SQL Server 2019 

4.2 Windows连接MSSQL 之 使用 原生 SSMS 连接(推荐使用)

因为之前有用Navicat进行过一次数据库远程备份,然后导致生产环境存储过程出现异常,然后后期果断换了官方的SSMS操作[捂脸笑][捂脸笑][捂脸笑]

4.2 Windows连接MSSQL 之 使用 Navicat连接

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！