How do you connect to a local SQL Server DB from within a docker container?

Question

This question has already been asked here, but no one has answered it (also asked here without any answers). I'd like to try to get it answered.

I have a Linux Docker Image containing a console app that connects to a local DB instance. DB is on my local PC and not in the docker image

Local server Name : RIXS\RSERVER

Connection String : optionsBuilder.UseSqlServer(@"Server=RIXS\RSERVER;Database=MyTable1;Trusted_Connection=True;MultipleActiveResultSets=true");

I've tried Adding the docker image to my SQL Servername

dac7889b09b0\RIXS\RSERVER
dac7889b09b0\RSERVER

But I'm obviously doing something wrong. Any idea?

A very detailed answer has been written here: stackoverflow.com/a/24326540/3025545 — Kh.Taheri
– Kh.Taheri, Commented Sep 21, 2017 at 6:55

yamenk · Accepted Answer · 2017-09-21 08:30:21Z

1

Start the container with network mode as host.

docker run --network=host ...

The host mode will make the container share the network interfaces of the host. Thus an address of localhost or 127.0.0.1 inside the container will refer to the host machine.

answered Sep 21, 2017 at 8:30

yamenk

52.6k11 gold badges103 silver badges93 bronze badges

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

Collectives™ on Stack Overflow

How do you connect to a local SQL Server DB from within a docker container?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related