Running MS SQL server in docker refuses connection

Question

I have issues connecting with MSSQL Server Management Studio to my running docker container.

A beginner in docker.

I have created a following docker-compose.yml file:

version: '3.4'

services:
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2017-latest"
    volumes:
      - /var/lib/docker/volumes/sql_volume/_data
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: "pa55w0rd!"
      MSSQL_PID: "Express"
    ports:
      - "1533:1534"
  adventureworks_service:
    image: ${DOCKER_REGISTRY-}adventureworksservice
    build:
      context: .
      dockerfile: AdventureWorks_Service/Dockerfile

this docker file should start a MSSQL Database and the adventureworks_service project located in my solution.

this docker-compose is located in it's own Docker project, in the solution. created with the "add docker support" for my Web API project

assuming everything is correctly setup, I should be able to connect to the sql server on localhost:1533, using SQL server authentication with login Express and password pa55w0rd!.

I get following error right after attempting to connect (no timeouts, etc.)

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider : TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host) (Microsoft SQL Server, Error: 10054)

Does anyone know how I can access this server / container?

Thanks in advance

using SQL server authentication with login Express and password pa55w0rd!. Its login SA and NOT Express. — Max
– Max, Commented Sep 6, 2021 at 13:59
I'm having same issues with login as SA, as well. I'm able to connect to the server using docker exec -it <container_id|container_name> /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P <your_password> in Powershell. This issue only persists when connecting to container spun using docker-compose.yaml. When run using docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=yourStrong(!)Password" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest, I'm able to connect from SSMS. — Ashique Razak
– Ashique Razak, Commented Dec 30, 2021 at 6:53

frank_lee · Accepted Answer · 2021-09-06 14:35:09Z

1

The port in mssql should be 1433 rather than 1534, try this

version: '3.4'

services:
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2017-latest"
    volumes:
      - /var/lib/docker/volumes/sql_volume/_data
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: "pa55w0rd!"
      MSSQL_PID: "Express"
    ports:
      - "1433:1433"   # the port behind should always be 1433

  adventureworks_service:
    image: ${DOCKER_REGISTRY-}adventureworksservice
    build:
      context: .
      dockerfile: AdventureWorks_Service/Dockerfile

then your connection string should be like this

Data Source=sqlserver,1433;User Id=SA;Password=pa55w0rd!

answered Sep 6, 2021 at 14:35

frank_lee

4312 silver badges13 bronze badges

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

Comments

Sachith Muhandiram · Accepted Answer · 2021-09-06 13:49:37Z

0

Try adding network_mode: "host" to your compose file.

version: '3.4'

services:
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2017-latest"
    volumes:
      - /var/lib/docker/volumes/sql_volume/_data
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: "pa55w0rd!"
      MSSQL_PID: "Express"
    ports:
      - "1533:1534"
    network_mode: "host"

  adventureworks_service:
    image: ${DOCKER_REGISTRY-}adventureworksservice
    build:
      context: .
      dockerfile: AdventureWorks_Service/Dockerfile

answered Sep 6, 2021 at 13:49

Sachith Muhandiram

2,97811 gold badges54 silver badges113 bronze badges

1 Comment

Ashique Razak Over a year ago

I'm having same issues. Tried this, but not working.

askar.dw · Accepted Answer · 2024-04-20 18:35:44Z

0

If you still have this error in your SSMS, make sure that you are using correct host name with port it should be localhost,1433 with comma

answered Apr 20, 2024 at 18:35

askar.dw

11 bronze badge

1 Comment

camilajenny Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Running MS SQL server in docker refuses connection

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related