{"id":72,"date":"2023-10-22T01:44:21","date_gmt":"2023-10-22T01:44:21","guid":{"rendered":"https:\/\/www.sqltabletalk.com\/?p=72"},"modified":"2023-11-19T06:24:49","modified_gmt":"2023-11-19T06:24:49","slug":"sql-server-on-linux-getting-started-with-sql-server-2022-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/www.sqltabletalk.com\/?p=72","title":{"rendered":"SQL Server on Linux: Getting Started with SQL Server 2022 on Ubuntu 22.04"},"content":{"rendered":"\n

Microsoft\u2019s extension of SQL Server to the Linux platform marked a significant shift in its strategy, recognizing Linux as a major player in enterprise environments. This move expanded the reach of SQL Server to a larger audience and provided more deployment options for organizations. Today we will explore installing and configuring SQL Server on an Ubuntu 22.04 Linux host.<\/p>\n\n\n\n

Why SQL Server on Linux?<\/strong><\/p>\n\n\n\n

The demand for high-performance, secure, and reliable database systems is prevalent in many enterprise settings, and Linux is a popular choice due to its stability and performance. By offering SQL Server on Linux, Microsoft provided an opportunity for businesses to leverage SQL Server\u2019s capabilities on their preferred operating system.<\/p>\n\n\n\n

Features Not Available on Linux<\/strong><\/p>\n\n\n\n

While SQL Server on Linux offers a wide range of features, there are certain capabilities such as Reporting Services and Analysis Services that are still exclusive to the Windows environment. It\u2019s important to be aware of these limitations when considering SQL Server for Linux. For a detailed list of features not available on Linux, please refer to Microsoft\u2019s official documentation<\/a>.<\/p>\n\n\n\n

Installing SQL Server on Ubuntu 22.04<\/strong><\/p>\n\n\n\n

Ubuntu is a widely-used Linux distribution known for its ease of use and popularity among developers. SQL Server on Linux is also supported on Redhat and SUSE Linux distributions. More information about the differences between installation procedures for the three distributions can be found in the SQL Server for Linux official documentation. We are using Ubuntu 22.04 here due to its ease of use, free licensing, and wide availability.<\/p>\n\n\n\n

Here\u2019s how you can install SQL Server on Ubuntu 22.04:<\/strong><\/p>\n\n\n\n

    \n
  1. Add Microsoft\u2019s Repository:<\/strong><\/li>\n<\/ol>\n\n\n\n
    sudo su \ncurl -o \/etc\/apt\/sources.list.d\/mssql-server.list https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/mssql-server-2022.list\nexit<\/code><\/pre>\n\n\n\n
      \n
    1. Update the package list:<\/strong><\/li>\n<\/ol>\n\n\n\n
      sudo apt update<\/code><\/pre>\n\n\n\n
        \n
      1. Install SQL Server:<\/strong><\/li>\n<\/ol>\n\n\n\n
        sudo apt install -y mssql-server<\/code><\/pre>\n\n\n\n
          \n
        1. Configure SQL Server:<\/strong><\/li>\n<\/ol>\n\n\n\n
          sudo \/opt\/mssql\/bin\/mssql-conf setup<\/code><\/pre>\n\n\n\n
            \n
          1. Start SQL Server:<\/strong><\/li>\n<\/ol>\n\n\n\n
            sudo systemctl start mssql-server<\/code><\/pre>\n\n\n\n
            Installing SQL Server Tools on Ubuntu 22.04<\/strong><\/p>\n\n\n\n
            To effectively manage and interact with SQL Server on Ubuntu 22.04, you\u2019ll need to install the SQL Server tools. These tools include command-line utilities and graphical interfaces that make database administration and development tasks easier.<\/p>\n\n\n\n
            1. Install the SQL Server Command-Line Tools (sqlcmd and bcp):<\/strong><\/p>\n\n\n\n
            To install the SQL Server command-line tools, open your terminal and run the following commands:<\/p>\n\n\n\n
            sudo su\ncurl -o \/etc\/apt\/sources.list.d\/msprod.list https:\/\/packages.microsoft.com\/config\/ubuntu\/20.04\/prod.list\nexit<\/code><\/pre>\n\n\n\n
            Now, update the package list and install the tools and the UNIX ODBC driver:<\/p>\n\n\n\n
            sudo apt update -y && sudo apt install -y mssql-tools unixodbc-dev<\/code><\/pre>\n\n\n\n
            2. Add the SQL Server Tools to Your PATH:<\/strong><\/p>\n\n\n\n
            To use the SQL Server command-line tools easily, add them to your system\u2019s PATH environment variable:<\/p>\n\n\n\n
            echo \u2018export PATH=\u201d$PATH:\/opt\/mssql-tools\/bin\u201d\u2018 >> ~\/.bashrc source ~\/.bashrc<\/code><\/pre>\n\n\n\n
            You can now use sqlcmd<\/strong> and bcp<\/strong> from your terminal to interact with SQL Server.<\/p>\n\n\n\n
            Basic SQL Server Configuration on Linux<\/strong><\/p>\n\n\n\n
            Once installed, there are several configuration settings you can adjust to optimize SQL Server for your environment. SQL Server will need to be restarted for any configuration changes to take effect. We will take a look at a few examples below:<\/p>\n\n\n\n