inchirags@gmail.com Chirag's SQL Server DBA Tutorial https://www.chirags.in
*********************************************************************************************
Install Microsoft SQL Server 2022 in Ubuntu 22.04 LTS
***********************************************************************************************
Install Microsoft SQL Server 2022 in Ubuntu 22.04 LTS.
Before installing and using it, read the license terms carefully below.
If you use it in a production environment, it's not free; you need to buy licenses.
⇒ https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing
Step 1:- Add SQL Server 2022 Repository and install it..
root@mssqlserver:~# wget https://packages.microsoft.com/keys/microsoft.asc -O /etc/apt/keyrings/mssql2022.key
root@mssqlserver:~# wget https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list -O /etc/apt/sources.list.d/mssql-server-2022.list
root@mssqlserver:~# wget https://packages.microsoft.com/config/ubuntu/22.04/prod.list -O /etc/apt/sources.list.d/msprod.list
root@mssqlserver:~# vi /etc/apt/sources.list.d/mssql-server-2022.list
# add setting like follows
deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/mssql-server-2022 jammy main
root@mssqlserver:~# vi /etc/apt/sources.list.d/msprod.list
# add setting like follows
deb [signed-by=/etc/apt/keyrings/mssql2022.key arch=amd64,armhf,arm64] https://packages.microsoft.com/ubuntu/22.04/prod jammy main
root@mssqlserver:~# apt update
root@mssqlserver:~# apt -y install mssql-server mssql-tools unixodbc-dev
# accept the license terms
+---------------------+ Configuring msodbcsql17 +---------------------+
| |
| The license terms for this product can be downloaded from |
| https://aka.ms/odbc17eula and found in |
| /usr/share/doc/msodbcsql17/LICENSE.txt. |
| |
| By choosing 'Yes', you indicate that you accept the license terms. |
| |
| Do you accept the license terms? |
| |
| <Yes> <No> |
| |
+---------------------------------------------------------------------------+
# accept the license terms
+---------------------+ Configuring mssql-tools +---------------------+
| |
| The license terms for this product can be downloaded from |
| http://go.microsoft.com/fwlink/?LinkId=746949 and found in |
| /usr/share/doc/mssql-tools/LICENSE.TXT. |
| |
| By choosing 'Yes', you indicate that you accept the license terms. |
| |
| Do you accept the license terms? |
| |
| <Yes> <No> |
| |
+---------------------------------------------------------------------------+
Step 2:- Run the initial Setup.
root@mssqlserver:~# /opt/mssql/bin/mssql-conf setup
Choose an edition of SQL Server:
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.
9) Standard (Billed through Azure) - Use pay-as-you-go billing through Azure.
10) Enterprise Core (Billed through Azure) - Use pay-as-you-go billing through Azure.
Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=2109348&clcid=0x409
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.
By choosing an edition billed Pay-As-You-Go through Azure, you are verifying that the server and SQL Server will be connected to Azure by installing the management agent and Azure extension for SQL Server.
# Select an edition you'd like to use
Enter your edition (1-10): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from: https://aka.ms/useterms
The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409
# Agree to the license
Do you accept the license terms? [Yes/No]: Yes
# set admin password
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...
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.
root@mssqlserver:~# systemctl status mssql-server
* mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor >
Active: active (running) since Fri 2023-11-24 09:28:25 JST; 3min 37s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2308 (sqlservr)
Tasks: 205
Memory: 791.1M
CPU: 5.725s
CGroup: /system.slice/mssql-server.service
+-- 2308 /opt/mssql/bin/sqlservr
+-- 2344 /opt/mssql/bin/sqlservr
root@mssqlserver:~# echo 'export PATH=$PATH:/opt/mssql-tools/bin' > /etc/profile.d/mssql.sh
root@mssqlserver:~# source /etc/profile.d/mssql.sh
Step 3:- Connect to SQL Server to verify it is working..
root@mssqlserver:~# sqlcmd -S localhost -U SA
Password: # admin password you set
# show system databases
1> select name,database_id from sys.databases;
2> go
name database_id
--------------------- -----------
master 1
tempdb 2
model 3
msdb 4
(4 rows affected)
# show system users
1> select name from sysusers;
2> go
name
-------------------------------------
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_ddladmin
db_denydatareader
db_denydatawriter
db_owner
db_securityadmin
dbo
guest
INFORMATION_SCHEMA
public
sys
(16 rows affected)
# show current user
1> select current_user;
2> go
---------------------------------------
dbo
(1 rows affected)
# quit
1> exit
Note: Follow the process shown in the video.
Subscribe and like for more videos:
https://www.youtube.com/@chiragstutorial
Don't forget to, Follow, Like, Share &, Comment
Tutorial Link:
https://www.chirags.in/tutorials/microsoft_sql_server_database_tutorials
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_____________________________________________________________________
Note: All scripts used in this demo will be available in our website https://www.chirags.in
Link will be available in description.
