Ubuntu Install SQLSRV and PDO_SQLSRV on PHP7.4

On Ubuntu 18.04

curl -s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

sudo bash -c "curl -s https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /etc/apt/sources.list.d/mssql-release.list"

sudo apt-get update

sudo ACCEPT_EULA=Y apt-get -y install msodbcsql17 mssql-tools

sudo apt-get -y install unixodbc-dev

sudo apt-get -y install gcc g++ make autoconf libc-dev pkg-config

sudo pecl install sqlsrv

sudo pecl install pdo_sqlsrv

sudo su

printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.4/mods-available/sqlsrv.ini

printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.4/mods-available/pdo_sqlsrv.ini

exit

sudo phpenmod -s fpm -v 7.4 sqlsrv pdo_sqlsrv

sudo phpenmod -s cli -v 7.4 sqlsrv pdo_sqlsrv

php -m | grep sqlsrv

sudo systemctl restart php7.4-fpm.service