How to install SQL Server 2017 on SUSE?

In this post, I will demonstrate how to install SQL Server 2017 on SUSE.

I will describe all the process of installation in detail point of view. I have checked a lot of blogs and posts in regards to installing SQL Server on Linux, but most of them didn't mention what does means that command or parameters in command detailly.

System requirements:

Red Hat Enterprise Linux - 7.3 and above

RAM Memory - 2 GB

File System - XFS or EXT4

Disk space - Minimum 6 GB

Processor - 2 GHz | 2 Cores | x64-compatible only

---

“The main reason why I write this post, I would like to describe in more detail than on other posts and blogs.”

First of all, you have to switch to root user:

• Download the Microsoft SQL Server 2017 SLES repository config file:

“In this tutorial, I will use free distribution of openSuse, especially openSUSE Leap 42.3.”

https://download.opensuse.org/distribution/leap/42.3/iso/ - openSUSE-Leap-42.3-NET-x86_64.iso

Note:

• zypper - This command line package manager in SUSE.

• addrepo - Adding from repository URL.

• -f - Add autorefresh flag to newly added repo file.

• -c - You automatically want to remove any packages that become unneeded after removing the specified package, use the --clean-deps option.

Then we have to import and refresh PGP key.

Right now, we are ready for installation SQL Server 2017, command is following:

Result looks as shown below:

We will run mssql-server setup

So, we will execute the command from the output from the previous command, the command is following:

1. Press number 2 for "Developer Editon"

2. Then write Yes to accept End-User Licensing Agreement(EULA)

3. And last action si setup of SysAdmin password

Choose "Developer Editon"

Password must have at least 8 characters and must contain:

• Capital letter

• Lowercase letter

• Numbers

• Specidif symbols

Result looks like:

Installation completed!

In order to able to run the query via mssql-tools, we need to add the Microsoft SQL Server repository to Zypper.

This command also provide downloading tools with configuration file.

Then we will install mssql-tools, run following command:

Then confirm "YES" and again "YES".

Accept license

And installation is completed.

The last step is modifying PATH in order to we don't have to write full path for the run tool:

You can check if you are able to connect to sqlcmd and exeute query following:

* use your ip address please!

That's it! I hope you enjoy this post!