Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for AWS: Microsoft SQL Server 2022 on Linux with Multi-AZ Resiliency > Install SQL Server 2022
This section describes the installation process on the first instance of our cluster, SQLNODE-1a followed by the other cluster instances.
These steps presume that the repositories for the packages have already been set up, and SQL Server is ready to be installed currently.
You can set up SQL Server on Linux with mssql-conf by running the following code sample:
root@node-1a:/home/ubuntu# sudo /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.
Enter your edition(1-10): X
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
Do you accept the license terms? [Yes/No]:y
Enter the SQL Server system administrator password:
Confirm the SQL Server system administrator password:
Configuring SQL Server...
The licensing PID was successfully processed. The new edition is [Enterprise Evaluation 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.
root@node-1a:/home/ubuntu# systemctl status mssql-server --no-pager
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2024-03-12 11:19:28 UTC; 1 min 18 s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 313258 (sqlservr)
Tasks: 263
Memory: 933.0M
CPU: 6.319 s
CGroup: /system.slice/mssql-server.service
├─313258 /opt/mssql/bin/sqlservr
└─313340 /opt/mssql/bin/sqlservr
root@sqlnode-1a:/home/ubuntu# sudo apt-get update
root@sqlnode-1a:/home/ubuntu# sudo apt-get install mssql-tools18 unixodbc-dev
root@sqlnode-1a:/home/ubuntu# sudo apt-get update
root@sqlnode-1a:/home/ubuntu# sudo apt-get install mssql-tools18
Connect to the SQL server
root@sqlnode-1a:/home/ubuntu# sqlcmd -C -S localhost -U sa -P Dellam123!
1> sp_databases
2> go
DATABASE_NAME DATABASE_SIZE REMARKS
-------------------------------------------------------------------------------------------------------------------------------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
master 6592 NULL
model 16384 NULL
msdb 16704 NULL
tempdb 73728 NULL
Similarly, install the SQL server on the other two instances.
For more information, see Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Learn.