1. Install PHP 8.0 and Dependencies
Ensure you have the necessary PHP 8.0 development packages to compile the drivers.
#sudo apt-get update
#sudo add-apt-repository ppa:ondrej/php -y
#sudo apt-get install php8.0 php8.0-dev php8.0-xml unixodbc-dev -y
2. Install Microsoft ODBC Driver
#curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
#curl https://microsoft.com(lsb_release -rs)/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
#sudo apt update
#sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
Optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
3. Install PHP SQLSRV Extensions
Use PECL to download and compile the drivers.
Note that for PHP 8.0, specific versions like 5.11 are often required for stability.
- Install SQLSRV: #sudo pecl install sqlsrv-5.11.1
- Install PDO_SQLSRV: #sudo pecl install pdo_sqlsrv-5.11.1
4. Enable the Extension
#printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.0/mods-available/sqlsrv.ini
#printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/8.0/mods-available/pdo_sqlsrv.ini
5. Restart Web Server
6. Verify Installation
#php -m | grep sqlsrv
pdo_sqlsrv
sqlsrv