binarythistle / colourapi Goto Github PK

Hi Binary,
Thank you for course. RESTFUL API depends on a SQL DB so i try to use sql linux container as below

1. API app dependents on a DB(mcr.microsoft.com/mssql/server:2017-latest-ubuntu ) So for creating sql-db , i ran below docker command at windows power-shell .. ..

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=yourpssword" `
        -e "MSSQL_PID=Express" --name  sql1   `
        -p 1433:1433  -d  mcr.microsoft.com/mssql/server:2017-latest-ubuntu 

Linux -DB Container created successfully and was running as below by'Docker ps -a'command at windows power-shell
https://uploads.disquscdn.com/images/9221f417a654aca4ec2fe923ca3743c6f447772bd8b853583fe2312ea012aef2.jpg

But , When i tried to connect that created sql-db container with SSMS tool ,below ERROR is coming as
https://uploads.disquscdn.com/images/8c09b0d4c863769f4c810d2a167ce17cc2227a7e63b57a58504d5159a6eb614a.jpg
" A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. "

Pls, help and am i missing something else ?
But also, API container not able to connect sql-db container So below ,a thread is going on with same issue for any resolution..
https://docs.microsoft.com/en-us/answers/questions/191498/how-to-pass-sql-db-container-connection-string-to.html

Thanks,

If you have few version of dotnet, you probably can run it in a specific version.
Add global.json to use 2.2 version of dotnet core.