Can't connect to ms sql database from docker container by sql management studio

Question

I try to run a microsoft/mssql-server-windows-express container ->

docker run -d -p 1433:1433 -e sa_password=password -e ACCEPT_EULA=Y microsoft/mssql-server-windows-express

And I get next error ->

docker: Error response from daemon: failed to create endpoint hopeful_kowalevski on network nat: HNS failed with error : The process cannot access the file because it is being used by another process.

I think it is because sql server on my environment listens to 1433 port. Then I try to run container with other port eg 5000:1433 and container is run well.

Then I try to connect to db from container by sql management studio using "ip-address",5000. But I get Microsoft SQL Server, Error: 258.

are you sure there is no firewall stopping you from using port 1433 (or 5000) — GuidoG
– GuidoG, Commented Feb 15, 2019 at 13:38
Yeah, there is no firewall stopping. I also added a new firewall rule for 5000 port. But it didn't help( — agawa17
– agawa17, Commented Feb 15, 2019 at 14:07
You have to add that rule at both ends. Just checking to be sure — GuidoG
– GuidoG, Commented Feb 15, 2019 at 14:12
What do you mean about both ends? Should I add the rule at the host and the rule in the container? — agawa17
– agawa17, Commented Feb 18, 2019 at 9:00
The firewall on the machine that is running this docker must allow that port, and also the firewall on the machine where you are trying to connect with the database must allow this port — GuidoG
– GuidoG, Commented Feb 18, 2019 at 9:12

agawa17 · Accepted Answer · 2019-02-23 12:40:35Z

4

As far as I understood, the issue was with an incorrect password to DB. The password didn't match to database rules. The correct password should contain

at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols -> https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017&pivots=cs1-bash#pullandrun2017

answered Feb 23, 2019 at 12:40

agawa17

3251 gold badge3 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Can't connect to ms sql database from docker container by sql management studio

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related