15 49.0138 8.38624 1 0 4000 1 https://kadirkozan.com.tr 300 0

Ubuntu Server 20.04 üzerine Microsoft SQL Server 2019 Kurulumu

Microsoft 2016 yılında SQL Server için açık kaynaklı bir ilişkisel veritabanı sistemi geliştirdi. Bu makalemde Microsoft SQL Server 2019’un Ubuntu Server işletim sistemine kurulumu için yapılması gerekenleri göstereceğim.

Ubuntu 20.04 işletim sistemi üzerine MS SQL kurmak için minimum sistem gereksinimleri aşağıdaki gibi olmalıdır.

  • Minimum 2 GB RAM
  • En az 2 çekirdekli CPU
  • SQL Server kurulumu için işletim sistemi üzerine en az 20 GB boş disk alanı olmalıdır.

İşletim sisteminizin sürümünü doğrulamak için aşağıdaki komutu kullanabilirsiniz.

lsb_release -a

SQL Server 2019, komut satırı araçları ve ilgili yönetim yazılımı kurulumuna başlamadan önce yerel sistemimizin güncel olduğundan ve gerekli paketlerin kurulu olduğundan emin olalım. Aşağıdaki komutları çalıştırmak için bir terminal açın. Birincisi yerel paket önbelleğinizi ve işletim sisteminizi güncelleyecek. İkincisi, gelecekteki komutlar için ihtiyaç duyacağımız curl ve gerekli kütüphaneleri kuracaktır.

apt-get update -y
apt-get upgrade -y
apt install curl libxss1 libgconf-2-4 libunwind8

SQL Server’ı Ubuntu’da yapılandırmak için, mssql-server paketini kurmak için aşağıdaki komutları sıralamaya uygun olarak çalıştırılması gerekmektedir.

İşletim sisteminize, MS SQL apt depo paketlerine güvenmesi için GPG anahtarı ekleyiniz;

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –

SQL Server 2019 için Ubuntu işletim sitemiz üzerindeki repoya ekleyiniz.

add-apt-repository “$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)”

SQL Server’ı kurmak için aşağıdaki komutları çalıştırınız.

apt-get update -y
apt-get install mssql-server

root@vkk-sql:~# apt-get update -y

Hit:1 http://archive.ubuntu.com/ubuntu focal InRelease
Get:2 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB]
Hit:3 https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal InRelease
Get:4 http://archive.ubuntu.com/ubuntu focal-backports InRelease [108 kB]
Get:5 http://archive.ubuntu.com/ubuntu focal-security InRelease [114 kB]
Get:6 http://archive.ubuntu.com/ubuntu focal-security/main amd64 Packages [1,422 kB]
Get:7 http://archive.ubuntu.com/ubuntu focal-security/universe amd64 Packages [700 kB]
Fetched 2,458 kB in 11s (214 kB/s)
Reading package lists… Done

root@vkk-sql:~#

root@vkk-sql:~# apt-get install mssql-server

Reading package lists… Done
Building dependency tree
Reading state information… Done
The following additional packages will be installed:
  gdb gdbserver libatomic1 libbabeltrace1 libc++1 libc++1-10 libc++abi1-10 libc6-dbg libcc1-0 libdw1 libsasl2-modules-gssapi-mit libsss-nss-idmap0
Suggested packages:
  gdb-doc clang
The following NEW packages will be installed:
  gdb gdbserver libatomic1 libbabeltrace1 libc++1 libc++1-10 libc++abi1-10 libc6-dbg libcc1-0 libdw1 libsasl2-modules-gssapi-mit libsss-nss-idmap0 mssql-server
0 upgraded, 13 newly installed, 0 to remove and 1 not upgraded.
Need to get 268 MB of archives.
After this operation, 1,286 MB of additional disk space will be used.

Do you want to continue? [Y/n] Y


Get:1 http://archive.ubuntu.com/ubuntu focal/main amd64 libdw1 amd64 0.176-1.1build1 [226 kB]
Get:2 https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal/main amd64 mssql-server amd64 15.0.4198.2-10 [253 MB]
Get:3 http://archive.ubuntu.com/ubuntu focal/main amd64 libbabeltrace1 amd64 1.5.8-1build1 [156 kB]
Get:4 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 gdb amd64 9.2-0ubuntu1~20.04.1 [3,222 kB]
Get:5 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 gdbserver amd64 9.2-0ubuntu1~20.04.1 [222 kB]
Get:6 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libatomic1 amd64 10.3.0-1ubuntu1~20.04 [9,284 B]
Get:7 http://archive.ubuntu.com/ubuntu focal/universe amd64 libc++abi1-10 amd64 1:10.0.0-4ubuntu1 [59.4 kB]
Get:8 http://archive.ubuntu.com/ubuntu focal/universe amd64 libc++1-10 amd64 1:10.0.0-4ubuntu1 [193 kB]
Get:9 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libcc1-0 amd64 10.3.0-1ubuntu1~20.04 [48.8 kB]
Get:10 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libsasl2-modules-gssapi-mit amd64 2.1.27+dfsg-2ubuntu0.1 [36.8 kB]
Get:11 http://archive.ubuntu.com/ubuntu focal/universe amd64 libc++1 amd64 1:10.0-50~exp1 [2,904 B]
Get:12 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libc6-dbg amd64 2.31-0ubuntu9.7 [10.5 MB]
Get:13 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libsss-nss-idmap0 amd64 2.2.3-3ubuntu0.8 [21.3 kB]
Fetched 268 MB in 2min 10s (2,065 kB/s)
Preconfiguring packages …
Selecting previously unselected package libdw1:amd64.
(Reading database … 71857 files and directories currently installed.)
Preparing to unpack …/00-libdw1_0.176-1.1build1_amd64.deb …
Unpacking libdw1:amd64 (0.176-1.1build1) …
Selecting previously unselected package libbabeltrace1:amd64.
Preparing to unpack …/01-libbabeltrace1_1.5.8-1build1_amd64.deb …
Unpacking libbabeltrace1:amd64 (1.5.8-1build1) …
Selecting previously unselected package gdb.
Preparing to unpack …/02-gdb_9.2-0ubuntu1~20.04.1_amd64.deb …
Unpacking gdb (9.2-0ubuntu1~20.04.1) …
Selecting previously unselected package gdbserver.
Preparing to unpack …/03-gdbserver_9.2-0ubuntu1~20.04.1_amd64.deb …
Unpacking gdbserver (9.2-0ubuntu1~20.04.1) …
Selecting previously unselected package libatomic1:amd64.
Preparing to unpack …/04-libatomic1_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libatomic1:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libc++abi1-10:amd64.
Preparing to unpack …/05-libc++abi1-10_1%3a10.0.0-4ubuntu1_amd64.deb …
Unpacking libc++abi1-10:amd64 (1:10.0.0-4ubuntu1) …
Selecting previously unselected package libc++1-10:amd64.
Preparing to unpack …/06-libc++1-10_1%3a10.0.0-4ubuntu1_amd64.deb …
Unpacking libc++1-10:amd64 (1:10.0.0-4ubuntu1) …
Selecting previously unselected package libcc1-0:amd64.
Preparing to unpack …/07-libcc1-0_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libcc1-0:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libsasl2-modules-gssapi-mit:amd64.
Preparing to unpack …/08-libsasl2-modules-gssapi-mit_2.1.27+dfsg-2ubuntu0.1_amd64.deb …
Unpacking libsasl2-modules-gssapi-mit:amd64 (2.1.27+dfsg-2ubuntu0.1) …
Selecting previously unselected package libc++1:amd64.
Preparing to unpack …/09-libc++1_1%3a10.0-50~exp1_amd64.deb …
Unpacking libc++1:amd64 (1:10.0-50~exp1) …
Selecting previously unselected package libc6-dbg:amd64.
Preparing to unpack …/10-libc6-dbg_2.31-0ubuntu9.7_amd64.deb …
Unpacking libc6-dbg:amd64 (2.31-0ubuntu9.7) …
Selecting previously unselected package libsss-nss-idmap0.
Preparing to unpack …/11-libsss-nss-idmap0_2.2.3-3ubuntu0.8_amd64.deb …
Unpacking libsss-nss-idmap0 (2.2.3-3ubuntu0.8) …
Selecting previously unselected package mssql-server.
Preparing to unpack …/12-mssql-server_15.0.4198.2-10_amd64.deb …
Unpacking mssql-server (15.0.4198.2-10) …
Setting up libdw1:amd64 (0.176-1.1build1) …
Setting up libc6-dbg:amd64 (2.31-0ubuntu9.7) …
Setting up libatomic1:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libbabeltrace1:amd64 (1.5.8-1build1) …
Setting up libc++abi1-10:amd64 (1:10.0.0-4ubuntu1) …
Setting up gdbserver (9.2-0ubuntu1~20.04.1) …
Setting up libsss-nss-idmap0 (2.2.3-3ubuntu0.8) …
Setting up libsasl2-modules-gssapi-mit:amd64 (2.1.27+dfsg-2ubuntu0.1) …
Setting up libcc1-0:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libc++1-10:amd64 (1:10.0.0-4ubuntu1) …
Setting up gdb (9.2-0ubuntu1~20.04.1) …
Setting up libc++1:amd64 (1:10.0-50~exp1) …
Setting up mssql-server (15.0.4198.2-10) …
 
+————————————————————–+
Please run ‘sudo /opt/mssql/bin/mssql-conf setup’
to complete the setup of Microsoft SQL Server
+————————————————————–+
 
Processing triggers for man-db (2.9.1-1) …
Processing triggers for libc-bin (2.31-0ubuntu9.7) …
root@vkk-sql:~#

Paket kurulumu tamamlandıktan sonra, mssql-conf kurulumunu çalıştırınız, bu komut ile SQL Server sürümü ve SA hesabı için parola tanımlayabilirsiniz.

SQL SA hesabı için güçlü bir parola belirlediğinizden emin olun (Büyük ve küçük harfler, 10 tabanlı rakamlar ve/veya alfasayısal olmayan simgeler dahil olmak üzere en az 8 karakter kullanılmalıdır).

sudo /opt/mssql/bin/mssql-conf setup

SQL Server yapılandırması tamamlandıktan sonra SQL Server’in servislerin çalıştığını doğrulayınız.

systemctl status mssql-server.service

SSMS aracı ile uzaktan bağlanmayı planlıyorsanız, güvenlik duvarınızda SQL Server TCP bağlantı noktasını (TCP-1433) açmanız gerekecektir bu işlem için aşağıdaki komutu çalıştırabilirsiniz.

sudo ufw allow 1433
sudo ufw enable

MSSQL Tools ve unixODBC plugin kurulumu için aşağıdaki komutları sırasına uygun olarak çalıştırınız.

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –

curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

sudo apt update

sudo ACCEPT_EULA=Y apt install mssql-tools unixodbc-dev

Bu kurulumun çıktısı aşağıdaki gibidir.

root@vkk-sql:~#
root@vkk-sql:~# curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   983  100   983    0     0   1806      0 –:–:– –:–:– –:–:–  1803
OK
root@vkk-sql:~# curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100    89  100    89    0     0    185      0 –:–:– –:–:– –:–:–   185
deb [arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/20.04/prod focal main
root@vkk-sql:~# sudo apt update
Hit:1 http://archive.ubuntu.com/ubuntu focal InRelease
Get:2 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB]
Hit:3 https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal InRelease
Get:4 https://packages.microsoft.com/ubuntu/20.04/prod focal InRelease [10.5 kB]
Get:5 https://packages.microsoft.com/ubuntu/20.04/prod focal/main arm64 Packages [25.0 kB]
Get:6 https://packages.microsoft.com/ubuntu/20.04/prod focal/main armhf Packages [20.5 kB]
Get:7 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 Packages [151 kB]
Get:8 http://archive.ubuntu.com/ubuntu focal-backports InRelease [108 kB]
Hit:9 http://archive.ubuntu.com/ubuntu focal-security InRelease
Fetched 429 kB in 2s (279 kB/s)
Reading package lists… Done
Building dependency tree
Reading state information… Done
1 package can be upgraded. Run ‘apt list –upgradable’ to see it.
root@vkk-sql:~# sudo ACCEPT_EULA=Y apt install mssql-tools unixodbc-dev
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following additional packages will be installed:
  autoconf automake autotools-dev binutils binutils-common binutils-x86-64-linux-gnu cpp cpp-9 gcc gcc-9 gcc-9-base libasan5 libbinutils libc-dev-bin libc6-dev libcrypt-dev libctf-nobfd0 libctf0 libgcc-9-dev libgomp1 libisl22 libitm1
  liblsan0 libltdl-dev libmpc3 libodbc1 libquadmath0 libtool libtsan0 libubsan1 linux-libc-dev m4 manpages-dev msodbcsql17 odbcinst odbcinst1debian2 unixodbc
Suggested packages:
  autoconf-archive gnu-standards autoconf-doc gettext binutils-doc cpp-doc gcc-9-locales gcc-multilib make flex bison gcc-doc gcc-9-multilib gcc-9-doc glibc-doc libtool-doc unixodbc-bin gfortran | fortran95-compiler gcj-jdk m4-doc
The following NEW packages will be installed:
  autoconf automake autotools-dev binutils binutils-common binutils-x86-64-linux-gnu cpp cpp-9 gcc gcc-9 gcc-9-base libasan5 libbinutils libc-dev-bin libc6-dev libcrypt-dev libctf-nobfd0 libctf0 libgcc-9-dev libgomp1 libisl22 libitm1
  liblsan0 libltdl-dev libmpc3 libodbc1 libquadmath0 libtool libtsan0 libubsan1 linux-libc-dev m4 manpages-dev msodbcsql17 mssql-tools odbcinst odbcinst1debian2 unixodbc unixodbc-dev
0 upgraded, 39 newly installed, 0 to remove and 1 not upgraded.
Need to get 37.0 MB of archives.
After this operation, 159 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://archive.ubuntu.com/ubuntu focal/main amd64 m4 amd64 1.4.18-4 [199 kB]
Get:2 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 libodbc1 amd64 2.3.7 [511 kB]
Get:3 http://archive.ubuntu.com/ubuntu focal/main amd64 autoconf all 2.69-11.1 [321 kB]
Get:4 http://archive.ubuntu.com/ubuntu focal/main amd64 autotools-dev all 20180224.1 [39.6 kB]
Get:5 http://archive.ubuntu.com/ubuntu focal/main amd64 automake all 1:1.16.1-4ubuntu6 [522 kB]
Get:6 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 odbcinst1debian2 amd64 2.3.7 [135 kB]
Get:7 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 binutils-common amd64 2.34-6ubuntu1.3 [207 kB]
Get:8 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 odbcinst amd64 2.3.7 [12.0 kB]
Get:9 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 unixodbc amd64 2.3.7 [19.6 kB]
Get:10 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 msodbcsql17 amd64 17.9.1.1-1 [744 kB]
Get:11 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libbinutils amd64 2.34-6ubuntu1.3 [474 kB]
Get:12 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libctf-nobfd0 amd64 2.34-6ubuntu1.3 [47.4 kB]
Get:13 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libctf0 amd64 2.34-6ubuntu1.3 [46.6 kB]
Get:14 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 binutils-x86-64-linux-gnu amd64 2.34-6ubuntu1.3 [1,613 kB]
Get:15 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 binutils amd64 2.34-6ubuntu1.3 [3,380 B]
Get:16 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 gcc-9-base amd64 9.4.0-1ubuntu1~20.04.1 [19.4 kB]
Get:17 http://archive.ubuntu.com/ubuntu focal/main amd64 libisl22 amd64 0.22.1-1 [592 kB]
Get:18 http://archive.ubuntu.com/ubuntu focal/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB]
Get:19 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 cpp-9 amd64 9.4.0-1ubuntu1~20.04.1 [7,500 kB]
Get:20 http://archive.ubuntu.com/ubuntu focal/main amd64 cpp amd64 4:9.3.0-1ubuntu2 [27.6 kB]
Get:21 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libgomp1 amd64 10.3.0-1ubuntu1~20.04 [102 kB]
Get:22 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libitm1 amd64 10.3.0-1ubuntu1~20.04 [26.2 kB]
Get:23 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libasan5 amd64 9.4.0-1ubuntu1~20.04.1 [2,751 kB]
Get:24 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 liblsan0 amd64 10.3.0-1ubuntu1~20.04 [835 kB]
Get:25 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libtsan0 amd64 10.3.0-1ubuntu1~20.04 [2,009 kB]
Get:26 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libubsan1 amd64 10.3.0-1ubuntu1~20.04 [784 kB]
Get:27 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libquadmath0 amd64 10.3.0-1ubuntu1~20.04 [146 kB]
Get:28 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libgcc-9-dev amd64 9.4.0-1ubuntu1~20.04.1 [2,359 kB]
Get:29 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 gcc-9 amd64 9.4.0-1ubuntu1~20.04.1 [8,274 kB]
Get:30 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 mssql-tools amd64 17.9.1.1-1 [211 kB]
Get:31 http://archive.ubuntu.com/ubuntu focal/main amd64 gcc amd64 4:9.3.0-1ubuntu2 [5,208 B]
Get:32 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libc-dev-bin amd64 2.31-0ubuntu9.7 [71.6 kB]
Get:33 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 linux-libc-dev amd64 5.4.0-109.123 [1,111 kB]
Get:34 http://archive.ubuntu.com/ubuntu focal/main amd64 libcrypt-dev amd64 1:4.4.10-10ubuntu4 [104 kB]
Get:35 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libc6-dev amd64 2.31-0ubuntu9.7 [2,518 kB]
Get:36 http://archive.ubuntu.com/ubuntu focal/main amd64 libltdl-dev amd64 2.4.6-14 [162 kB]
Get:37 http://archive.ubuntu.com/ubuntu focal/main amd64 libtool all 2.4.6-14 [161 kB]
Get:38 http://archive.ubuntu.com/ubuntu focal/main amd64 manpages-dev all 5.05-1 [2,266 kB]
Get:39 https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 unixodbc-dev amd64 2.3.7 [37.1 kB]
Fetched 37.0 MB in 19s (1,912 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages …
Selecting previously unselected package m4.
(Reading database … 72549 files and directories currently installed.)
Preparing to unpack …/00-m4_1.4.18-4_amd64.deb …
Unpacking m4 (1.4.18-4) …
Selecting previously unselected package autoconf.
Preparing to unpack …/01-autoconf_2.69-11.1_all.deb …
Unpacking autoconf (2.69-11.1) …
Selecting previously unselected package autotools-dev.
Preparing to unpack …/02-autotools-dev_20180224.1_all.deb …
Unpacking autotools-dev (20180224.1) …
Selecting previously unselected package automake.
Preparing to unpack …/03-automake_1%3a1.16.1-4ubuntu6_all.deb …
Unpacking automake (1:1.16.1-4ubuntu6) …
Selecting previously unselected package binutils-common:amd64.
Preparing to unpack …/04-binutils-common_2.34-6ubuntu1.3_amd64.deb …
Unpacking binutils-common:amd64 (2.34-6ubuntu1.3) …
Selecting previously unselected package libbinutils:amd64.
Preparing to unpack …/05-libbinutils_2.34-6ubuntu1.3_amd64.deb …
Unpacking libbinutils:amd64 (2.34-6ubuntu1.3) …
Selecting previously unselected package libctf-nobfd0:amd64.
Preparing to unpack …/06-libctf-nobfd0_2.34-6ubuntu1.3_amd64.deb …
Unpacking libctf-nobfd0:amd64 (2.34-6ubuntu1.3) …
Selecting previously unselected package libctf0:amd64.
Preparing to unpack …/07-libctf0_2.34-6ubuntu1.3_amd64.deb …
Unpacking libctf0:amd64 (2.34-6ubuntu1.3) …
Selecting previously unselected package binutils-x86-64-linux-gnu.
Preparing to unpack …/08-binutils-x86-64-linux-gnu_2.34-6ubuntu1.3_amd64.deb …
Unpacking binutils-x86-64-linux-gnu (2.34-6ubuntu1.3) …
Selecting previously unselected package binutils.
Preparing to unpack …/09-binutils_2.34-6ubuntu1.3_amd64.deb …
Unpacking binutils (2.34-6ubuntu1.3) …
Selecting previously unselected package gcc-9-base:amd64.
Preparing to unpack …/10-gcc-9-base_9.4.0-1ubuntu1~20.04.1_amd64.deb …
Unpacking gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.1) …
Selecting previously unselected package libisl22:amd64.
Preparing to unpack …/11-libisl22_0.22.1-1_amd64.deb …
Unpacking libisl22:amd64 (0.22.1-1) …
Selecting previously unselected package libmpc3:amd64.
Preparing to unpack …/12-libmpc3_1.1.0-1_amd64.deb …
Unpacking libmpc3:amd64 (1.1.0-1) …
Selecting previously unselected package cpp-9.
Preparing to unpack …/13-cpp-9_9.4.0-1ubuntu1~20.04.1_amd64.deb …
Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.1) …
Selecting previously unselected package cpp.
Preparing to unpack …/14-cpp_4%3a9.3.0-1ubuntu2_amd64.deb …
Unpacking cpp (4:9.3.0-1ubuntu2) …
Selecting previously unselected package libgomp1:amd64.
Preparing to unpack …/15-libgomp1_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libgomp1:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libitm1:amd64.
Preparing to unpack …/16-libitm1_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libitm1:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libasan5:amd64.
Preparing to unpack …/17-libasan5_9.4.0-1ubuntu1~20.04.1_amd64.deb …
Unpacking libasan5:amd64 (9.4.0-1ubuntu1~20.04.1) …
Selecting previously unselected package liblsan0:amd64.
Preparing to unpack …/18-liblsan0_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking liblsan0:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libtsan0:amd64.
Preparing to unpack …/19-libtsan0_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libtsan0:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libubsan1:amd64.
Preparing to unpack …/20-libubsan1_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libubsan1:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libquadmath0:amd64.
Preparing to unpack …/21-libquadmath0_10.3.0-1ubuntu1~20.04_amd64.deb …
Unpacking libquadmath0:amd64 (10.3.0-1ubuntu1~20.04) …
Selecting previously unselected package libgcc-9-dev:amd64.
Preparing to unpack …/22-libgcc-9-dev_9.4.0-1ubuntu1~20.04.1_amd64.deb …
Unpacking libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.1) …
Selecting previously unselected package gcc-9.
Preparing to unpack …/23-gcc-9_9.4.0-1ubuntu1~20.04.1_amd64.deb …
Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.1) …
Selecting previously unselected package gcc.
Preparing to unpack …/24-gcc_4%3a9.3.0-1ubuntu2_amd64.deb …
Unpacking gcc (4:9.3.0-1ubuntu2) …
Selecting previously unselected package libc-dev-bin.
Preparing to unpack …/25-libc-dev-bin_2.31-0ubuntu9.7_amd64.deb …
Unpacking libc-dev-bin (2.31-0ubuntu9.7) …
Selecting previously unselected package linux-libc-dev:amd64.
Preparing to unpack …/26-linux-libc-dev_5.4.0-109.123_amd64.deb …
Unpacking linux-libc-dev:amd64 (5.4.0-109.123) …
Selecting previously unselected package libcrypt-dev:amd64.
Preparing to unpack …/27-libcrypt-dev_1%3a4.4.10-10ubuntu4_amd64.deb …
Unpacking libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) …
Selecting previously unselected package libc6-dev:amd64.
Preparing to unpack …/28-libc6-dev_2.31-0ubuntu9.7_amd64.deb …
Unpacking libc6-dev:amd64 (2.31-0ubuntu9.7) …
Selecting previously unselected package libltdl-dev:amd64.
Preparing to unpack …/29-libltdl-dev_2.4.6-14_amd64.deb …
Unpacking libltdl-dev:amd64 (2.4.6-14) …
Selecting previously unselected package libodbc1:amd64.
Preparing to unpack …/30-libodbc1_2.3.7_amd64.deb …
Unpacking libodbc1:amd64 (2.3.7) …
Selecting previously unselected package libtool.
Preparing to unpack …/31-libtool_2.4.6-14_all.deb …
Unpacking libtool (2.4.6-14) …
Selecting previously unselected package manpages-dev.
Preparing to unpack …/32-manpages-dev_5.05-1_all.deb …
Unpacking manpages-dev (5.05-1) …
Selecting previously unselected package odbcinst1debian2:amd64.
Preparing to unpack …/33-odbcinst1debian2_2.3.7_amd64.deb …
Unpacking odbcinst1debian2:amd64 (2.3.7) …
Selecting previously unselected package odbcinst.
Preparing to unpack …/34-odbcinst_2.3.7_amd64.deb …
Unpacking odbcinst (2.3.7) …
Selecting previously unselected package unixodbc.
Preparing to unpack …/35-unixodbc_2.3.7_amd64.deb …
Unpacking unixodbc (2.3.7) …
Selecting previously unselected package msodbcsql17.
Preparing to unpack …/36-msodbcsql17_17.9.1.1-1_amd64.deb …
Unpacking msodbcsql17 (17.9.1.1-1) …
Selecting previously unselected package mssql-tools.
Preparing to unpack …/37-mssql-tools_17.9.1.1-1_amd64.deb …
Unpacking mssql-tools (17.9.1.1-1) …
Selecting previously unselected package unixodbc-dev.
Preparing to unpack …/38-unixodbc-dev_2.3.7_amd64.deb …
Unpacking unixodbc-dev (2.3.7) …
Setting up manpages-dev (5.05-1) …
Setting up binutils-common:amd64 (2.34-6ubuntu1.3) …
Setting up linux-libc-dev:amd64 (5.4.0-109.123) …
Setting up libctf-nobfd0:amd64 (2.34-6ubuntu1.3) …
Setting up m4 (1.4.18-4) …
Setting up libgomp1:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up autotools-dev (20180224.1) …
Setting up libquadmath0:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libmpc3:amd64 (1.1.0-1) …
Setting up libodbc1:amd64 (2.3.7) …
Setting up autoconf (2.69-11.1) …
Setting up libubsan1:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libcrypt-dev:amd64 (1:4.4.10-10ubuntu4) …
Setting up libisl22:amd64 (0.22.1-1) …
Setting up libbinutils:amd64 (2.34-6ubuntu1.3) …
Setting up libc-dev-bin (2.31-0ubuntu9.7) …
Setting up liblsan0:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libitm1:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up gcc-9-base:amd64 (9.4.0-1ubuntu1~20.04.1) …
Setting up libtsan0:amd64 (10.3.0-1ubuntu1~20.04) …
Setting up libctf0:amd64 (2.34-6ubuntu1.3) …
Setting up automake (1:1.16.1-4ubuntu6) …
update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode
Setting up libltdl-dev:amd64 (2.4.6-14) …
Setting up libasan5:amd64 (9.4.0-1ubuntu1~20.04.1) …
Setting up cpp-9 (9.4.0-1ubuntu1~20.04.1) …
Setting up libc6-dev:amd64 (2.31-0ubuntu9.7) …
Setting up binutils-x86-64-linux-gnu (2.34-6ubuntu1.3) …
Setting up binutils (2.34-6ubuntu1.3) …
Setting up libgcc-9-dev:amd64 (9.4.0-1ubuntu1~20.04.1) …
Setting up cpp (4:9.3.0-1ubuntu2) …
Setting up gcc-9 (9.4.0-1ubuntu1~20.04.1) …
Setting up libtool (2.4.6-14) …
Setting up gcc (4:9.3.0-1ubuntu2) …
Setting up odbcinst1debian2:amd64 (2.3.7) …
Setting up odbcinst (2.3.7) …
Setting up unixodbc (2.3.7) …
Setting up msodbcsql17 (17.9.1.1-1) …
Setting up unixodbc-dev (2.3.7) …
Setting up mssql-tools (17.9.1.1-1) …
Processing triggers for install-info (6.7.0.dfsg.2-5) …
Processing triggers for libc-bin (2.31-0ubuntu9.7) …
Processing triggers for man-db (2.9.1-1) …
root@vkk-sql:~#

MS SQL binary dosyaları için PATH’in yapılandırılması için aşağıdaki komutları sırası ile çalıştırınız.

echo ‘export PATH=”$PATH:/opt/mssql-tools18/bin”‘ >> ~/.bash_profile

echo ‘export PATH=”$PATH:/opt/mssql-tools18/bin”‘ >> ~/.bashrc

source ~/.bashrc

Linux işletim sistemi üzerine kurulan MS SQL Server 2019’un komut satırı araçları sqlcmd ile birlikte gelir. Azure Cloud ortamındaki SQL ‘de dahil olmak üzere yerel ve uzak SQL Server Instance’a bağlanmanıza olanak tanıyan SQL Server komut satırı aracı ile Linux üzerine kurduğumuz SQL Server sürümünü ve versiyon bilgisini sorgulamak için aşağıdaki komutu kullanabilirsiniz.

sqlcmd -S localhost -C -U SA -Q “SELECT @@VERSION”
Paylaş:
ÖNCEKİ YAZI
Microsoft SQL Server 2019 CU (Cumulative Update) Güncellemesi
SONRAKİ GÖNDERİ
Microsoft SQL Server’da Instance Kavramı