DEV Community 👩‍💻👨‍💻

Cover image for Install Microsoft Sql Server php drivers in Laravel Sail
Omar Ponce
Omar Ponce

Posted on

Install Microsoft Sql Server php drivers in Laravel Sail

If you ever have a Laravel Sail container that needs to connect to a mssqlsrv database, this is how you can install the needed drivers in order to do so.

After installing Laravel Sail and running sail:publish, you need to add this block after the RUN update-alternatives ...

#Add repository ODBC and Install the Microsoft ODBC driver for SQL Server
RUN curl | apt-key add - \
    && curl > /etc/apt/sources.list.d/mssql-release.list \
    && apt-get update \
    && apt-get install -y unixodbc-dev \
    && ACCEPT_EULA=Y apt-get install -y msodbcsql17 \
    && ACCEPT_EULA=Y apt-get install -y mssql-tools \
    && apt-get install -y gcc musl-dev make

# Install the PHP drivers for Microsoft SQL Server

RUN curl -O \
     && php go-pear.phar

RUN pecl channel-update \
    && pecl install sqlsrv pdo_sqlsrv \
    && printf "; priority=20\\n" > /etc/php/8.0/mods-available/sqlsrv.ini \
    && printf "; priority=30\\n" > /etc/php/8.0/mods-available/pdo_sqlsrv.ini \
    && phpenmod -v 8.0 sqlsrv pdo_sqlsrv \
    && pecl clear-cache \
    && rm -rf /tmp/* /var/tmp/*
Enter fullscreen mode Exit fullscreen mode

Now add your DB config to the .env Laravel file.

Top comments (0)

Take a look at this:


Go to your customization settings to nudge your home feed to show content more relevant to your developer experience level. 🛠