Nowadays, information retention is one of the most important organs for the survival of a system. That’s why Microsoft SQL Server is one of the most popular and powerful database building and management software. In this article, we are going to teach you step by step How to Install and Use SQL Server on AlmaLinux. You can visit the packages available in Eldernode if you wish to purchase a Linux VPS server.
How to Install and Use SQL Server on AlmaLinux
Introduction to SQL and its Features
SQL Server is a relational database management system (DBMS). This system was developed by Microsoft and supports the ANSI SQL language. There are several types of database management software, one of which is the relational model. In the relational model, instead of simply putting the data into a file, it is organized into a series of tables and then stored. Each table contains a number of rows and columns called Tuples and Attributes.
Microsoft’s SQL Server also has some competitors, such as MySQL and Oracle. Now we want to examine the advantages of SQL Server and see what makes it ahead of the competition in some cases:
1. It is easy to install, configure and set up.
2. It has a good user interface that makes it easier to work with data.
3. It has high security.
4. You can recover lost data if needed.
5. Supports cloud and on-premises databases.
6. It has different versions that are optimized for different tasks.
7. Many pieces of training and documents have been prepared for it.
8. It can also be used on Linux operating system.
In the next section, we will teach you how to Install SQL Server on AlmaLinux. Please join us.
Install SQL Server on AlmaLinux
In this section, we are going to show you how to Install SQL Server on AlmaLinux. To do this, you must follow the steps below in order. You must first add the repositories using the following commands:
sudo curl https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo -o /etc/yum.repos.d/mssql-server-2019.repo
sudo curl https://packages.microsoft.com/config/rhel/8/prod.repo -o /etc/yum.repos.d/msprod.repo
Now, you can easily install SQL Server by running the following command:
sudo dnf install mssql-server
You can also install the Microsoft SQL server command-line tool using the following command:
sudo dnf install mssql-tools unixODBC-devel
When you see the message “Do you accept the license terms?“, type “yes” and then press “Enter“.
After the installation is complete, verify that Microsoft SQL Server is installed using the following command:
rpm -qi mssql-server
How to Configure SQL Server on AlmaLinux
In this section, we will configure Microsoft SQL Server and launch the database engine. To do this you can run the following command:
sudo /opt/mssql/bin/mssql-conf setup
As you can see in the image below, you will be asked to select a version of SQL Server. Select the second option :
When you see the message “Do you accept the license terms?“, type “yes” and then press “Enter“. Then specify the administrator password:
To verify the running status of the SQL server, use the following command:
sudo systemctl status mssql-server.service
Use the following command and enable it to start the boot:
sudo systemctl enable mssql-server.service
Then in the next step, export the path /opt/mssql/bin/ using the following command:
echo 'export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin' | sudo tee /etc/profile.d/mssql.sh
Now you need to enable the /etc/profile.d/mssql.sh file using the following command:
One thing to keep in mind is that MS SQL listens on port 1433 by default. Therefore, it is necessary to open this port in the firewall using the following commands so that external users can access the server:
sudo firewall-cmd --add-port=1433/tcp --permanent
sudo firewall-cmd --reload
How to Use SQL Server on AlmaLinux
After you have seen how to install and configure SQL Server on AlmaLinux in the previous sections, we now want to teach you how to use SQL Server and test it.
The first step is to use the following command to make sure the MS SQL version is installed and check the version:
sqlcmd -S localhost -U SA -Q 'select @@VERSION'
To view the version, press Enter after typing the above command. You can also use the following command to exit:
Now to test SQL Server, you must log in again by executing the following command:
sqlcmd -S localhost -U SA
Note: Now you need to authenticate with your password and then press ENTER. It should be noted that you can list user names by running the following command:
SELECT name FROM sys.sysusers;
You can easily create a database using the following command:
CREATE DATABASE eldernode_db;
You can also view the list of all databases using the following command:
SELECT name FROM sys.databases;
Finally, you can delete the database using the following command:
DROP DATABASE eldernode_db;
One of the most prominent features of SQL Server is that it can work with large databases up to terabytes. Another thing is that thousands of users can access this database at the same time. In this article, we tried to teach you how to Install and Use SQL Server on AlmaLinux.