Hướng dẫn cài đặt SQL Server 2017 lên Linux Ubuntu 18 (ONLINE)

Linux



INSTALLING SQL SERVER 2017 on UBUNTU 18.04
———————————
Steps:

1. Import the public repository GPG keys:

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –

2. Register the Microsoft SQL Server Ubuntu repository:

sudo add-apt-repository “$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)”

4. Downgrade OpenSSL:

https://packages.ubuntu.com/xenial/openssl

5. To install SQL Server:

sudo apt-get update
sudo apt-get install -y mssql-server

6. To set the SA password and choose edition.

sudo /opt/mssql/bin/mssql-conf setup

7. Post check

systemctl status mssql-server

8. Open Firewall, default port: 1433

sudo ufw allow 1433/tcp
sudo ufw allow 1433/udp

9. Download sample database:

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

source

2 thoughts on “Hướng dẫn cài đặt SQL Server 2017 lên Linux Ubuntu 18 (ONLINE)

Comments are closed.