Back to Apps
Microsoft SQL

Deploy Microsoft SQL on Your Own Server

Microsoft SQL Server is a relational database management system developed by Microsoft

πŸ—„οΈ Databases

Want to deploy Microsoft SQL on your server faster? Try Senate with one-command setup, automatic HTTPS and monitoring.

Get Started

What is Microsoft SQL?

SQL Server is a central part of the Microsoft data platform. SQL Server is an industry leader in operational database management systems (ODBMS). SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer Edition cannot be used in a production environment. The SQL Server 2017 Developer Edition license terms are located here: https://go.microsoft.com/fwlink/?linkid=857698 . After installation on Senate, it will be available as <service_name> at the port specified for "Container TCP Port" field to other apps. Enter your SQL Server Configuration parameters and click on next. It will take about a minute for the process to finish.

Self-Host Microsoft SQL

Follow these steps to deploy on your own server.

1

Install Docker

Skip this step if Docker is already installed on your server.

curl -fsSL https://get.docker.com | sh
2

Configure

Customize the settings below. Defaults work for most cases.

General
3

Deploy

Copy the configuration and run it on your server.

services:
  mssql-db:
    image: mcr.microsoft.com/mssql/server:2017-CU12-ubuntu
    environment:
      ACCEPT_EULA: ""
      MSSQL_PID: Developer
      MSSQL_SA_PASSWORD: ""
      MSSQL_TCP_PORT: "1433"
    volumes:
      - mssql-db-data:/var/opt/mssql
    ports:
      - $$cap_host_port:$$cap_container_port
volumes:
  mssql-db-data: {}

Then run:

docker compose up -d
4

Access

Once started, access your app at http://localhost:80

Why Self-Host Microsoft SQL?

Full Data Ownership

Your data stays on your servers. No third-party access.

No Monthly Fees

Pay only for your server. No per-seat or usage charges.

Complete Control

Customize, backup, and scale on your own terms.

Privacy & Compliance

Meet GDPR, HIPAA, or internal security requirements.

Technical Details

Docker Image

mcr.microsoft.com/mssql/server:${server_version}

Want to go faster?

Try Senate! Senate handles Docker, HTTPS, updates, and monitoring for you. Deploy any of our 300+ apps with a single command.

Install on any Linux server:

sh -c "$(curl -sSL https://get.senate.sh)"