MSSQL Server + Azure Data Studio Install Using AUR

 

Hi Everyone,

Last Post i documented how i installed Arch Linux the easy way using the archinstall script.

This time i will show how i installed SQL Server and server studio on linux.

sql server is easy to install in Arch by using AUR- Arch User repository.

I recommend using YAY tool to handle the installation of AUR packages as its easy.

before that Ensure the base-devel package group is installed 

pacman -S --needed base-devel

Now i will show you how to install a AUR Package.

First visit AUR site and search for a package, it will auto complete package name parallely when you start typing.

here i will show a demo using a neofetch package install from AUR.

Next Click to copy the git link.

Installing Package manually needs 3 steps,

1. Acquire Build Packages.
2. Run makepkg.
3. Install the setup file.
   

below is the terminal output for same along with commands.

 [mj@mjx ~]$ ls
Desktop  Documents  Downloads  Music  Pictures  Public  Templates  Videos
[mj@mjx ~]$ cd Downloads
[mj@mjx Downloads]$ git clone https://aur.archlinux.org/neofetch-btw.git
Cloning into 'neofetch-btw'...
remote: Enumerating objects: 14, done.
remote: Counting objects: 100% (14/14), done.
remote: Compressing objects: 100% (11/11), done.
remote: Total 14 (delta 3), reused 14 (delta 3), pack-reused 0
Receiving objects: 100% (14/14), 4.36 KiB | 4.36 MiB/s, done.
Resolving deltas: 100% (3/3), done.
[mj@mjx Downloads]$ ls
'Arch Linux'   mj   neofetch-btw
[mj@mjx Downloads]$ cd neofetch-btw
[mj@mjx neofetch-btw]$ ls
PKGBUILD
[mj@mjx neofetch-btw]$ makepkg
==> Making package: neofetch-btw 7.1.0-3 (Sat 11 Jun 2022 12:08:17 AM IST)
==> Checking runtime dependencies...
==> Checking buildtime dependencies...
==> Retrieving sources...
  -> Cloning neofetch-btw git repo...
Cloning into bare repository '/home/mj/Downloads/neofetch-btw/neofetch-btw'...
remote: Enumerating objects: 16716, done.
remote: Total 16716 (delta 0), reused 0 (delta 0), pack-reused 16716
Receiving objects: 100% (16716/16716), 7.32 MiB | 3.80 MiB/s, done.
Resolving deltas: 100% (10163/10163), done.
==> Validating source files with sha256sums...
    neofetch-btw ... Skipped
==> Extracting sources...
  -> Creating working copy of neofetch-btw git repo...
Cloning into 'neofetch-btw'...
done.
Switched to a new branch 'makepkg'
==> Entering fakeroot environment...
==> Starting package()...
==> Tidying install...
  -> Removing libtool files...
  -> Purging unwanted files...
  -> Removing static library files...
  -> Stripping unneeded symbols from binaries and libraries...
  -> Compressing man and info pages...
==> Checking for packaging issues...
==> WARNING: backup entry file not in package : etc/neofetch/config.conf
==> Creating package "neofetch-btw"...
  -> Generating .PKGINFO file...
  -> Generating .BUILDINFO file...
  -> Generating .MTREE file...
  -> Compressing package...
==> Leaving fakeroot environment.
==> Finished making: neofetch-btw 7.1.0-3 (Sat 11 Jun 2022 12:08:24 AM IST)
[mj@mjx neofetch-btw]$ ls
neofetch-btw  neofetch-btw-7.1.0-3-any.pkg.tar.zst  pkg  PKGBUILD  src
[mj@mjx neofetch-btw]$ pacman -U neofetch-btw-7.1.0-3-any.pkg.tar.zst
error: you cannot perform this operation unless you are root.
[mj@mjx neofetch-btw]$ sudo pacman -U neofetch-btw-7.1.0-3-any.pkg.tar.zst
[sudo] password for mj:
Swipe your right middle finger across the fingerprint reader
loading packages...
resolving dependencies...
looking for conflicting packages...
:: neofetch-btw and neofetch are in conflict. Remove neofetch? [y/N] y

Packages (2) neofetch-7.1.0-2 [removal]  neofetch-btw-7.1.0-3

Total Installed Size:  0.37 MiB
Net Upgrade Size:      0.03 MiB

:: Proceed with installation? [Y/n] Y
(1/1) checking keys in keyring                                                                       [###########################################################] 100%
(1/1) checking package integrity                                                                     [###########################################################] 100%
(1/1) loading package files                                                                          [###########################################################] 100%
(1/1) checking for file conflicts                                                                    [###########################################################] 100%
(2/2) checking available disk space                                                                  [###########################################################] 100%
:: Processing package changes...
(1/1) removing neofetch                                                                              [###########################################################] 100%
(1/1) installing neofetch-btw                                                                        [###########################################################] 100%
Optional dependencies for neofetch-btw
    catimg: Display Images
    chafa: Image to text support
    feh: Wallpaper Display
    imagemagick: Image cropping / Thumbnail creation / Take a screenshot [installed]
    jp2a: Display Images
    libcaca: Display Images [installed]
    nitrogen: Wallpaper Display
    w3m: Display Images
    xdotool: See https://github.com/dylanaraps/neofetch/wiki/Images-in-the-terminal
    xorg-xdpyinfo: Resolution detection (Single Monitor) [installed]
    xorg-xprop: Desktop Environment and Window Manager [installed]
    xorg-xrandr: Resolution detection (Multi Monitor + Refresh rates) [installed]
    xorg-xwininfo: See https://github.com/dylanaraps/neofetch/wiki/Images-in-the-terminal
:: Running post-transaction hooks...
(1/2) Arming ConditionNeedsUpdate...
(2/2) Refreshing PackageKit...

And the package is now installed, similarly you can install the YAY package from AUR.
Now that YAY is installed, installing sql server and Azure Data Studio is easy.
Microsoft SQL Server management studio is not available for Linux so it is recommended to install Azure Data studio as an alternative and its available for both windows and Linux platform.
to install MSSQL use below command,
yay -S mssql-server mssql-tools msodbcsql
then run the setup file from opt directory,
sudo /opt/mssql/bin/mssql-conf setup
Remember to select the Developer edition during install to get full featured SQL Server installed.
at the end of install you need to set the Password for login to use from localhost.
next check if sql service is enabled at start up and active by using systemctl.
systemctl status mssql-server.service
if its shows inactive try enable and start.
systemctl enable mssql-server.service
systemctl start mssql-server.service
this completes the MSSQL install, next we need a GUI SQL Server Studio to manage and interact with SQL SERVER.
to install Azure data studio use below command,
yay -S azuredatastudio-bin 

Once the installation is complete you will now be able to see Azure data studio icon in application menu.

once you start the app you are ready to connect to server, i was able to connect to localhost with user name "sa".

 

this concludes the Microsoft SQL Server install on Linux and as far as my experience Azure Data studio has most of the functionality which the SSMS has and its a great alternative for Linux.

I will be posting a simple Load Modify Update delete select queries in next blog soon.

Bye TC!