Freetds Connect to MS SQL Server 2019 all on Linux Ubuntu 18 04

If you want to connect to MS SQL Server 2019 all oon Linux (Ubuntu 18.04), Freetds is an option. We show you how to install Freetds and test wit query on Linux (Ubuntu 18.04) step by step.

# MS SQL Server 2019 is on Linux
lsb_release -a
ps -ef|grep sqlservr

# Get freetds 1.1.6-1 source package in Ubuntu

# Install
tar -xvf *.tar.gz
cd freetds*
./configure –help
sudo make install

# driver: /usr/local/lib/
ll /usr/local/lib/

# configure
sudo vi /usr/local/etc/freetds.conf

# A typical Microsoft server
host =
port = 1433
tds version = 7.3

# test and query data
tsql -S MSSQL2019 -U sa -P 1qaz@WSX
use quote
select top 10 * from quote
# Blog
# Facebook

Comments are closed.