Docker and .net80 webapi MS SQL question

General
1

Hi,
I built a WebAPI configured with Entity Framework on .net 8.0, and had it connecting to a remote MYSQL server, then I put the webapi into docker and it all worked fine (note: MySQL was not packaged into the container it just connected to the local IP), then I did the same with MSSQL which works fine if I run it stand alone, but trying to put it in a docker container it complains about files missing from the container and then authentication issues (user not found etc), but as I say it works fine just from running outside of a container.

Does anybody know of any issues, or a sample project that works with MSSQL etc, any help appreciated!

TIA.

Visual Studio 2022 community V17.1.4
Docker Desktop Personal v4.34.2
Docker engine v27.1.1

2

You are putting your app and MySQL in the same container?

Share your compose file(s) or commands.

3

Hi @bluepuma77
No it is running on the host with the container just housing the webapi, but that works, it was the mssql one that didn’t, I tried connecting from another machine with SSMS which worked, but the webapi states SQL Error incorrect username or password, I’ve dropped back to net 6.0 which works, I guess I’ll see what net 9 does.
I have since built the webapi with mysql in the same container with docker-compose which works, going to try mssql next fully contained.