Rajendra Gupta
SUSE Linux using a remote SQL Server Management Studio

Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance

October 26, 2020 by

In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.


SQL Server works on both Windows and Linux operating systems. You can use RedHat, Ubuntu or SUSE Linux for SQL Server. You can build the database infrastructure in the on-premise and cloud infrastructures.

With the Amazon Web Services, we can use SQL Services in two-mode.

  • AWS RDS SQL Server: It is a managed database service for SQL Server by AWS. Amazon manages the infrastructure such as server, OS, storage, network, back, high-availability, security on your behalf. You can launch an RDS instance and use it directly to run for your databases, queries. It provides limited functionality as compared to a regular SQL Server
  • AWS EC2 with SQL Server installed: In this method, we can build a virtual machine in the AWS cloud and installed SQL Server on top of it. It is similar to a traditional on-premise SQL Server, but this time your infrastructure (server) is in the cloud

In this article, we implement the following tasks:

  • Launch an Amazon EC2 instance with SUSE Enterprise Linux version 12
  • Install SQL Server Linux (2017) and client tools on Amazon EC2 instance

Let’s start our deployment for this article.


You should have AWS console credentials. If you do not have an AWS login, sign-up using a free-tier account in Amazon web console.

a free-tier account in Amazon web console

Here, you can see a few free-tier account benefits:

Free-tier benefits

Launch Amazon EC2 instance for SUSE Linux Enterprise Server

To launch an EC2 instance, log in to the AWS Web Console and go to the EC2 dashboard from Services-> EC2.

EC2 dashboard

In this dashboard, you can verify I don’t have any running EC2 machine( Running Instances =0). Click on Launch instance.

Step 1: Choose an Amazon Machine Image (AMI)

In the first step, search for the required Amazon Machine Image (AMI). You can search for the specific operating system as we searched for SUSE in the below image.

Choose an Amazon Machine Image (AMI)

In the above image, we see SUSE 12 SP2 and SUSE 12 SP5 version images. Currently, SQL Server Linux supports SUSE 12 version. Click on Select for SUSE 12.

Step 2: Choose an instance type

AWS provides various configurations for the server’s compute requirements. On this page, you see vCPU, Memory and network performance for these instances. In case an instance is eligible for free-tier, it puts marks free-tier available.

Choose an instance type

In this article, we go with the t2.medium instance with 2 vCPU and 4 GiB memory.

Step 3: Configure Instance details

In this step, we can configure the number of instances, network, IAM role, shutdown behavior and domain. You should configure these details carefully. In my case, it is a lab setup so we can use the default configurations.

Configure Instance details

Step 4: Add Storage

In a free-tier account, you get up to 30 GB of general-purpose SSD storage. Choose the storage size that fits your database, backup requirements. By default, it deletes the storage (delete on termination) if you terminate the EC2 instance.

Add Storage

Step 5: Add Tags

In this optional step, we can assign tags in a key-value pair for our AWS resources.

Add Tags

Step 6: Configure Security Group

In AWS, the security group combines firewall rules for your EC2 instances. You can create an existing security group or create a new group from this AWS console.

Configure Security Group

Step7: Review Instance Launch

Here, you can verify your instance configurations. You get two warning messages in the below image.

  • I used t2.medium instance for the EC2, and it is not eligible for the free-tier account. Therefore, it gives a warning message
  • My security group ( firewall) rules allow all IP’s and ports access. It is not a desirable security group for a production server

We can ignore these warnings and go ahead with launching the SUSE Linux server.

Review Instance Launch for Amazon EC2 instance

You require a key pair ( public key and private key) to connect the EC2 instances securely. AWS stores the public key in the AWS stores. If you do not have an existing key pair, select the option – create a new key pair and specify a name. It asks you to download and save it securely.

  • Note: It is the first and last time AWS allows to download key pair. In case you did not save it properly, you cannot regenerate it. You need to create a new key pair and assign it to the EC2 instance

Key pair

It takes a little time to launch the AWS EC2 instance with your specified configuration.

Launch Status

My SUSE Enterprise Linus 12 EC2 instance is in running state, as shown below. Note-down the public IPv4 address and public IPv4 DNS.

Check instance status SUSE Enterprise Linus 12 EC2 instance

Install and Configure SQL Server Linux (2017 version) on SUSE Enterprise Server 12 for Amazon EC2 instance

To connect the SUSE Linux Amazon EC2 instance, we use PuTTY utility. We need a PPF format key file. You can refer to the article, Connect Red Hat Amazon EC2 Instance and follow the process to convert PEM into the PPF file.

Launch Putty, enter EC2 public IP address and connect.

Connect using PuTTY

SUSE Linux uses the default ec2-user for authentication purposes. It does not prompt for a password because the authentication happens using the key-value pair.

EC2 authentication

Download SQL Server Linux (2017 version) SLES repository configuration file

SUSE Linux uses Zypper as a command-line interface to install, remove, and update the repositories and software. The below command downloads the repository from the Microsoft package repository, as shown below.

Microsoft repository

Download SQL Server Linux repository

Refresh your GPG keys

In this step, refresh your GPG keys with the below command.

In the output, we see that it checks for each repository and updates for SQL Server Linux (2017 version) repository.

Refresh your GPG keys

It returns the SQL Server 2017 repository, key name, its created and expiry date. It uses the Microsoft package signing key as shown below.

Microsoft package signing key

Import the Microsoft package signing key using the RPM command.

Import the Microsoft package

Install SQL Server Linux (2017 version) on SUSE Linux

Now, we are ready to deploy our SQL Server 2017 instance on the SUSE Linux AWS EC2 server. It downloads the required packages and installs them.

Install SQL Server on SUSE

This command installs the SQL Server but does not configure it. It specifies you to run a command mssql-conf for SQL Server Configuration.

Installation progress

Configure SQL Server Linux (2017 version) on SUSE Linux

Use the below mssql-conf command and provide the following inputs.

  • SQL Server edition: We can choose from Evaluation, Developer(free), Web, Standard, Enterprise Core editions
  • SA password

MSSQL configurations

Verify SQL Service status

Once the SQL Service is installed, use the systemctl command to verify the service is in running status.

Verify SQL Service status

Install SQL Server client tools

You can connect the SQL Server Linux (2017 version) on SUSE Linux using the following client tools:

  • Azure Data Studio
  • SQL Server Management Studio (SSMS)

From the above list, we can install SQLCMD (command-line) and Azure Data Studio (Graphical) tools to connect SQL instance and execute your queries.

First, we install the SQLCMD command-line tool in AWS EC2 SUSE Linux. Download the client tools repository and refresh the keys.

Install SQL Server client tools

Refresh keys

Install SQLCMD command-line tools

Install SQLCMD command-line tools

Accept the license terms, and it installs the mssql-tools as shown below.

Accept the license terms

Add the /opt/mssql-tools/bin in the PATH environment variable

In the step, add the mssql-tools path in the Linux environment variables. It helps you to directly use the command-line tools without specifying the full path every time.

PATH environment variable

Connect SQL Server 2017 on SUSE Linux for Amazon EC2 instance

Once we have installed SQL Server tools, we can use the SQLCMD to connect SQL Server and verify its edition, version using select @@version t-SQL.

Connect SQL Server 2017 on SUSE Linux for AWS EC2 instance

Connect SUSE Linux using a remote SQL Server Management Studio

Database professionals use SQL Server Management Studio (SSMS) for performing both database administration and development activities. We cannot install SSMS on the Linux platform, but you can access the Linux SQL using a remotely installed SSMS.

Launch the SSMS, specify the public IP or endpoint in the server name and connect with SA authentication. After connecting to SQL Server, open the SQL Server properties. We can verify the SQL Server developer edition for SUSE Linux Enterprise Server (SLES) 12.5 is 14.0.3356.20. It is the latest cumulative update(released on 10th Sep 2020) – CU22 for SQL Server 2017.

SUSE Linux using a remote SQL Server Management Studio

Enable SQL Server Agent for SUSE Linux in AWS EC2 instance

We can use SQL Server Agent in Linux as well for jobs scheduling. Starting from SQL Server 2017 CU4, We need to enable the SQL Server agent. Earlier versions are required to install the SQL Server agent as well. In this article, We installed CU22 for SQL Server 2017; therefore, enable it using the below command.

Restart SQL Services to activate the SQL Server agent.

Enable SQL Server Agent

Now, refresh the SLES Linux in SSMS, and it shows the enabled SQL Server Agent.

enabled SQL Server Agent


In this article, we launched an Amazon EC2 instance for SUSE Linux Enterprise Server (SLES) and installed SQL Server Linux (2017 version) on it. You should consider practicing SQL Server features on both Windows and Linux operating systems.

Rajendra Gupta
Latest posts by Rajendra Gupta (see all)