Docker Desktop - Can't connect to internal Network

General
1

Hello. I use DOCKER Desktop and I have a portainer app with a SQL connection String, but it won’t connect to the internal network. I can telnet from within docker to the SQL Server and I’m certain that my SQL Config is setup correctly to allow remote connections on port 1433.

I can get this to work from within the machine that has Docker installed/SQL Express. The issue has to be a network related issue…

I can ping the SQL server just fine…

Any idea’s on how to get Docker Desktop to “see” the internal network? Windows Firewall is turned OFF. I don’t know what else to do to get this to work.

My internal IP range is 10.10.x.x. and the Docker network is using these settings. I’ve already tried setting the Docker Desktop>Network DNS to my Servers DNS.

Any info on how to resolve this is greatly appreciated.

Or is my connection string on my container wrong? It shouldn’t be…

I think THIS is the issue, but not sure why?! I’m erasing the actual credentials for obvious reasons.
SQLCONNSTR
server=192.168.1.1\MSSQL2014;database=db;User ID=user;Password=pw

I’m also using Postman to send an authentication request …

image
image835×119 17.2 KB

THANKS IN ADVANCE!!!

3

hello dear,
I found the same problem and it solved by these steps
1 - go to sql server managment studio right click on your server => properties

2 - after click on properties navigate to => connections and make sure that you
allow remote connection => then click ok
3 - go to your search and write (computer management )

4 - then choose services and applications => then SQL server configuration
manager

5 - then sql sever network configuration

6 - then protocols for MSSQLSERVER

7 - then TCP/IP

8 - right click and enable it
9 - then properties

10 - and as image you will find that property of listen to is no => change it to yes

11 - search for services

12 - after you open it search for SQL server (MSSQLSERVER) and restart it

13 - make sure your connection string server property like
“Server=,1433”
14 - rebuild your docker image again and try