Installing MSSQL ODBC Driver inside Debian 12 Docker Image

Copy the lines below into your docker file to install MSSQL driver properly

# BEGIN MSSQL ODBC DRIVER INSTALLATION 
SHELL ["/bin/bash", "-c"]
RUN apt update
RUN apt install -y curl
RUN curl https://packages.microsoft.com/keys/microsoft.asc |  tee /etc/apt/trusted.gpg.d/microsoft.asc
 
# Debian 12
RUN curl https://packages.microsoft.com/keys/microsoft.asc |  tee /etc/apt/trusted.gpg.d/microsoft.asc
 
# Debian 12
RUN curl -fsSL https://packages.microsoft.com/keys/microsoft.asc |  gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
RUN curl https://packages.microsoft.com/config/debian/12/prod.list |  tee /etc/apt/sources.list.d/mssql-release.list
 
RUN apt-get update
RUN ACCEPT_EULA=Y apt-get install -y msodbcsql17
RUN ACCEPT_EULA=Y apt-get install -y mssql-tools
 
 
# Appending MSSQL System path
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
RUN source ~/.bashrc
 
RUN apt-get install -y unixodbc-dev
RUN apt-get install -y libgssapi-krb5-2
 
# END MSSQL ODBC DRIVER INSTALLATION