How to install SQL Server 2019 on Fedora 33 WS and connect from SQL Server Management studio

Channel:

java frm

Subscribers:

5,740

Published on July 9, 2021 7:41:56 AM ● Video Link: https://www.youtube.com/watch?v=3oWi8OCgFe8

Game:

Binaries (2016)

Category:

Guide

Duration: 13:55

2,082 views

17

Installation guidance for SQL Server on Linux.
In this video we are going to see how to install microsoft sql server 2019 on Fedora 33 Workstation and connect from SQL Server Management Studio.
Make sure that you have installed all the dependencies as shown in the video, which is used by sql server 2019.
Needed internet connection to download dependent rpms from fedora repositories. Red Hat rpm packages are 100% compatible with Fedora Linux. So we are using
Red Hat rpm packages for SQL Server 2019.

Sql Server 2019 binary -- https://packages.microsoft.com/rhel/8/mssql-server-2019/

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.

MS-SQL Tools, ODBC Drivers --- https://packages.microsoft.com/rhel/8/prod/

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 Fedora Linux:

systemctl start mssql-server.srevice
systemctl stop mssql-server.srevice
systemctl status mssql-server.srevice

SQL Server ports are unblocked by firewall before installation.

How to Unblock SQL Server ports on firewall or Allow Port 1431,1433,1434 Fedora 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 #sqlserverfedoralinux #sqlserver2019fedora33 #sqlserver2019

Other Statistics