Docker Container Micro-Service Error: Can not Connect to SQL Server in Docker Container from Microsoft Sql Server Management

Docker Container Micro-Service Error: Can not Connect to SQL Server in Docker Container from Microsoft Sql Server Management

Click to Watch Video

Problem: Can not Connect to SQL Server in Docker Container from Microsoft Sql Server Management

Solution: When your Docker Container is up and running and you have verified that the Microsoft Sql Server is running by issuing a command in another Powershell instance (docker ps -a)

1. Open up Sql Server Management Application and in the Server text-box enter. YourLocalMachineIPAddress followed by ',' (a comma)[Not a full stop/period] This is important or else you won't be able to access the Database Server. e.g. 192.9100.09,200 (notice the comma and then port number)

2. After 1 is complete, enter the username and password as defined in Docker-Compose.Yaml file in your project.


Edit this Article
Docker Sql-Server Asp.Net 5 Micro-Service Docker published
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy