Add support for Microsoft SQL Server Drivers

[elcapo]

I've needed to add support for Microsoft SQL Server Drivers, so I customized the Docker image. Here's my Dockerfile, just in case it may be useful for someone else:

FROM serversideup/php:8.1-fpm-nginx

# https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16#installing-on-ubuntu

## Prerequisites

RUN curl https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc
RUN curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | tee /etc/apt/sources.list.d/mssql-release.list
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get install -y msodbcsql18
RUN apt-get install -y unixodbc-dev software-properties-common

## PHP

RUN add-apt-repository ppa:ondrej/php -y
RUN apt-get update
RUN apt-get install php8.1 php8.1-dev php-pear php8.1-xml -y --allow-unauthenticated

## PHP drivers for Microsft SQL Server

RUN pecl install sqlsrv pdo_sqlsrv
RUN printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.1/mods-available/sqlsrv.ini
RUN printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/8.1/mods-available/pdo_sqlsrv.ini
RUN phpenmod -v 8.1 sqlsrv pdo_sqlsrv

[jaydrogers]

Thanks for sharing your solution!