{"id":12685,"date":"2025-01-21T07:09:41","date_gmt":"2025-01-21T07:09:41","guid":{"rendered":"https:\/\/myprojects.advchaweb.com\/?p=12685"},"modified":"2025-01-21T09:54:28","modified_gmt":"2025-01-21T09:54:28","slug":"install-microsoft-sql-server-2022-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2025\/01\/21\/install-microsoft-sql-server-2022-on-ubuntu-22-04\/","title":{"rendered":"Install Microsoft SQL Server 2022 On Ubuntu 22.04"},"content":{"rendered":"

Ref: https:\/\/learn.microsoft.com\/en-us\/sql\/linux\/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204<\/p>\n

1. Update and upgrade the packages on ubuntu 22.04
\n[codesyntax lang=”bash”]<\/p>\n

sudo apt update\r\nsudo apt upgrade -y<\/pre>\n
[\/codesyntax]<\/p>\n
2. Download the public key, convert from ASCII to GPG format, and write it to the required location:
\n[codesyntax lang=”bash”]<\/p>\n
curl -fsSL https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo gpg --dearmor -o \/usr\/share\/keyrings\/microsoft-prod.gpg<\/pre>\n
[\/codesyntax]<\/p>\n
3. Manually download and register the SQL Server Ubuntu repository:
\n[codesyntax lang=”bash”]<\/p>\n
curl -fsSL https:\/\/packages.microsoft.com\/config\/ubuntu\/22.04\/mssql-server-2022.list | sudo tee \/etc\/apt\/sources.list.d\/mssql-server-2022.list<\/pre>\n
[\/codesyntax]<\/p>\n
4. Run the following commands to install SQL Server:
\n[codesyntax lang=”bash”]<\/p>\n
sudo apt-get update\r\nsudo apt-get install -y mssql-server\r\n...\r\nSetting up libc++abi1-14:amd64 (1:14.0.0-1ubuntu1.1) ...\r\nSetting up libc++1-14:amd64 (1:14.0.0-1ubuntu1.1) ...\r\nSetting up libc++1:amd64 (1:14.0-55~exp2) ...\r\nSetting up mssql-server (16.0.4175.1-3) ...\r\n\r\n+--------------------------------------------------------------+\r\nPlease run 'sudo \/opt\/mssql\/bin\/mssql-conf setup'\r\nto complete the setup of Microsoft SQL Server\r\n+--------------------------------------------------------------+\r\n\r\nProcessing triggers for man-db (2.10.2-1) ...\r\nProcessing triggers for libc-bin (2.35-0ubuntu3.8) ...\r\n<\/pre>\n
[\/codesyntax]<\/p>\n
5. After the package installation finishes, run\u00a0mssql-conf setup<\/code>\u00a0and follow the prompts to set the\u00a0sa<\/code>\u00a0password and choose your edition.
\nJust choose ‘Developer’ version. type 2. My local sa<\/code> password is {my-nick-name-first-uppercase}@123
\n[codesyntax lang=”bash”]<\/p>\n
satria@teddy:~$ sudo \/opt\/mssql\/bin\/mssql-conf setup\r\nChoose an edition of SQL Server:\r\n  1) Evaluation (free, no production use rights, 180-day limit)\r\n  2) Developer (free, no production use rights)\r\n  3) Express (free)\r\n  4) Web (PAID)\r\n  5) Standard (PAID)\r\n  6) Enterprise (PAID) - CPU core utilization restricted to 20 physical\/40 hyperthreaded\r\n  7) Enterprise Core (PAID) - CPU core utilization up to Operating System Maximum\r\n  8) I bought a license through a retail sales channel and have a product key to enter.\r\n  9) Standard (Billed through Azure) - Use pay-as-you-go billing through Azure.\r\n 10) Enterprise Core (Billed through Azure) - Use pay-as-you-go billing through Azure.\r\n\r\nDetails about editions can be found at\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=2109348&clcid=0x409\r\n\r\nUse of PAID editions of this software requires separate licensing through a\r\nMicrosoft Volume Licensing program.\r\nBy choosing a PAID edition, you are verifying that you have the appropriate\r\nnumber of licenses in place to install and run this software.\r\nBy choosing an edition billed Pay-As-You-Go through Azure, you are verifying \r\nthat the server and SQL Server will be connected to Azure by installing the \r\nmanagement agent and Azure extension for SQL Server.\r\n\r\nEnter your edition(1-10): 2\r\nThe license terms for this product can be found in\r\n\/usr\/share\/doc\/mssql-server or downloaded from: https:\/\/aka.ms\/useterms\r\n\r\nThe privacy statement can be viewed at:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=853010&clcid=0x409\r\n\r\nDo you accept the license terms? [Yes\/No]:yes\r\n\r\nEnter the SQL Server system administrator password: \r\nConfirm the SQL Server system administrator password: \r\nConfiguring SQL Server...\r\n\r\nForceFlush is enabled for this instance. \r\nForceFlush feature is enabled for log durability.\r\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/mssql-server.service \u2192 \/lib\/systemd\/system\/mssql-server.service.\r\nSetup has completed successfully. SQL Server is now starting.<\/pre>\n
[\/codesyntax]<\/p>\n
6. Once the configuration is done, verify that the service is running:
\n[codesyntax lang=”bash”]<\/p>\n
systemctl status mssql-server --no-pager<\/pre>\n
[\/codesyntax]<\/p>\n
Install the SQL Server command-line tools (sqlcmd)<\/p>\n
1. Import the public repository GPG keys.
\n[codesyntax lang=”bash”]<\/p>\n
curl https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo tee \/etc\/apt\/trusted.gpg.d\/microsoft.asc<\/pre>\n
[\/codesyntax]<\/p>\n
2. Register the Microsoft Ubuntu repository. For Ubuntu 22.04, use the following command:
\n[codesyntax lang=”bash”]<\/p>\n
curl https:\/\/packages.microsoft.com\/config\/ubuntu\/22.04\/prod.list | sudo tee \/etc\/apt\/sources.list.d\/mssql-release.list<\/pre>\n
[\/codesyntax]<\/p>\n
3. Update the sources list and run the installation command with the unixODBC developer package.
\n[codesyntax lang=”bash”]<\/p>\n
sudo apt-get update\r\nsudo apt-get install mssql-tools18 unixodbc-dev<\/pre>\n
[\/codesyntax]<\/p>\n
To update to the latest version of\u00a0mssql-tools<\/strong>, run the following commands:
\n[codesyntax lang=”bash”]<\/p>\n
sudo apt-get update  \r\nsudo apt-get install mssql-tools18<\/pre>\n
[\/codesyntax]<\/p>\n
4. Add\u00a0\/opt\/mssql-tools18\/bin\/<\/code>\u00a0to your\u00a0PATH<\/code>\u00a0environment variable in a bash shell.<\/p>\n
To make\u00a0sqlcmd<\/strong>\u00a0and\u00a0bcp<\/strong>\u00a0accessible from the bash shell for login sessions, modify your\u00a0PATH<\/code>\u00a0in the\u00a0~\/.bash_profile<\/code>\u00a0file with the following command:
\n[codesyntax lang=”bash”]<\/p>\n
echo 'export PATH=\"$PATH:\/opt\/mssql-tools18\/bin\"' >> ~\/.bash_profile\r\nsource ~\/.bash_profile<\/pre>\n
[\/codesyntax]<\/p>\n
5. Test sqlcmd with ‘sqlcmd -?’
\n[codesyntax lang=”bash”]<\/p>\n
satria@teddy:~$ sqlcmd -?\r\nMicrosoft (R) SQL Server Command Line Tool\r\nVersion 18.4.0001.1 Linux\r\nCopyright (C) 2017 Microsoft Corporation. All rights reserved.\r\n\r\nusage: sqlcmd            [-U login id]          [-P password]\r\n  [-S server or Dsn if -D is provided] \r\n  [-H hostname]          [-E trusted connection]\r\n  ...\r\n  [-G use Microsoft Entra ID for authentication]\r\n  [-? show syntax summary]<\/pre>\n
[\/codesyntax]<\/p>\n
Connect locally. I tried to use : sqlcmd -S localhost -U sa -P your_password
\nbut it showed up this error
\n[codesyntax lang=”bash”]<\/p>\n
satria@teddy:~$ sqlcmd -S localhost -U sa -P your_password\r\nSqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate].\r\nSqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https:\/\/go.microsoft.com\/fwlink\/?linkid=2226722.<\/pre>\n
[\/codesyntax]<\/p>\n
it turned out I need to add -C parameter at the end like this
\n[codesyntax lang=”bash”]<\/p>\n
satria@teddy:~$ sqlcmd -S localhost -U sa -P Teddy@123 -C\r\n1> SELECT Name from sys.databases;\r\n2> GO\r\nName                                                                                                                            \r\n--------------------------------------------------------------------------------------------------------------------------------\r\nmaster                                                                                                                          \r\ntempdb                                                                                                                          \r\nmodel                                                                                                                           \r\nmsdb                                                                                                                            \r\n\r\n(4 rows affected)\r\n1> quit<\/pre>\n
[\/codesyntax]<\/p>\n
Create a new database<\/p>\n
For example create a new database TestDB from sqlcmd
\n[codesyntax lang=”bash”]<\/p>\n
1> CREATE DATABASE TestDB;\r\n2> GO<\/pre>\n
[\/codesyntax]<\/p>\n
Create a new table dbo.Inventory and Insert data
\n[codesyntax lang=”bash”]<\/p>\n
1> USE TestDB;\r\n2> GO\r\n1> CREATE TABLE dbo.Inventory\r\n2> (\r\n3> id INT,\r\n4> name NVARCHAR (50),\r\n5> quantity INT,\r\n6> PRIMARY KEY (id)\r\n7> );\r\n8> GO\r\n1> INSERT INTO dbo.Inventory VALUES (1, 'banana', 150);\r\n2> GO\r\n\r\n(1 rows affected)\r\n1> INSERT INTO dbo.Inventory VALUES (2, 'orange', 154);\r\n2> GO\r\n\r\n(1 rows affected)\r\n1> SELECT * FROM dbo.Inventory;\r\n2> GO\r\nid          name                                               quantity   \r\n----------- -------------------------------------------------- -----------\r\n          1 banana                                                     150\r\n          2 orange                                                     154\r\n\r\n(2 rows affected)\r\n1> SELECT * FROM dbo.Inventory;\r\n2> GO\r\nid          name                                               quantity   \r\n----------- -------------------------------------------------- -----------\r\n          1 banana                                                     150\r\n          2 orange                                                     154\r\n\r\n(2 rows affected)\r\n1> quit<\/pre>\n
[\/codesyntax]<\/p>\n
Install DBeaver (https:\/\/dbeaver.io\/)
\nThis is Database GUI for many databases including MS SQL Server<\/p>\n
Download it https:\/\/dbeaver.io\/download\/
\nI used Ubuntu PPA
\n[codesyntax lang=”bash”]<\/p>\n
sudo add-apt-repository ppa:serge-rider\/dbeaver-ce\r\nsudo apt-get update\r\nsudo apt-get install dbeaver-ce<\/pre>\n
[\/codesyntax]<\/p>\n
Open DBeaver CE and select to the MS SQL Server<\/p>\n
\"\"<\/p>\n
Connect to the MS SQL Server but it needs to use JDBC driver. Install it directly from the DBeaver
\n\"\"<\/p>\n
If everything is okay, it’ll look like this
\n\"\"<\/p>\n
on the DBeaver GUI you can add a new row. for example add a new row
\nID: 3
\nName: Apple
\nQuantity: 158
\nThen save<\/p>\n
on the sqlcmd should reflect the changes
\n[codesyntax lang=”bash”]<\/p>\n
1> USE TestDB;\r\n2> GO\r\nChanged database context to 'TestDB'.\r\n1> SELECT * FROM dbo.Inventory;\r\n2> GO\r\nid          name                                               quantity   \r\n----------- -------------------------------------------------- -----------\r\n          1 banana                                                     150\r\n          2 orange                                                     154\r\n          3 Apple                                                      158\r\n\r\n(3 rows affected)<\/pre>\n
[\/codesyntax]<\/p>\n","protected":false},"excerpt":{"rendered":"
Ref: https:\/\/learn.microsoft.com\/en-us\/sql\/linux\/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204 1. Update and upgrade the packages on ubuntu 22.04 [codesyntax lang=”bash”] sudo apt update sudo apt upgrade -y [\/codesyntax] 2. Download the public key, convert from ASCII to GPG format, and write it to the required location: [codesyntax lang=”bash”] curl -fsSL https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo gpg –dearmor -o \/usr\/share\/keyrings\/microsoft-prod.gpg [\/codesyntax] 3. Manually download and … Continue reading “Install Microsoft SQL Server 2022 On Ubuntu 22.04”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[103,17,132],"tags":[],"class_list":["post-12685","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server","category-ubuntu","category-ubuntu-22-04"],"_links":{"self":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/12685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/comments?post=12685"}],"version-history":[{"count":8,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/12685\/revisions"}],"predecessor-version":[{"id":12696,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/12685\/revisions\/12696"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=12685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=12685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=12685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}