Can we install sql agent on linux ubuntu 20.04 ? Whic type of version support?

Question

i want to install sql agent on linux ubuntu 20.04, is it possible ? Microsoft support or not ? which type of version we should install?

Answer 1

Hi,

The short answer is yes, you can enable the SQL Server Agent on Linux and this document presents the how to do it:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699

sudo apt-get update 
sudo apt-get install mssql-server-agent
sudo systemctl restart mssql-server

...

With that said, I highly recommend to check the official document regarding the limitations for SQL Server 2022 (same doc exists for previous versions) on Linux

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699#unsupported-features-and-services

Answer 2

Hello @GR200379 !

You have two posts on the same query i suppose you really need help on this!

Anyway we are glad to help , please try to use one thread per issue so you can get the best help from the community!

The answer is yes if you fit the prerequisites :

Also this link can help you understand and see Known Issues

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes-2022?view=sql-server-ver16

SQL Server is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a container image, which can run on Kubernetes, OpenShift, and Docker Engine on Linux.

SQL Server has the following system requirements for Linux:

Memory2 GBFile SystemXFS or EXT4 (other file systems, such as BTRFS, aren't supported)Disk space6 GBProcessor speed2 GHzProcessor cores2 coresProcessor typex64-compatible onlyIf you use Network File System (NFS) remote shares in production, note the following support requirements:

• Use NFS version 4.2 or higher. Older versions of NFS don't support required features, such as fallocate and sparse file creation, common to modern file systems.
• Locate only the /var/opt/mssql directories on the NFS mount. Other files, such as the SQL Server system binaries, aren't supported.
• Ensure that NFS clients use the 'nolock' option when mounting the remote share.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards