# SQL Server on Docker (Prisma ORM v6) (/docs/orm/v6/overview/databases/sql-server/sql-server-docker)

> For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL.

Download and use the Microsoft SQL Server Docker image.

Location: ORM > v6 > Core Concepts > Supported databases > SQL Server > SQL Server on Docker

> [!NOTE]
> 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](https://docs.docker.com/get-started/get-docker/)

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

   ```bash
   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:

   ```bash wrap
   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](https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15\&pivots=cs1-cmd\&tabs=cli#connect-to-sql-server), replacing the image name and password with your own.

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

   ```bash
   CREATE DATABASE quickstart
   GO
   ```

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

   ```bash
   sp_databases
   GO
   ```

## Connection URL credentials [#connection-url-credentials]

Based on this example, your credentials are:

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

## Related pages

- [`SQL Server on Windows (local)`](https://www.prisma.io/docs/orm/v6/overview/databases/sql-server/sql-server-local): Set up and configure SQL Server on Windows.