SQL Server on Docker

:::info[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. :::

:::warning

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:

1. Install and set up Docker

2. Run the following command in your terminal to download the Microsoft SQL Server 2019 image:

   bashCopy

   docker pull mcr.microsoft.com/mssql/server:2019-latest
   

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

   bashCopy

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

4. Follow Microsoft's instructions to connect to SQL Server and use the sqlcmd tool, replacing the image name and password with your own.

5. From the sqlcmd command prompt, create a new database:

   bashCopy

   CREATE DATABASE quickstart
   GO
   

6. Run the following command to check that your database was created successfully:

   bashCopy

   sp_databases
   GO
   

Connection URL credentials

Based on this example, your credentials are:

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