Category / Section
How to Install MS SQL Server in a Linux Environment
Published:
Microsoft SQL Server is a widely used relational database management system (RDBMS) that offers robust features for data storage, retrieval, and management. This article provides a comprehensive guide on installing and configuring Microsoft SQL Server on a Linux operating system. Additionally, it offers detailed instructions on configuring the server to allow public access while ensuring security.
Prerequisites
Before proceeding with the installation, ensure that your system meets the following requirements:
- Supported Linux distribution refer to Microsoft documentation for compatibility.
- Sufficient disk space for installation and database storage.
- Administrative privileges on the machine.
- Basic familiarity with Linux command-line interface.
Download, Install and Connect SQL Server for Linux
STEP 1: Connect
the Linux VM in the Terminal.
STEP 2: Distribution
based installation steps.
- For Debian based distribution (e.g., Ubuntu) follow the below documentation for installing MSSQL in Ubuntu’s respective version (e.g., Ubuntu 20.04, Ubuntu 22.04) Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Learn.
- For RedHat based distribution (e.g., CenOS, RedHat) follow the below documentation for installing MSSQL in respective Oss (e.g., CentOS, Red Hat 8/9) RHEL: Install SQL Server on Linux - SQL Server | Microsoft Learn.
STEP 3: To connect the MSSQL DB (which is installed
in the Linux VM) locally, using the SQL server management, allow the MSSQL port
number (1443) in the VM’s networking section.