Install Microsoft SQL Server 2019 Express on Centos 8
[root@thermalite ~]# sudo curl https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo -o /etc/yum.repos.d/mssql-server-2019.repo
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 231 100 231 0 0 639 0 --:--:-- --:--:-- --:--:-- 638
[root@thermalite ~]# sudo curl https://packages.microsoft.com/config/rhel/8/prod.repo -o /etc/yum.repos.d/msprod.repo
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 192 100 192 0 0 611 0 --:--:-- --:--:-- --:--:-- 609
[root@thermalite ~]# sudo dnf -y install mssql-server
Repository packages-microsoft-com-prod is listed more than once in the configuration
Repository packages-microsoft-com-prod is listed more than once in the configuration
packages-microsoft-com-mssql-server-2019 3.0 MB/s | 4.0 MB 00:01
Last metadata expiration check: 0:00:02 ago on Sat 12 Jun 2021 12:28:51 PM EDT.
Dependencies resolved.
=================================================================================================================================================================================================================
Package Architecture Version Repository Size
=================================================================================================================================================================================================================
Installing:
mssql-server x86_64 15.0.4138.2-1 packages-microsoft-com-mssql-server-2019 232 M
Installing dependencies:
cyrus-sasl x86_64 2.1.27-5.el8 baseos 96 k
Transaction Summary
=================================================================================================================================================================================================================
Install 2 Packages
Total download size: 232 M
Installed size: 1.1 G
Downloading Packages:
(1/2): cyrus-sasl-2.1.27-5.el8.x86_64.rpm 160 kB/s | 96 kB 00:00
(2/2): mssql-server-15.0.4138.2-1.x86_64.rpm 9.0 MB/s | 232 MB 00:25
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 8.9 MB/s | 232 MB 00:25
warning: /var/cache/dnf/packages-microsoft-com-mssql-server-2019-e6d048b9178d6297/packages/mssql-server-15.0.4138.2-1.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY
packages-microsoft-com-mssql-server-2019 2.9 kB/s | 983 B 00:00
Importing GPG key 0xBE1229CF:
Userid : "Microsoft (Release signing) "
Fingerprint: BC52 8686 B50D 79E3 39D3 721C EB3E 94AD BE12 29CF
From : https://packages.microsoft.com/keys/microsoft.asc
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: cyrus-sasl-2.1.27-5.el8.x86_64 1/2
Installing : cyrus-sasl-2.1.27-5.el8.x86_64 1/2
Running scriptlet: cyrus-sasl-2.1.27-5.el8.x86_64 1/2
Running scriptlet: mssql-server-15.0.4138.2-1.x86_64 2/2
Installing : mssql-server-15.0.4138.2-1.x86_64 2/2
Running scriptlet: mssql-server-15.0.4138.2-1.x86_64 2/2
+--------------------------------------------------------------+
Please run 'sudo /opt/mssql/bin/mssql-conf setup'
to complete the setup of Microsoft SQL Server
+--------------------------------------------------------------+
Verifying : cyrus-sasl-2.1.27-5.el8.x86_64 1/2
Verifying : mssql-server-15.0.4138.2-1.x86_64 2/2
Installed:
cyrus-sasl-2.1.27-5.el8.x86_64 mssql-server-15.0.4138.2-1.x86_64
Complete!
[root@thermalite ~]#
[root@thermalite ~]# rpm -qi mssql-server
Name : mssql-server
Version : 15.0.4138.2
Release : 1
Architecture: x86_64
Install Date: Sat 12 Jun 2021 12:29:49 PM EDT
Group : Unspecified
Size : 1162993815
License : Commercial
Signature : RSA/SHA256, Sat 29 May 2021 05:51:25 AM EDT, Key ID eb3e94adbe1229cf
Source RPM : mssql-server-15.0.4138.2-1.src.rpm
Build Date : Sat 29 May 2021 03:54:07 AM EDT
Build Host : hls-rhel8-1-prod-build-rhel8-03
Relocations : (not relocatable)
Summary : Microsoft SQL Server Relational Database Engine
Description :
The mssql-server package contains the Microsoft SQL Server Relational Database Engine.
[root@thermalite ~]# /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 hyperthreaded
7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum
8) 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=2109348&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-8): 3
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=2104294&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
Enter the SQL Server system administrator password: my_msql_server_pass
The licensing PID was successfully processed. The new edition is [Express Edition].
ForceFlush is enabled for this instance.
ForceFlush feature is enabled for log durability.
Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.
[root@thermalite ~]# systemctl status mssql-server.service
● 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 Sat 2021-06-12 12:48:29 EDT; 1min 11s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 1433420 (sqlservr)
Tasks: 149
Memory: 661.0M
CGroup: /system.slice/mssql-server.service
├─1433420 /opt/mssql/bin/sqlservr
└─1433443 /opt/mssql/bin/sqlservr
Jun 12 12:48:32 thermalite.localdomain sqlservr[1433420]: [145B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [158B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [155B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [61B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [96B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [66B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [96B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [100B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [71B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [124B blob data]
[root@thermalite ~]#
The licensing PID was successfully processed. The new edition is [Express Edition].
ForceFlush is enabled for this instance.
ForceFlush feature is enabled for log durability.
Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service.
Setup has completed successfully. SQL Server is now starting.
[root@thermalite ~]# systemctl status mssql-server.service
● 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 Sat 2021-06-12 12:48:29 EDT; 1min 11s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 1433420 (sqlservr)
Tasks: 149
Memory: 661.0M
CGroup: /system.slice/mssql-server.service
├─1433420 /opt/mssql/bin/sqlservr
└─1433443 /opt/mssql/bin/sqlservr
Jun 12 12:48:32 thermalite.localdomain sqlservr[1433420]: [145B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [158B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [155B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [61B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [96B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [66B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [96B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [100B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [71B blob data]
Jun 12 12:48:33 thermalite.localdomain sqlservr[1433420]: [124B blob data]
[root@thermalite ~]# echo 'export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin' | sudo tee /etc/profile.d/mssql.sh
export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin
[root@thermalite ~]# source /etc/profile.d/mssql.sh
[root@thermalite ~]# sudo firewall-cmd --add-port=1433/tcp --permanent
success
[root@thermalite ~]# sudo firewall-cmd --reload
success
# install sql oracle driver for ms sql server
http://www.snapdba.com/2013/10/using-sql-developer-to-connect-to-sql-server-databases/#.YMTipvlKiUl
http://sourceforge.net/projects/jtds/files
https://sourceforge.net/projects/jtds/files/jtds/1.3.1/jtds-1.3.1-dist.zip/download
# test connection on sql developer
# Oracle SQL Developer Connection Details
Username: SA
Password: my_msql_server_pass
Hostname: 192.168.1.80
Port: 1433
Saturday, June 12, 2021
Install Microsoft SQL Server 2019 Express on Centos 8
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment