Connect to SQL Server in local machine (host) from docker using host.docker.internal

Question

I'm trying to connect to my SQL Server instance running in my local computer using host.docker.internal (as recommended in https://docs.docker.com/docker-for-windows/networking/#use-cases-and-workarounds)

The host.docker.internal is successfully resolved to an IP, and it's ping-able

And I've opened up the port 1433 in my firewall configuration

Error message

Connection refused 192.168.65.2:1433

My connection string

Data Source=host.docker.internal,1433;Initial Catalog=;Persist Security Info=False;User ID=;Password=;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

docker version

Client:
 Version:      18.03.1-ce
 API version:  1.37
 Go version:   go1.9.5
 Git commit:   9ee9f40
 Built:        Thu Apr 26 07:12:48 2018
 OS/Arch:      windows/amd64
 Experimental: false
 Orchestrator: swarm

Server:
 Engine:
  Version:      18.03.1-ce
  API version:  1.37 (minimum version 1.12)
  Go version:   go1.9.5
  Git commit:   9ee9f40
  Built:        Thu Apr 26 07:22:38 2018
  OS/Arch:      linux/amd64
  Experimental: true

Docker for windows version

is your SQL server accepting external connections in general? have you tried to connect to it not from the docker container, but, let's say from another machine in you network? — vitr

Kien Chu Kien Chu · Accepted Answer · 2018-05-04T08:11:36

If anyone have similar problem, here's how I solve it

Open SQL Server Configuration Manager
Enable TCP/IP in Server Network Configuration
Restart SQL Service Service

If it's still not working, there are a few more things to check

Firewall (open port 1433)
Enable remote connections to your sql server

Connect to SQL Server in local machine (host) from docker using host.docker.internal

1 Answers