Connect to local MSSQL Docker container with Management Studio

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.

1environment:
2  ACCEPT_EULA: "Y"
3  SA_PASSWORD: example_123
Copy