How to install SQL Server 2019 on openSUSE Leap 15.3 and connect from SQL Server Management studio
4Installation guidance for SQL Server on Linux.
In this video we are going to see how to install microsoft sql server 2019 on openSUSE Leap 15.3.
Make sure that you have Internet connection to download the dependent packages from opensuse repositories which is used by sql server 2019.
Important Note: OpenSUSE does not have separate packages from microsoft. we can use suse linux enterprise 12 packages which is 100% compatible.
Download SQL Server 2019, ODBC drivers, Unix ODBC Drivers, MS-SQL Tools, MSSQL-CLI from below links.
Sql Server 2019 binary -- https://packages.microsoft.com/sles/12/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/sles/12/prod/
Make sure that you are creating Symbolic link after installing OpenLDAP 2 dependency. Otherwise sql server install will fail.
cd /usr/lib64
ln -s libldap_r-2.4.so.2.10.9 libldap-2.4.so.2
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 OpenSUSE 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 OpenSUSE 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 #sqlserveropensuse #sqlserver2019