Advance

Tutorial Install and Use SQL Server on AlmaLinux

Tutorial Install and Use SQL Server on AlmaLinux
3.7
(3)

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

Recommended Article: How To Install Zpanel On Ubuntu 20.04 & 19.10

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
Recommended Article: Introducing Acronis Backup And Recovery For Linux

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 [2]:

 

SQL Server in AlmaLinux

 

When you see the message “Do you accept the license terms?“, type “yes” and then press “Enter“. Then specify the administrator password:

 

Setup-SQL-Server-Admin-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:

source /etc/profile.d/mssql.sh

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:

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;
GO

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;
GO

 

Create SQL Database on Almalinux

 

Finally, you can delete the database using the following command:

DROP DATABASE eldernode_db;
GO
Recommended Article: The best VPS for SEO tools

Conclusion

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.

How useful was this post?

Click on a star to rate it!

Average rating 3.7 / 5. Vote count: 3

No votes so far! Be the first to rate this post.

We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

One thought on “Tutorial Install and Use SQL Server on AlmaLinux

  1. I wasn’t certain I could write this kind of article at the beginning. Your writing style impressed me. Again, your content was exceptional. Great Article Neil. While I read the article a few days back, I didn’t make a comment. But, I thought that it was worthy of a”thank you. I’ll use some of these suggestions on my own sites in the near future.

Leave a Reply

Your email address will not be published. Required fields are marked *

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+8595670151

7 days a week, 24 hours a day