# Including microsoft sql server in docker

**URL:** <https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779>\
**Category:** Docker Hub\
**Created:** [March 2, 2022, 8:06am UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779 "2022-03-02T08:06:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![michalise](https://sea3.discourse-cdn.com/docker/user_avatar/forums.docker.com/michalise/32/27838_2.png) [@michalise](https://forums.docker.com/u/michalise)\
**Post date:** [March 2, 2022, 8:06am UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779/1 "2022-03-02T08:06:43Z")

</div>

Hi guys, Im trying to include sql server in my container, the container builds but when i try to get data from the database, I get a ‘driver not found’ error. fyi I am using laravel sail

here is my dockerfile, can anyone spot the problem?

```auto
FROM ubuntu:21.10

LABEL maintainer="Taylor Otwell"

ARG WWWGROUP
ARG NODE_VERSION=16

WORKDIR /var/www/html

ENV DEBIAN_FRONTEND noninteractive
ENV TZ=UTC

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update \
    && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor sqlite3 libcap2-bin libpng-dev python2 \
    && mkdir -p ~/.gnupg \
    && chmod 600 ~/.gnupg \
    && echo "disable-ipv6" >> ~/.gnupg/dirmngr.conf \
    && apt-key adv --homedir ~/.gnupg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys E5267A6C \
    && apt-key adv --homedir ~/.gnupg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys C300EE8C \
    && echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu impish main" > /etc/apt/sources.list.d/ppa_ondrej_php.list \
    && apt-get update \
    && apt-get install -y php8.0-cli php8.0-dev \
       php8.0-pgsql php8.0-sqlite3 php8.0-gd \
       php8.0-curl php8.0-memcached \
       php8.0-imap php8.0-mysql php8.0-mbstring \
       php8.0-xml php8.0-zip php8.0-bcmath php8.0-soap \
       php8.0-intl php8.0-readline php8.0-pcov \
       php8.0-msgpack php8.0-igbinary php8.0-ldap \
       php8.0-redis php8.0-swoole php8.0-xdebug \
    && php -r "readfile('https://getcomposer.org/installer');" | php -- --install-dir=/usr/bin/ --filename=composer \
    && curl -sL https://deb.nodesource.com/setup_$NODE_VERSION.x | bash - \
    && apt-get install -y nodejs \
    && npm install -g npm \
    && curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - \
    && echo "deb https://dl.yarnpkg.com/debian/ stable main" > /etc/apt/sources.list.d/yarn.list \
    && apt-get update \
    && apt-get install -y yarn \
    && apt-get install -y mysql-client \
    && apt-get install -y postgresql-client \
    && apt-get -y autoremove \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

RUN apt-get update && apt-get install -y gnupg2
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
RUN curl https://packages.microsoft.com/config/ubuntu/21.10/prod.list > /etc/apt/sources.list.d/mssql-release.list
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get -y --no-install-recommends install msodbcsql17 unixodbc-dev
RUN pecl install sqlsrv
RUN pecl install pdo_sqlsrv

RUN update-alternatives --set php /usr/bin/php8.0

RUN setcap "cap_net_bind_service=+ep" /usr/bin/php8.0

RUN groupadd --force -g $WWWGROUP sail
RUN useradd -ms /bin/bash --no-user-group -g $WWWGROUP -u 1337 sail

COPY start-container /usr/local/bin/start-container
COPY supervisord.conf /etc/supervisor/conf.d/supervisord.conf
COPY php.ini /etc/php/8.0/cli/conf.d/99-sail.ini
RUN chmod +x /usr/local/bin/start-container

EXPOSE 8000

ENTRYPOINT ["start-container"]

```

---

<div class="post-metadata">

**Author:** ![rimelek](https://sea3.discourse-cdn.com/docker/user_avatar/forums.docker.com/rimelek/32/41602_2.png) [@rimelek](https://forums.docker.com/u/rimelek)\
**Post date:** [March 3, 2022, 8:33pm UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779/2 "2022-03-03T20:33:54Z")

</div>

What does phpinfo() shows you? Can you confirm that the driver is loaded? I assume you have read this: [Linux and macOS Installation for the Drivers for PHP - PHP drivers for SQL Server | Microsoft Docs](https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15)

I am pretty sure though, this is not an issue of “including microsoft sql server in docker”. You have to configure PHP properly. Are you sure, you enabled the required modules?

---

<div class="post-metadata">

**Author:** ![matthiasradde](https://sea3.discourse-cdn.com/docker/user_avatar/forums.docker.com/matthiasradde/32/30830_2.png) [@matthiasradde](https://forums.docker.com/u/matthiasradde)\
**Post date:** [March 3, 2022, 8:40pm UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779/3 "2022-03-03T20:40:24Z")

</div>

I agree with @rimelek - I guess you are missing

```auto
RUN docker-php-ext-enable pdo_sqlsrv && docker-php-ext-enable sqlsrv

```

after the pecl-installation of `sqlsrv` and `pdo_sqlsrv` - at least it was working this way for me with PHP 7.4 🙂

---

<div class="post-metadata">

**Author:** ![rimelek](https://sea3.discourse-cdn.com/docker/user_avatar/forums.docker.com/rimelek/32/41602_2.png) [@rimelek](https://forums.docker.com/u/rimelek)\
**Post date:** [March 3, 2022, 8:43pm UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779/4 "2022-03-03T20:43:49Z")

</div>

Since this is not an official PHP image, there will be no such scripts to enable modules, but the Microsoft documentation shows an other solution.

---

<div class="post-metadata">

**Author:** ![matthiasradde](https://sea3.discourse-cdn.com/docker/user_avatar/forums.docker.com/matthiasradde/32/30830_2.png) [@matthiasradde](https://forums.docker.com/u/matthiasradde)\
**Post date:** [March 3, 2022, 8:57pm UTC](https://forums.docker.com/t/including-microsoft-sql-server-in-docker/121779/5 "2022-03-03T20:57:10Z")

</div>

@rimelek You are right - my hint was used with an official PHP-image.