How to install SQL Server 2019 on Oracle Linux 7 and connect from SQL Server Management studio

preview_player
Показать описание
Installation guidance for SQL Server on Linux.
In this video we are going to see how to install microsoft sql server 2019 on Oracle Linux 7.
Make sure that you have installed all the dependencies as shown in the video, which is used by sql server 2019.
All dependencies are available in dvd iso itself. Red Hat rpm packages are 100% compatible with Oracle Linux. So we are using
Red Hat rpm packages for SQL Server 2019.
Important Note: Please Use Oracle Linux 7.7+ versions, because sql server 2019 uses python 3, which is available from Oracle Linux 7.7 DVD itself.

Install sqlcmd and bcp the SQL Server command-line tools on Linux
The mssql-tools package contains:

sqlcmd: Command-line query utility.
bcp: Bulk import-export utility.

We will be installing SQL Server 2019 Developer Edition on this video, which is full featured and free to use for development.

How to start/stop sql server service on Oracle Linux 7:

SQL Server ports are unblocked by firewall before installation.

How to Unblock SQL Server ports on firewall or Allow Port 1431,1433,1434 Oracle Linux for SQL Server

firewall-cmd --zone=public --add-port=1431/tcp --permanent
firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --zone=public --add-port=1434/tcp --permanent

#sqlserveronlinux #sqlserveroraclelinux7 #sqlserver2019oraclelinux7 #sqlserver2019
Рекомендации по теме
Комментарии
Автор

Hi sir,

How to open sql developer in linux machine with oracle database.

prashanths
join shbcf.ru