How to Install SQL Server Agent on RedHat Linux Server without Internet – Offline Installation
The SQL Server Agent runs scheduled SQL Server jobs and very useful to automate database tasks. Here i will show you how to install SQL Server Agent on RedHat Linux server. We will use offline method to install SQL tools because our Linux server is running without an internet connection.
We can easily install SQL Server Agent on RHEL if we have internet access to the online repositories on the RHEL server but it’s bit complex to install any package if we don’t have internet access on the server. Here i will explain how to perform offline installation of SQL Server Agent on RHEL which are running without internet connection.
Before going ahead, we need a SQL Server Instance running on RedHat Linux Server. If you have no idea about installing Linux server or SQL Server 2017 or creating a virtual machine where you can install Linux and SQL Server then i would recommend you to read below articles.
- How to Create a Virtual Machine.
- How to Install RedHat Linux 7.3 on a virtual machine.
- How to Install SQL Server 2017 on RedHat Linux.
- How to Install SQL Tools on RedHat Linux.
Offline Installation of SQL Server Agent on RHEL
It becomes painful to install anything if your RHEL server has no access to internet. We generally call such installations as offline installation. Microsoft suggests below steps for offline installation of SQL Server Agent on Red Hat Linux server.
- Download SQL Server Agent package.
- Move this downloaded package to your Red Hat Linux Machine.
- Install the copied rpm package on the server.
- Resolve Missing Dependencies, if you get any.
Now we will go step by step process with the screenshots that will be helpful for readers to understand whole process.
Offline Installation – Step by Step
Before moving ahead let’s check whether SQL Server Agent is installed or not on this machine. You can connect to SQL Server instance using SSMS on your local host. You can see we are not able to see SQL Server Agent folder.
You can check and verify SQL Server service by executing below command whether SQL Server is installed on this machine or not.
systemctl status mssql-server
You should proceed if SQL Server service is running fine. Next step is to start the package download and proceed with installation. Below is the image of SQL Server Agent Package which we will download to install SQL Server Agent.
Download the highlighted rpm package for SQL Server Agent. You can download this package on machine or PC which is connected to the internet. Once package will be downloaded to your local PC, next step is to copy this packages to the Red Hat Linux server that are running without internet connection. I used WinSCP tool to copy this file from machine where i have downloaded this package to the Linux server. Make sure that there should be connectivity between both machine.
If you have not installed WinSCP, download it and install on your PC. Launch WinSCP tool and make a connection to Red Hat Linux server. There are two panes in WinSCp window. The files shows in left side pane is your local system and right side pane is your target Linux server. Now we just need to drag the downloaded rpm packages from left side pane and drop it to right side pane to copy it to Linux server and it will be done. You can see files are copied now and we can see the files in both side panes.
You can see rpm packages is copied to location \home\techyaz\Packages\ in WinSCP screen. Now we can connect to Linux server and validate whether this file is copied there or not. Connect to Linux server and check the files. We can see downloaded file is very much there on Linux server.
Now our next step is to install this package. We will use the yum package to install it as we do for other applications on Linux. I used yum localinstall because we are installing SQL Server offline with the help of local package which we just copied from local host. Let’s install it by running below command.
sudo yum localinstall mssql-server-agent-14.0.900.75-1.x86_64.rpm
Enter the Sudo password to start the installation.
Once installation will start, it will check dependencies and ask you to type y to proceed for the installation. Below is the image of the installation of this package.
Type y and press enter to proceed. Once you press enter, setup will process to complete the installation. Below image shows the successful installation of this package.
This installation has suggested us to restart SQL Server service to complete this installation so go ahead and restart the service by executing below command.
systemctl restart mssql-server
Now SQL Server Agent has been installed on this server. Go ahead connect to this SQL Server Instance using SSMS from local host. This time you would be able to see SQL Server Agent folder.
You can see SQL Server Agent is showing there. Now you can create any jobs on SQL Server to automate any activity.
Read below articles if you want to learn how to:
- Create a Virtual Machine.
- Install RedHat Linux 7.3 on a virtual machine.
- Install SQL Server 2017 on RedHat Linux using Internet
- Install SQL Tools on RedHat Linux using Internet
- SQL Server Update Statistics Best Practices - April 15, 2020
- Understanding Hybrid Buffer Pool in SQL Server - December 30, 2018
- Fix:VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ - August 30, 2018