[SOLVED] install sql server on ubuntu agent in azure pipelines

Issue

Using azure ubuntu latest agent. how can I install sql server on ubuntu-latest agent in azure pipelines? tried the following but causing errors

- task: Bash@3
  inputs:
    targetType: 'inline'
    script: |
      sudo apt-get update
      sudo apt-get install mssql-server

Solution

You need to Import the public repository GPG keys and register the SQL Server Ubuntu repository.

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-preview.list)

"

Please refer to the document: Quickstart: Install SQL Server and create a database on Ubuntu

Answered By - Minxin Yu - MSFT

Answer Checked By - David Marino (WPSolving Volunteer)