{"id":2387,"date":"2020-11-19T07:00:00","date_gmt":"2020-11-19T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2387"},"modified":"2024-07-01T17:52:55","modified_gmt":"2024-07-01T14:52:55","slug":"pos-kanoyme-egkatastasi-sql-server-se-linux","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-egkatastasi-sql-server-se-linux\/","title":{"rendered":"How to install SQL Server on Linux"},"content":{"rendered":"

In this article we will see how easy it is to install SQL Server 2019<\/strong> on a machine with a Linux operating system and more specifically on a Red Hat distribution. We will also see how we connect and how we can pass settings to the instance. <\/p>\n\n\n\n

Prerequisites<\/h2>\n\n\n\n

For Red Hat based systems we want above version 7.3 with at least 2GB of RAM<\/strong>. The system must have access to the Internet.<\/p>\n\n\n\n

In case we do not have enough memory during the installation we will see this message:<\/p>\n\n\n\n

\"sqlservr: This program requires a machine with at least 2000 megabytes of memory.\"<\/code><\/pre>\n\n\n\n
Also in case we are using the RHEL 8 version we should install Python2 and OpenSSL as they are required for the installation and this version does not have them pre-installed.<\/p>\n\n\n\n
\"\"
docs.microsoft.com<\/figcaption><\/figure>\n\n\n\n
In case this is to blame we will see this message during the installation.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
To install Python2 and OpenSSL<\/h5>\n\n\n\n
sudo yum install python2\nsudo yum install compat-openssl10\n\n# Configure python2 as the default interpreter using this command: \nsudo alternatives --config python.<\/pre>\n\n\n\n
The installation<\/h2>\n\n\n\n
First we need to download it repository <\/strong>which contains him SQL Server 2019<\/strong>.<\/p>\n\n\n\n
sudo curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/8\/mssql-server-2019.repo<\/pre>\n\n\n\n
With an update and install, installation of the binaries will begin.<\/p>\n\n\n\n
sudo yum update\n\nsudo yum install -y mssql-server<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
When the installation is complete with the tool mssql-conf setup<\/strong> we will define the version and the code that the instance will have.<\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf setup\n<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
To see that the instance service is running:<\/p>\n\n\n\n
systemctl status mssql-server<\/pre>\n\n\n\n
We don't forget to open the SQL Server door to firewall <\/strong>so we can connect from another machine.<\/p>\n\n\n\n
sudo firewall-cmd --zone=public --add-port=1433\/tcp --permanent\nsudo firewall-cmd --reload<\/pre>\n\n\n\n
Installing the SQL Server command-line tools<\/h2>\n\n\n\n
After completing the installation, we may want to connect to the instance from the same machine, so it would be good to install the tools that allow us to connect and do some other tasks.<\/p>\n\n\n\n
Again we follow the same process of downloading the repository and installing it.<\/p>\n\n\n\n
sudo curl -o \/etc\/yum.repos.d\/msprod.repo https:\/\/packages.microsoft.com\/config\/rhel\/8\/prod.repo\n\nsudo yum install -y mssql-tools unixODBC-devel<\/pre>\n\n\n\n
How we connect<\/h2>\n\n\n\n
To connect locally with the well-known sqlcmd tool, with the -S parameter we define the server and with -U -P the username and password respectively.<\/p>\n\n\n\n
\/opt\/mssql-tools\/bin\/sqlcmd -S localhost -USA -Pkwdikos -e<\/pre>\n\n\n\n
After connecting, write the query we want and then write GO<\/strong> so that its execution can proceed.<\/p>\n\n\n\n
\"\"
The image is from another installation so it says version 2017<\/figcaption><\/figure>\n\n\n\n
How we configure SQL Server on Linux<\/h2>\n\n\n\n
But we also need to know some daily changes that are made respectively in this operating system.<\/p>\n\n\n\n
To start \/ stop the instance<\/h5>\n\n\n\n
With the following commands we stop and start the service of the instance<\/p>\n\n\n\n
sudo systemctl stop mssql-server\nsudo systemctl start mssql-server\n<\/pre>\n\n\n\n
To start the base with a different option<\/h5>\n\n\n\n
Sometimes, usually due to a fault, it will be necessary to start the instance with some parameter, e.g. to be in single-user mode. We do this with the command:<\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/sqlservr -m<\/pre>\n\n\n\n
To activate one traceflags<\/strong><\/h5>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf traceflag 7412 on<\/pre>\n\n\n\n
To enable SQL Server Agent<\/strong><\/h5>\n\n\n\n
The SQL Server Agent is disabled by default, so to activate it we run the command:<\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf set sqlagent.ena                                               bled on\n<\/pre>\n\n\n\n
To change it collation<\/strong><\/h5>\n\n\n\n
To change the collation on the instance to another of the compatible <\/a> we run the command.<\/p>\n\n\n\n
*Caution the collation change in the instance is performed with a specific process <\/a>to be successful<\/em>.<\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf set-collation<\/pre>\n\n\n\n
Sources:<\/h2>\n\n\n\n