{"id":106282,"date":"2025-05-20T06:09:00","date_gmt":"2025-05-20T06:09:00","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=106282"},"modified":"2025-04-14T18:40:51","modified_gmt":"2025-04-14T18:40:51","slug":"sql-server-2022-on-ubuntu-24-04-step-by-step","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/sysadmin\/sql-server-2022-on-ubuntu-24-04-step-by-step\/","title":{"rendered":"SQL Server 2022 on Ubuntu 24.04 step by step"},"content":{"rendered":"\n

Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should not be used for production usage and this blog is for educational\/testing purposes only.<\/p>\n\n\n\n

For my installation, I am using an AWS EC2 Ubuntu 24.04 with 2 GB of Ram. 2GB of RAM is the minimum required. This guide is targeted towards people who have installed SQL Server on previous versions of Ubuntu.<\/p>\n\n\n\n

It is not an unknown thing to want to do, as you can see in this thread on learn.microsoft.com<\/a>. So I went out to see what I would need to do. This guide contains the steps I went through.<\/p>\n\n\n\n

There are two major things I will cover installing. SQL Server itself, and then PowerShell Core.<\/p>\n\n\n\n

Installing SQL Server Engine<\/h2>\n\n\n\n

Step 1 Update system packages <\/h3>\n\n\n\n

To ensure that the host system is up-to-date.<\/p>\n\n\n\n

sudo apt update && sudo apt upgrade -y<\/pre><\/div>\n\n\n\n
Step 2: Import the Microsoft SQL Server GPG Key<\/h3>\n\n\n\n
This is the Gnu Privacy Guard key that will be used to encrypt and decrypt files in the install.<\/p>\n\n\n\n
wget -qO- https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo tee \/etc\/apt\/trusted.gpg.d\/microsoft.asc<\/pre><\/div>\n\n\n\n
Step 3: Add the Microsoft SQL Server Repository<\/h3>\n\n\n\n
As I said before , Ubuntu 24.04 is still not supported by Microsoft, therefore we can use the Ubuntu 22.04 repository for that because it is compatible.<\/p>\n\n\n\n
sudo add-apt-repository \"$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/22.04\/mssql-server-2022.list<\/em>)\"<\/pre><\/div>\n\n\n\n
After that do the system refresh again.<\/p>\n\n\n\n
sudo apt update<\/pre><\/div>\n\n\n\n
Now we need to install these packages to SQL server works because as of incompatibly with Ubuntu 24.04.<\/p>\n\n\n\n
wget http:\/\/archive.ubuntu.com\/ubuntu\/pool\/main\/o\/openldap\/libldap-2.5-0_2.5.11+dfsg-1~exp1ubuntu3_amd64.deb\n\nsudo dpkg -i libldap-2.5-0_2.5.11+dfsg-1~exp1ubuntu3_amd64.deb\n\nsudo apt install -y libcurl4 libssl-dev libgnutls30<\/pre><\/div>\n\n\n\n
Step 4: Install and Configure Microsoft SQL Server <\/h3>\n\n\n\n
The next few steps will do the installation steps.<\/p>\n\n\n\n
Step 4a: Execute the installation<\/h4>\n\n\n\n
sudo apt install mssql-server\n\nsudo  \/opt\/mssql\/bin\/mssql-conf setup<\/pre><\/div>\n\n\n\n
Step 4b: Select an edition and set a sa password<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/strong>\n<\/p>\n\n\n\n
Most likely, you will select the developer edition (2)<\/strong> that has all features from the enterprise but you cannot use in production environments. This would likely be the only version you would want to install on the unsupported version of Linux.<\/p>\n\n\n\n
After that will prompt you to choose the language.<\/p>\n\n\n\n
\"A<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
The service is started automatically but you can check typing<\/p>\n\n\n\n
systemctl status mssql-server --no-pager -l<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/em>\n<\/p>\n\n\n\n
Step 5: Install SQL Server Command-Line Tools (sqlcmd and bcp)<\/h3>\n\n\n\n
Add the Microsoft repository for SQL Server tools<\/p>\n\n\n\n
sudo add-apt-repository \"$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/22.04\/prod.list)\"<\/pre><\/div>\n\n\n\n
And update again:<\/p>\n\n\n\n
sudo apt-get update<\/pre><\/div>\n\n\n\n
Next install mssql-tools:<\/p>\n\n\n\n
sudo apt install mssql-tools unixodbc-dev<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/em>\n<\/p>\n\n\n\n
Next select <yes><\/strong> for the license terms:<\/p>\n\n\n\n
\"A<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
And <yes> again for the next license terms (you can see in the title they are for different things.)<\/p>\n\n\n\n
\"A<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
Now let\u00b4s add the mssql-tools to the path variable. This way you can call sqlcmd from whatever you be<\/p>\n\n\n\n
echo 'export PATH=\"$PATH:\/opt\/mssql-tools\/bin\"' >> ~\/.bash_profile\n\nsource ~\/.bash_profile<\/pre><\/div>\n\n\n\n
Step 6: Configure the Firewall <\/h3>\n\n\n\n
Let\u00b4s open the port 1433 to access our SQL Server remotely\u201d<\/p>\n\n\n\n
sudo ufw allow 1433\/tcp \n\nsudo ufw reload<\/pre><\/div>\n\n\n\n
Step 7 \u2013 Open the port 1433 on AWS<\/h3>\n\n\n\n
Next, in the AWS interface for your VM, select the Security tab:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n    <\/strong>\n<\/p>\n\n\n\n
Select the security group<\/p>\n\n\n\n
\"A<\/figure>\n\n\n\n
<\/strong>\n<\/p>\n\n\n\n
Click on Edit Inbound Rules and click in the add Rule box<\/p>\n\n\n\n
Select the MSSQL in the combo box and 0.0.0.0\/0 to open the port 1433:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
Step 8 \u2013 Enable SQL Server agent<\/h3>\n\n\n\n
If you need the SQL Server Agent, this will enable it for use:<\/em><\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf set sqlagent.enabled true\n\nsudo systemctl restart mssql-server<\/pre><\/div>\n\n\n\n
Now you can just connect over the SSMS using the public IPv4 Adress and sa<\/code> password.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
Or you can use sqlcmd<\/p>\n\n\n\n
sqlcmd -S localhost -U sa -P '<password>'<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/em>\n<\/p>\n\n\n\n
And if we refresh the SSMS:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
There are plenty of configurations that you can apply to your instance . To check the list and what is use (or do it in the SSMS)<\/p>\n\n\n\n
sudo \/opt\/mssql\/bin\/mssql-conf list<\/pre><\/div>\n\n\n\n
Installing PowerShell Core <\/h2>\n\n\n\n
Next we will install PowerShell Core.<\/p>\n\n\n\n
Step 1 \u2013 Download the required installable files for PowerShell<\/h3>\n\n\n\n
wget -q https:\/\/packages.microsoft.com\/config\/ubuntu\/$(lsb_release -rs)\/packages-microsoft-prod.deb -O packages-microsoft-prod.deb<\/pre><\/div>\n\n\n\n
Step 2 \u2013 install the files<\/h3>\n\n\n\n
Sudo dpkg -i packages-microsoft-prod.deb<\/pre><\/div>\n\n\n\n
Step 3- Update the repository with the latest changes or updates from the Microsoft Updates CDN related to \u2018Powershell\u2019 commands or features updates and install \u2018Powershell\u2019 <\/strong><\/p>\n\n\n\n
Sudo apt-get update -y\n\nSudo apt-get install powershell -y<\/pre><\/div>\n\n\n\n
Then it is just call Powershell and test it out.<\/strong><\/p>\n\n\n\n
pwsh<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
Extra: Installing SQL Server module on Powershell<\/h3>\n\n\n\n
To install the sql server module it is just (on Powershell terminal)<\/p>\n\n\n\n
install-module sqlserver<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n  \n<\/p>\n\n\n\n
And now we can use the sql server module<\/p>\n\n\n\n
To check whit cmdlets you can use :<\/p>\n\n\n\n
get-command -Module sqlserver<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/em>\n<\/p>\n\n\n\n
If you want to use your favorite PowerShell library, like dbatools, you can now install it. For example, for dbatools:<\/p>\n\n\n\n
Install-module dbatools<\/pre><\/div>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Now you should have a fully operational version of SQL Server running on the new version of Ubuntu. As a reminder, this is not supported yet, and should only be used for educational\/testing purposes.<\/p>\n","protected":false},"excerpt":{"rendered":"
Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should not be used for production usage and this blog is for educational\/testing purposes only. For my installation, I am using an AWS EC2 Ubuntu 24.04 with 2 GB of Ram. 2GB of RAM is the……<\/p>\n","protected":false},"author":221715,"featured_media":106300,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143524,8],"tags":[4878,4151],"coauthors":[6819],"class_list":["post-106282","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-sysadmin","tag-linux","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/106282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221715"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=106282"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/106282\/revisions"}],"predecessor-version":[{"id":106301,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/106282\/revisions\/106301"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/106300"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=106282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=106282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=106282"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=106282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}