Sign inSign up

vibs2006/sql_server_fts

By vibs2006

•Updated 8 months ago

Current Version: SQL Server 2022 with Full Text Search enabled Developer/Express/Enterprise

Image
Databases & storage
0

10K+

vibs2006/sql_server_fts repository overview

Check T-SQL value to confirm - FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

Check if SQL Server Full Text is installed

Current SQL Server Version Details If you run docker run (replace PID with Developer or Enterprise for changing version in docker run command)

Microsoft SQL Server 2022 (RTM-CU21) (KB5065865) - 16.0.4215.2 (X64) Aug 11 2025 13:24:21   
Copyright (C) 2022 Microsoft Corporation  Developer Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>   

⁠Run docker image by following docker run command

docker run --name sqlserver_fts -e "ACCEPT_EULA=Y" -v SqlServer:/var/opt/mssql -e "MSSQL_SA_PASSWORD=your1#ComplexPassword" -e "MSSQL_PID=Express" -p 1433:1433 -d vibs2006/sql_server_fts:latest
⁠To create your own image use the following docker file script
## For Ubuntu 22.04 follow the script as follows 

# Docker image with msssql 2022 with full text search enabled
# based on work in: https://github.com/Microsoft/mssql-docker

# Base OS layer: Latest SQL Server 2022 Compatible Ubuntu LTS 22.04
FROM ubuntu:jammy

# Install pre-requisites since it is needed to get repo config for SQL server
RUN export DEBIAN_FRONTEND=noninteractive && \
    apt-get update && \
    apt-get install -yq curl apt-transport-https gnupg && \
    # Get official Microsoft repository configuration
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/22.04/packages-microsoft-prod.deb --output packages-microsoft-prod.deb && dpkg -i packages-microsoft-prod.deb && \
    curl https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | tee /etc/apt/sources.list.d/mssql-server.list && \
    apt-get update  && \
    # Install SQL Server from apt
    apt-get install -y mssql-server && \
    # Install optional packages
    apt-get install -y mssql-server-fts && \
    ACCEPT_EULA=Y apt-get install -y mssql-tools && \
    # Cleanup the Dockerfile
    apt-get clean && \
    rm -rf /var/lib/apt/lists

# Run SQL Server process
CMD ["/opt/mssql/bin/sqlservr"]

To make your own image run

docker build . -t vibs2006/sql_server_fts:latest

Tag summary

Content type

Image

Digest

sha256:aca54f174…

Size

832.6 MB

Last updated

8 months ago

docker pull vibs2006/sql_server_fts