Install SQL Server Via Docker

First download and install Docker

Enter the following in the command line to download the container, but make sure to change the password to a secure one you wish to use:

docker pull mcr.microsoft.com/mssql/server:2022-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Password123" \
-p 1433:1433 --name sql2022 --hostname sql2022 \
-d \
mcr.microsoft.com/mssql/server:2022-latest

Note:: The default username for SQL Server is always sa (System Administrator). The password is specified by the MSSQL_SA_PASSWORD environment variable (use something more secure than Password123 in the example above!)

To check the container is running and to stop and start it etc. use the Docker desktop application.

In DataGrip, open a new connection and enter the following parameters:

Server / host: localhost

Authentication: User & Password

Port: 1433

User / User name: sa

Password: your chosen password

If you are using DataGrip, go to the advanced settings and set encrypt to false.

A common way of testing that you are successfully connected to a database is by creating a new query and entering the following:

SELECT GETDATE()

Last modified: 16 January 2025