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
– vitr, Commented May 4, 2018 at 7:46

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

32

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

answered May 4, 2018 at 8:11

Kien Chu

4,8951 gold badge21 silver badges31 bronze badges

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

6 Comments

Grzegorz Pasnik Over a year ago

In my case I had to do few additional steps, because I wanted to access SQL Server named instance on my host machine. Trying to access "host.docker.internal\SQLSERVER,1433" data source was always a failure. Eventually I've found solution that allows to connect to the named instance. 1. Get the port of the named instance How to do it 2. Enable firewall for the port you've found 3. Change Data Source in connection string to: "host.docker.internal,<named_instance_port>"

Shay Over a year ago

Just wasted 2 hours on this connection issue, just to realize I forgot to restart the SQL Server service all this time ;( So glad I ran into this answer

Francesco B. Over a year ago

Also check if the windows service SQL Server Browser is started

Francesco B. Over a year ago

And use the connection string with host.docker.internal\\mssqlserver,1433

kuklei Over a year ago

tcp/ip did the trick for me. dont forget to restart the sql server service

|

Leandro Bardelli · Accepted Answer · 2024-07-15 14:49:26Z

2

In my case I had to run this inside my SQL Server running from Docker, inside MSSQL, in order to accept remote connections:

USE master;
GO
EXEC sp_configure 'remote access', 1;
RECONFIGURE;
GO

and then use the following connection string:

Server=host.docker.internal,1433;Database=mydb;User Id=sa;Password=mypass;Connect Timeout=120;TrustServerCertificate=True;

edited Jul 15, 2024 at 14:49

answered Jun 1, 2024 at 19:27

Leandro Bardelli

11.7k16 gold badges88 silver badges130 bronze badges

1 Comment

Wellspring Over a year ago

host.docker.internal is a great improvement on my ever-changing host IP addresses

Collectives™ on Stack Overflow

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

2 Answers 2

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related