Docker compose - can't connect to SQL Server database in SQL Server Management Studio

Question

I am trying to connect to my DB that has been created in my Docker Compose file. It looks like the DB has been successfully created but I am unable to connect to it using SQL Server management studio.

Here is my Docker Compose file:

version: "3.9"
services:
    web:
        image: ${DOCKER_REGISTRY-}umbracoapp
        build: 
          context: .\umbracoapp
          dockerfile: Dockerfile
        ports:
            - "8000:80"
        depends_on:
            - db
    db:
        image: "mcr.microsoft.com/mssql/server"
        environment:
            SA_PASSWORD: "Testing1234!!"
            ACCEPT_EULA: "Y"

Thanks

Hans Kilian · Accepted Answer · 2021-11-26 08:47:54Z

3

To access the database from outside the bridge network that Docker creates, you need to map it's port to a port on the host.

In the container, MSSQL uses port 1433. If that port is available on your host, you can map it to 1433 on the host by adding 'ports' to your db service like this

db:
    image: "mcr.microsoft.com/mssql/server"
    ports:
        - "1433:1433"
    environment:
        SA_PASSWORD: "Testing1234!!"
        ACCEPT_EULA: "Y"

answered Nov 26, 2021 at 8:47

Hans Kilian

26.6k4 gold badges39 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Funky Over a year ago

can I access that from the umbraco web?

Hans Kilian Over a year ago

I don't know what that is

Funky Over a year ago

it's the part above in the docker- compose, basically just a website: web: image: ${DOCKER_REGISTRY-}umbracoapp build: context: .\umbracoapp dockerfile: Dockerfile ports: - "8000:80" depends_on: - db

Hans Kilian Over a year ago

You are able to reach the database from the umbraco service even without exposing the port, since the umbraco service and the database are on the same Docker bridge network. You just need to use db as the name for the database server in your umbraco configuration.

Collectives™ on Stack Overflow

Docker compose - can't connect to SQL Server database in SQL Server Management Studio

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related