Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Fixing dependency issues during installation of SQL Server Tools on Red Hat Linux Server


By:   |   Read Comments   |   Related Tips: More > SQL Server on Linux

Attend our free MSSQLTips Webcast - How to Simplify Routine SQL Server Administration Tasks


Problem

When we install SQL Server or SQL Server tools on a Linux server, it first checks the dependencies of the package to be installed. When installing the SQL Server tools on one of the Linux servers, I got the following error.

Error: Package: unixODBC-utf16-2.3.1-1.x86_64 (apt-mo.trafficmanager.net_yumrepos_mssql-rhel7-release_)
Requires: libltdl.so.7()(64bit)

Follow this tip to fix this type of error.

Solution

As you may know, SQL Server vNext does not install sqlcmd and the BCP utility along with the SQL Server installation on a Linux server. We need the sqlcmd utility to make a database connection to a Linux server, so we should install it on the target server where SQL Server is installed. I have explained the step by step method to install SQL Server tools on Red Hat Linux in my last tip.

In this tip, I will show how to fix any dependency error you face during installation. I will try to install the SQL Server tools on a Red Hat Linux server where I have already installed the SQL Server vNext version. Once I encounter a dependency error I will proceed with the fix in this tip.

Error during MSSQL Tools Installation on Redhat Linux 7.2

Step 1: First connect to the target Linux server on which you have installed SQL Server. You can directly connect to the server by logging in to do this exercise or you can use PuTTY a third party tool to make a Linux server connection. I used PuTTY to login to this server. I launched PuTTY and entered the IP address of the Linux server and then clicked the Open button as shown below.

PUTTY Configuration to Access SQL Server

Once you click on the Open button, a black screen with appear asking you to enter the login name followed the password. I entered the login name and password and then pressed enter to connect as shown in the below screenshot.

entered the login name and password and then pressed enter to connect

Step 2: You can see that I made a successful connection to the Linux server linux4mssql where I installed SQL Server. Now let's check and verify the SQL Server installation on this machine. Run the below command to check the mssql-server service.

#check the status of mssql-server service.
systemctl status mssql-server

Check the mssql-server service

We can see the service status shows enabled and active (running) which is highlighted in green. This means SQL Server is installed and running fine on this Linux server. To make a database connection directly on this server, we need to install the sqlcmd utility on this machine to access SQL Server.

Step 3: We will use superuser mode su for the next step. Superuser mode in Linux is similar to the system administrator account permission in Windows. So connect using superuser mode by running the below command.

#Connect with superuser permission
sudo su

You can see that I connected with the superuser account in the below screenshot.

connected to SQL Server with the superuser account

Step 4: Now we will run a curl command to download the installation packages from the Microsoft website to this Linux server. The downloaded file will be saved in location /etc/yum.repos.d/ as mentioned in the command line.

#Download installation configuration file.
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo

We can see the progress, time and details of the downloaded configuration file in the below picture.

curl command to download the installation packages from the Microsoft website to this Linux server

Now we can check the location /etc/yum.repos.d/ to verify whether the above file is saved in this location. Run the ls -lrt command to display all the files present in that folder.

#list all files/folders inside the yum.repos.d folder.
ls -lrt /etc/yum.repos.d/

check the location /etc/yum.repos.d/ to verify whether the above file is saved in this location

You can see our target file msprod.repo is in this location in the above picture. You can exit the superuser mode by typing exit followed by pressing enter.

Step 5: Now our next step is to install the SQL Server tools on this box with the help of this package. We will use the yum package to install it as we do for other applications on Linux. Run the below command to install SQL Server tools on this machine.

#Install SQL Server vNext tools
sudo yum install mssql-tools

Once you press enter to execute the above command, the execution process will start with checking some dependencies followed by downloading the required packages. Once the dependencies are resolved, all required packages will be displayed on this screen.

install SQL Server tools

We can see the download is not started because the command execution threw some error as shown in the above screenshot. This error is due to some dependency for the unixODBC-utf16-2.3.1-1.x86_64 package which requires another package known as libltdl.so.7()(64bit) for installation. We can see there are a sequence of dependencies inside the mssql tools package. Package mssql-tools.x86_64 requires msodbcsql, package msodbcsql requires unixODBC-utf16 and unixODBC-utf16 will require libltdl.so.7()(64bit). The package libltdl.so.7()(64bit) is missing which means it will not allow you to install the unixODBC-utf16 package and so on.

The Dependency Fix

Step 6:  I did some research to fix this issue, but was unable to find anything so I decided to first install the missing package libltdl.so.7()(64bit) on the Linux server. I did a Google search for this package and got a link to download the package libltdl.so.7()(64bit). If you open this link you will get the same package name libltdl.so.7()(64bit) mentioned under the "Provides" section of this page. Download this package to proceed with the next step.

Step 7: I downloaded this package on my local windows machine. My next challenge was to move this file onto the Linux server to install it. I used winscp, a third party tool to copy this downloaded package from my machine to Linux server. You can download winscp here. Now launch the winscp tool after installing it on your desktop, there are two panes for this tool. Files in left pane are on your Windows machine and files in the right pane are on your Linux server. We just need to drag and drop the target file from left pane to right pane to copy it to the Linux server. You can see I copied this downloaded package from C:\Users\Administrator\Downloads\ on my Windows machine to /home/Manvendra/ folder on the Linux server. Later we will check and verify this file on the Linux server.

Copy the downloaded package from C:\Users\Administrator\Downloads\ on my Windows machine to /home/Manvendra/ folder on the Linux server

Now go to your Linux server with PuTTY and check the location /home/manvendra to verify the file exists. You can see the file has been copied to this location in the below picture.

go to your Linux server with PuTTY and check the location /home/manvendra to verify the file exists

Now we need to move this package to /etc/yum.repos.d/ folder to kick off the installation of this package. Run the below commands to move this package to its destination folder.

#Move from/home/manvendra to /etc/yum.repos.d/
mv libtool-ltdl-2.4.2-21.217_2.x86_64.rpm /etc/yum.repos.d/libtool-ltdl-2.4.2-21.217_2.x86_64.rpm

#Verify whether file is copied to destination or not.
ls -lrt /etc/yum.repos.d/

move this package to /etc/yum.repos.d/ folder to kick off the installation of this package

Step 8: We can see our missing package which needs to be installed for the SQL Server tools package is copied to yum.repos.d folder in the above picture. The next step is to install this package to fix this issue. Run the below command to start the installation of this package.

#Run below command to start the installation of this package.
sudo yum install libtool-ltdl-2.4.2-21.217_2.x86_64.rpm

Once you execute this package, it will ask you to type y to proceed with this installation as shown in the below picture.

libtool-ltdl-2.4.2-21.217_2.x86_64.rpm installation

Type y to confirm all details are OK to proceed. Once you press enter, the download process will start followed by the installation of this package. You can see this package has been successfully installed on this Linux server.

libtool-ltdl-2.4.2-21.217_2.x86_64.rpm installation

Step 9: The dependency problem should be fixed after installing the above package. Now start the installation again of the mssql tools package by running the below command.

#Run below command to start the installation of this package.
sudo yum install mssql-tools

Now it's asking you to confirm the installation, to proceed type y.  This means the dependency issue was resolved, because we can see it's showing "Dependencies Resolved" in the below picture.

the dependency issue was resolved, because we can see it's showing Dependencies Resolved

Type y and press enter to proceed, now every package will ask you to enter YES to accept the license terms during installation as shown in the below screenshot.

Type y and press enter to proceed, now every package will ask you to enter YES to accept the license terms during installation

Enter YES for each particular package to install them one by one on your machine. Once installation is completed, you will get the below screen with the name of the installed product and its status as compete. We can see the installed product is showing as mssql-tools.x86_64*.

Once installation is completed, you will get the below screen with the name of the installed product and its status as compete

Step 10: The dependency issue is fixed and the MSSQL tools have been installed successfully on your Linux machine. Now we will check and verify whether the sqlcmd utility is installed to access SQL Server on this machine. Type sqlcmd and press enter to check the details of this utility.

#check sqlcmd utility.
sqlcmd

We can see that the sqlcmd command is recognized by Linux and the output of this command shows that sqlcmd is installed.

check status of sqlcmd installation

Step 11: Next we will validate that sqlcmd is working by making a database connection from the Linux box. Run the below command to connect to the database engine from the Linux server.

#Run sqlcmd to make database connection.
#You need to pass server name/IP address with -S, user name with -U and password with -P.
sqlcmd -S 192.168.209.128 -U SA -P 'XXXXXXX'

Once you will execute the above command, a SQL Server prompt will appear with cursor 1>. I executed "SELECT @@VERSION" to check the version of SQL Server installed and I got the below output

#I executed SELECT @@VERSION to get version details of SQL Server. I got below output:
Microsoft SQL Server vNext (CTP1) - 14.0.1.246 (X64)
 Nov 1 2016 23:24:39
 Copyright (c) Microsoft Corporation
 on Linux (Red hat Enterprise Linux Server 7.2 (Maipo))

check the version of SQL Server installed
Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools