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.
pacman -S --needed base-devel
Now i will show you how to install a AUR Package.
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,
- Acquire Build Packages.
- Run makepkg.
-
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...
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
Comments
Post a Comment