Install Microsoft SQL Drivers for PHP 7 in Docker

Published on by

Install Microsoft SQL Drivers for PHP 7 in Docker image

I started a project recently that required that I connect a Microsoft SQL Server database with a Laravel 5.5 application, so I thought I’d document how I install the pdo_sqlsrv module and install the Microsoft drivers for PHP in Docker.

Once you install the driver, you can easily configure Laravel to use a Microsoft SQL Server connection:

DB_CONNECTION=sqlsrv

I use Docker with most of my PHP projects—I am releasing a book on using Docker with PHP next week—so I thought I’d show you the recipe for getting a SQL server connection with the PDO driver.

Here’s the Dockerfile needed to install the perquisites and pdo_sqlsrv PECL module:

FROM php:7.1-apache
 
ENV ACCEPT_EULA=Y
 
# Microsoft SQL Server Prerequisites
RUN apt-get update \
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
&& curl https://packages.microsoft.com/config/debian/9/prod.list \
> /etc/apt/sources.list.d/mssql-release.list \
&& apt-get install -y --no-install-recommends \
locales \
apt-transport-https \
&& echo "en_US.UTF-8 UTF-8" > /etc/locale.gen \
&& locale-gen \
&& apt-get update \
&& apt-get -y --no-install-recommends install \
unixodbc-dev \
msodbcsql17
 
RUN docker-php-ext-install mbstring pdo pdo_mysql \
&& pecl install sqlsrv pdo_sqlsrv xdebug \
&& docker-php-ext-enable sqlsrv pdo_sqlsrv xdebug
 
COPY index.php /var/www/html/

I was having difficulties installing the necessary packages with Debian Stretch and PHP 7.2, so I am using the official PHP 7.1 Docker image as the base image that I extend from at the time of writing.

I am demonstrating the apache version so it’s easy to serve up an index.php file to verify the installation. In most of my projects I am using Caddy or Nginx as the web server, but Apache is an excellent choice too!

The first RUN instruction installs the packages necessary for installing the msodbcsql17 and unixodbc-dev packages successfully:

# Microsoft SQL Server Prerequisites
RUN apt-get update \
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
&& curl https://packages.microsoft.com/config/debian/9/prod.list \
> /etc/apt/sources.list.d/mssql-release.list \
&& apt-get install -y --no-install-recommends \
locales \
apt-transport-https \
&& echo "en_US.UTF-8 UTF-8" > /etc/locale.gen \
&& locale-gen \
&& apt-get update \
&& apt-get -y --no-install-recommends install \
unixodbc-dev \
msodbcsql17

These packages are needed to install the PECL module for SQL Server’s PDO driver. You can find installation instructions for various platforms in the Microsoft/msphpsql GitHub project readme.

It’s also important to note that we set the ACCEPT_EULA environment variable to Y which is needed when running apt-get install msodbcsql. It signifies that you’ve accepted the End-user license agreement when installing the package.

The next RUN instruction installs PHP extensions using the official PHP image’s docker-php-ext-install script. In this case, I am installing a Laravel prerequisite mbstring along with pdo, and pdo_mysql:

RUN apt-get update \
&& apt-get -y --no-install-recommends install \
libxml2-dev \
&& docker-php-ext-install mbstring pdo pdo_mysql soap \
&& pecl install sqlsrv pdo_sqlsrv xdebug \
&& docker-php-ext-enable sqlsrv pdo_sqlsrv xdebug

Finally, the most important part of this RUN instruction, we are using pecl to install the sqlsrv and pdo_sqlsrv modules, and then using docker-php-ext-enable to enable them. I am also installing Xdebug because I typically install this in most images for development.

Building and Running The Container

The final instruction in the Dockerfile is the COPY instruction that is copying a simple index.php file that we will create now from the command line:

$ echo "<?php phpinfo();" > index.php

When we build the image, the Dockerfile will copy the index.php file in the location that Apache will look for it, and we can verify that the SQL Server drivers were installed and working with PHP.

You can build the image with the docker build command to try it out real quick:

$ docker build --pull -t sqlserver-demo .

The image will take a few minutes depending on your connection speed. Once the build finishes, you can run it from the command line:

$ docker run --rm -p 8080:80 sqlserver-demo

The docker run command runs the container, and with the help of the -p 8080:80 flag, we have mapped 8080 to the container which is listening on port 80. The --rm flag will remove the container once it exits.

After the container is running you should see some Apache logs in the console, and you can visit http://localhost:8080 in the browser to verify that the SQL Server module is enabled:

You should now be able to connect to a SQL Server database in your PHP 7.1 application! I’ve kept the example simple to just focus on the steps necessary to install the SQL Server PDO drivers, but I hope you can see how Docker can help ease the hassle of connecting to a Microsoft SQL database from your PHP applications.


Want to learn more about using Docker with PHP? I wrote a book, Docker for PHP Developers that is now available for sale. You can pick from one of two packages:

The links included are affiliate links which means if you decide to buy Laravel News gets a little kickback to help run this site.


Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Filed in:
Cube

Laravel Newsletter

Join 40k+ other developers and never miss out on new tips, tutorials, and more.

Laravel Forge logo

Laravel Forge

Easily create and manage your servers and deploy your Laravel applications in seconds.

Laravel Forge
Tinkerwell logo

Tinkerwell

The must-have code runner for Laravel developers. Tinker with AI, autocompletion and instant feedback on local and production environments.

Tinkerwell
No Compromises logo

No Compromises

Joel and Aaron, the two seasoned devs from the No Compromises podcast, are now available to hire for your Laravel project. ⬧ Flat rate of $7500/mo. ⬧ No lengthy sales process. ⬧ No contracts. ⬧ 100% money back guarantee.

No Compromises
Laravel Idea for PhpStorm logo

Laravel Idea for PhpStorm

Ultimate PhpStorm plugin for Laravel developers, delivering lightning-fast code completion, intelligent navigation, and powerful generation tools to supercharge productivity.

Laravel Idea for PhpStorm
Kirschbaum logo

Kirschbaum

Providing innovation and stability to ensure your web application succeeds.

Kirschbaum
Shift logo

Shift

Running an old Laravel version? Instant, automated Laravel upgrades and code modernization to keep your applications fresh.

Shift
Bacancy logo

Bacancy

Supercharge your project with a seasoned Laravel developer with 4-6 years of experience for just $2500/month. Get 160 hours of dedicated expertise & a risk-free 15-day trial. Schedule a call now!

Bacancy
Lucky Media logo

Lucky Media

Get Lucky Now - the ideal choice for Laravel Development, with over a decade of experience!

Lucky Media
Lunar: Laravel E-Commerce logo

Lunar: Laravel E-Commerce

E-Commerce for Laravel. An open-source package that brings the power of modern headless e-commerce functionality to Laravel.

Lunar: Laravel E-Commerce
LaraJobs logo

LaraJobs

The official Laravel job board

LaraJobs
SaaSykit: Laravel SaaS Starter Kit logo

SaaSykit: Laravel SaaS Starter Kit

SaaSykit is a Multi-tenant Laravel SaaS Starter Kit that comes with all features required to run a modern SaaS. Payments, Beautiful Checkout, Admin Panel, User dashboard, Auth, Ready Components, Stats, Blog, Docs and more.

SaaSykit: Laravel SaaS Starter Kit
Supercharge Your SaaS Development with FilamentFlow: The Ultimate Laravel Filament Boilerplate logo

Supercharge Your SaaS Development with FilamentFlow: The Ultimate Laravel Filament Boilerplate

Build your SaaS application in hours. Out-of-the-box multi-tenancy and seamless Stripe integration. Supports subscriptions and one-time purchases, allowing you to focus on building and creating without repetitive setup tasks.

Supercharge Your SaaS Development with FilamentFlow: The Ultimate Laravel Filament Boilerplate
JetShip - Laravel Starter Kit logo

JetShip - Laravel Starter Kit

A Laravel SaaS Boilerplate and a starter kit built on the TALL stack. It includes authentication, payments, admin panels, and more. Launch scalable apps fast with clean code, seamless deployment, and custom branding.

JetShip - Laravel Starter Kit
Rector logo

Rector

Your partner for seamless Laravel upgrades, cutting costs, and accelerating innovation for successful companies

Rector
MongoDB logo

MongoDB

Enhance your PHP applications with the powerful integration of MongoDB and Laravel, empowering developers to build applications with ease and efficiency. Support transactional, search, analytics and mobile use cases while using the familiar Eloquent APIs. Discover how MongoDB's flexible, modern database can transform your Laravel applications.

MongoDB

The latest

View all →
Streamlining Route Parameters in Laravel Using URL Defaults image

Streamlining Route Parameters in Laravel Using URL Defaults

Read article
Flexible Docker Images with PHP INI Environment Variables image

Flexible Docker Images with PHP INI Environment Variables

Read article
Dynamic Form Validation in Laravel with prohibited_if image

Dynamic Form Validation in Laravel with prohibited_if

Read article
Add Approvals to Your Laravel Application image

Add Approvals to Your Laravel Application

Read article
Enhancing Data Processing with Laravel's transform() Method image

Enhancing Data Processing with Laravel's transform() Method

Read article
Get Xdebug Working With Docker and PHP 8.4 in One Minute image

Get Xdebug Working With Docker and PHP 8.4 in One Minute

Read article