How to install SQL Server 2017 on SUSE?
Aktualizováno: 30. 1. 2019
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.
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.”
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:
So, we will execute the command from the output from the previous command, the command is following:
Press number 2 for "Developer Editon"
Then write Yes to accept End-User Licensing Agreement(EULA)
And last action si setup of SysAdmin password
Password must have at least 8 characters and must contain:
Result looks like:
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".
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!