Skip to content

Instantly share code, notes, and snippets.

@zarpelon
Created December 18, 2020 13:46
Show Gist options
  • Save zarpelon/f43ded9123365e9d4a9ff0139baa137f to your computer and use it in GitHub Desktop.
Save zarpelon/f43ded9123365e9d4a9ff0139baa137f to your computer and use it in GitHub Desktop.
SqlSrv on PHP 7.4 and Ubuntu 20.04
sudo apt update
sudo apt install php-pear php-dev
curl -s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo bash -c "curl -s https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list"
sudo apt update
sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
sudo apt -y install unixodbc-dev
sudo apt -y install gcc g++ make autoconf libc-dev pkg-config
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
sudo bash -c "echo extension=sqlsrv.so > /etc/php/7.4/conf.d/sqlsrv.ini"
sudo bash -c "echo extension=pdo_sqlsrv.so > /etc/php/7.4/conf.d/pdo_sqlsrv.ini"
sudo service php7.4-fpm restart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment