|
|
| (6 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| Catatan tentang [[MSSQL Server]] ini sementara di simpan disini dulu.
| | MSSQL Server ini penulis install di dalam Docker pada server Hewlett Packard Enterprise Proliant ML110 Gen10 dengan Operating System Linux Ubuntu 20.04 LTS Server, sudah di install Docker, Compose dan Portainer. |
| | | ==Install MSSQL Server== |
| Nanti akan penulis pindahkan di catatan terpisah karena MSSQL Server merupakan produk dari Microsoft yang pada dasarkan berjalan di Sistem Operasi Windows.
| | Siapkan folder kerja |
| | |
| Namun karena banyak yang memiliki ilmu dan membagikan kreatifitas mereka akhirnya MSSQL Server dapat dijalankan di Sistem Operasi Linux khusus dengan basis OS Ubuntu yang tentukan hanya dapat dijalankan melalui [[Docker]].
| |
| | |
| ==Instalasi== | |
| Setelah instalasi docker di Ubuntu, siapkan folder kerja ~/docker/mssql :
| |
| mkdir ~/docker/mssql -p | | mkdir ~/docker/mssql -p |
| Set owner folder kerja : | | Set chown pada folder kerja |
| chown "$USER":"$USER" ~/docker -R | | sudo chown "$USER":"$USER" ~/docker -R |
| Izinkan container untuk folder kerja : | | Izinkan Container untuk menulis pada folder kerja |
| chmod a+rwx -R ~/docker/mssql | | sudo chmod a+rwx -R ~/docker/mssql |
| | | Jalankan Container Docker SQL Server dengan persiten data |
| Contoh berikut penulis menggunakan MSSQL 2017 :
| | docker run -d --name mssql -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='Setrong$ecur3!' -v ~/docker/mssql:/var/opt/mssql -p 1433:1433 --restart unless-stopped mcr.microsoft.com/mssql/server |
| docker run -d --name mssql -e ACCEPT_UELA=Y -e MSSSQL_SA_PASSWORD='Strong!Password' -v ~/docker/mssql:/var/opt/mssql -p 1443:1443 --restart unless-stopped -d mcr.microsoft.com/mssql/server:2017-latest | | Tunggu sampai proses pull selesai. |
| | | ==Test dan jalankan MSSQL Server== |
| *** Pre Instalasi
| | Koneksi ke database melalui sqlcmd |
| Sebelum penulis melakukan instalasi di PC dengan Operatong System Ubuntu, penulis mencoba menginstall MSSQL Server di dalam Docker Armbian Linux dengan basis Debian.
| | Authentikasi password SA sesuai dengan konfigurasi pada docker run |
| Instalasi sepertinya berhasil membuat container namun tidak mendapatkan IP dan port, sehingga tidak bisa di akses baik melalui Azure Data Studio atau aplikasi manajemen database lainnya.
| | docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -U SA |
| | | Dimintan untuk memasukkan password |
| ==Alternatif Install SQL Server== | | Password: <password_sesuai_dengan_docker_run> |
| ===Clone systemd image===
| | Cek Version : |
| sudo docker run -d --name linuxamination --privileged -v /sys/fs/cgroup:/sys/fs/cgroup:ro jrei/systemd-ubuntu:20.04 | | 1> select @@version; |
| ===Masuk ke dalam container===
| | 2> go |
| sudo docker exec -it linuxamination bash | | Hasilnya : |
| ===Jalankan Command di dalam container===
| | ---------------------------------------------------------------------------------------------------------- |
| apt update | | Microsoft SQL Server 2022 (RTM-CU8) (KB5029666) - 16.0.4075.1 (X64) |
| ===Install beberape paket tambahan===
| | Aug 23 2023 14:04:50 |
| apt install wget curl sudo software-properties-common gnupg2 | | Copyright (C) 2022 Microsoft Corporation |
| ===Tambahkan Key Microsoft ke dalam apt repository===
| | Developer Edition (64-bit) on Linux (Ubuntu 20.04.6 LTS) <X64> |
| sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
| |
| akan muncul
| |
| OK
| |
| kemudian jalankan command berikut :
| |
| sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"
| |
| ===Lakukan update lagi===
| |
| apt update
| |
| ===Jalankan proses install MSSQL Server===
| |
| sudo apt install mssql-server
| |
| ===Konfigurasi Mssql server===
| |
| jalankan command berikut :
| |
| sudo /opt/mssql/bin/mssql-conf setup
| |
| | |
| ##############################################################....]
| |
| to complete the setup of Microsoft SQL Server
| |
| +--------------------------------------------------------------+
| |
| | | |
| Processing triggers for libc-bin (2.31-0ubuntu9.9) ... | | (1 rows affected) |
| root@6961e0d2546a:/# sudo /opt/mssql/bin/mssql-conf setup
| | 1> |
| Choose an edition of SQL Server:
| | MSSQL Server siap digunakan menggunakan Navicat, Asure atau yang lainnya. |
| 1) Evaluation (free, no production use rights, 180-day limit)
| |
| 2) Developer (free, no production use rights)
| |
| 3) Express (free)
| |
| 4) Web (PAID)
| |
| 5) Standard (PAID)
| |
| 6) Enterprise (PAID) - CPU Core utilization restricted to 20 physical/40 hyperthreaded
| |
| 7) Enterprise Core (PAID) - CPU Core utilization up to Operating System Maximum
| |
| 8) I bought a license through a retail sales channel and have a product key to enter.
| |
|
| |
| Details about editions can be found at
| |
| https://go.microsoft.com/fwlink/?LinkId=2109348
| |
|
| |
| Use of PAID editions of this software requires separate licensing through a
| |
| Microsoft Volume Licensing program.
| |
| By choosing a PAID edition, you are verifying that you have the appropriate
| |
| number of licenses in place to install and run this software.
| |
| | |
| Enter your edition(1-8): 3
| |
| (pilih 3)
| |
| | |
| The license terms for this product can be found in
| |
| /usr/share/doc/mssql-server or downloaded from:
| |
| https://go.microsoft.com/fwlink/?LinkId=2104294
| |
|
| |
| The privacy statement can be viewed at:
| |
| https://go.microsoft.com/fwlink/?LinkId=853010
| |
|
| |
| Do you accept the license terms? [Yes/No]: Yes
| |
| (pilih Yes)
| |
| Enter the SQL Server system administrator password:
| |
| ulangi password yg sama
| |
| Confirm the SQL Server system administrator password:
| |
| Jika berhasil akan muncul :
| |
| Configuring SQL Server...
| |
|
| |
| The licensing PID was successfully processed. The new edition is [Express Edition].
| |
| ForceFlush is enabled for this instance.
| |
| ForceFlush feature is enabled for log durability.
| |
| Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service -> /lib/systemd/system/mssql-server.service.
| |
| Setup has completed successfully. SQL Server is now starting.
| |
| | |
| ===Install MSSQL Tools, dan jalankan di dalam kontainer===
| |
| curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
| |
| hasilnya :
| |
| % Total % Received % Xferd Average Speed Time Time Time Current
| |
| Dload Upload Total Spent Left Speed
| |
| 100 983 100 983 0 0 2488 0 --:--:-- --:--:-- --:--:-- 2488
| |
| OK
| |
MSSQL Server ini penulis install di dalam Docker pada server Hewlett Packard Enterprise Proliant ML110 Gen10 dengan Operating System Linux Ubuntu 20.04 LTS Server, sudah di install Docker, Compose dan Portainer.
Install MSSQL Server[edit]
Siapkan folder kerja
mkdir ~/docker/mssql -p
Set chown pada folder kerja
sudo chown "$USER":"$USER" ~/docker -R
Izinkan Container untuk menulis pada folder kerja
sudo chmod a+rwx -R ~/docker/mssql
Jalankan Container Docker SQL Server dengan persiten data
docker run -d --name mssql -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='Setrong$ecur3!' -v ~/docker/mssql:/var/opt/mssql -p 1433:1433 --restart unless-stopped mcr.microsoft.com/mssql/server
Tunggu sampai proses pull selesai.
Test dan jalankan MSSQL Server[edit]
Koneksi ke database melalui sqlcmd
Authentikasi password SA sesuai dengan konfigurasi pada docker run
docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -U SA
Dimintan untuk memasukkan password
Password: <password_sesuai_dengan_docker_run>
Cek Version :
1> select @@version;
2> go
Hasilnya :
----------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2022 (RTM-CU8) (KB5029666) - 16.0.4075.1 (X64)
Aug 23 2023 14:04:50
Copyright (C) 2022 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 20.04.6 LTS) <X64>
(1 rows affected)
1>
MSSQL Server siap digunakan menggunakan Navicat, Asure atau yang lainnya.
