In this article, we will discuss the step-by-step process of installing SQL Server on Linux on an Amazon EC2 instance. This installation will be done on a Red Hat Linux operating system.

Prerequisites

• An Amazon EC2 instance with Red Hat Linux
• Configured security groups (firewall) for the EC2 instance

Step 1: Launch Amazon EC2 Instance

Login to the AWS web console and launch an EC2 instance. Make sure to select Red Hat Linux as the operating system. Once the instance is launched, start it if it is in a stopped state.

Step 2: Update Packages

After connecting to the EC2 instance using a tool like Putty, it is recommended to update all packages to the latest versions. Execute the following command:

sudo yum update

Step 3: Download SQL Server 2017 Repository

Download the SQL Server 2017 repository file for Red Hat Linux by executing the following command:

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

Step 4: Install SQL Server

Install SQL Server using the following command:

sudo yum install mssql-server

Step 5: Configure SQL Server

Follow the prompts to configure SQL Server, including specifying the edition, accepting the license terms, and setting the SA account password.

Step 6: Install SQL Server Command-Line Tools

Install the SQL Server command-line tools by executing the following commands:

sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

sudo yum install -y mssql-tools

Step 7: Connect to SQL Server

Use the SQLCMD command-line tool to connect to SQL Server. Execute the following command:

sqlcmd -S localhost -U sa

Step 8: Stop SQL Server Services

To stop SQL Server services, use the following command:

sudo systemctl stop mssql-server

Conclusion

In this article, we have covered the installation of SQL Server on Linux on an Amazon EC2 instance with Red Hat Linux. By following these steps, you can successfully set up and connect to SQL Server on Linux.