SQL Server on Docker

Quick summary

This guide provides a quick overview on setting up and running Microsoft SQL Server in a Docker container, including pulling the image, starting the server, connecting, and creating a test database.

Prisma 7.0.0 has updated minimum Node.js requirements:

Node.js 20: >= 20.19.0
Node.js 22: >= 22.12.0
Node.js 24: >= 24.0.0+

If you're using Prisma 7.0.0 or higher with Docker, ensure your application's Docker base image uses Node.js 22 or 24. Update your Dockerfile to use node:22-alpine or node:24-alpine instead of older Node.js 20 images.

To run a Microsoft SQL Server container image with Docker:

Install and set up Docker
Run the following command in your terminal to download the Microsoft SQL Server 2019 image:
```
docker pull mcr.microsoft.com/mssql/server:2019-latest
```

Create an instance of the container image, replacing the value of SA_PASSWORD with a password of your choice:

docker run --name sql_container -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=myPassword' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest

Follow Microsoft's instructions to connect to SQL Server and use the sqlcmd tool, replacing the image name and password with your own.
From the sqlcmd command prompt, create a new database:
```
CREATE DATABASE quickstart
GO
```
Run the following command to check that your database was created successfully:
```
sp_databases
GO
```

Connection URL credentials

Based on this example, your credentials are:

Username: sa
Password: myPassword
Database: quickstart
Port: 1433

SQL Server on Docker

Connection URL credentials

On this page