How did I do?*

Connect to local MSSQL Docker container with Management Studio

View an SQL Server database running in a local container
View an SQL Server database running in a local container

Ensure the container is running, open up SSMS and set the Server name to 127.0.0.1,1433 (localhost, with a comma-separated port number).

Authenticate using SQL Server Authentication, and login as the server admin (sa) using the credentials defined in your docker-compose file, e.g.

environment:
  ACCEPT_EULA: "Y"
  SA_PASSWORD: example_123

Metadata

Title: Connect to local MSSQL Docker container with Management Studio

Author: Tom Jones

Created: 09/03/2025

Tags: docker sql server