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

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.