Login failed for user 'nostalgic_bohr'. .... Error Number:18456,State:1,Class:14

Question

I am trying to connect and use CRUD operations on a ms sql server with sql server authentication which is run in a docker container (created from this docker image mcr.microsoft.com/mssql/server:2019-latest).

My problem seems to be logging into the docker container of ms sql server(can be seen on github).

The C# WEB API (https://github.com/maxi376/webAPIc-) works perfectly with a local instance of the ms sql database with windows authentication.

Here I have logs of the errors(.html) in my github rep: https://github.com/maxi376/webAPIc- .

Although I can connect to the container just fine using ms sql server management studio.

It worked just fine when the server was local,not in the docker container .But even though I tried so many variations of the ConnectionString (with and without "Trust Server Certificate=true" and/or "Trusted_Connection=True") it is just impossible for me to get it to work. Kinda desperate for help here(I am even considering working with postgresql and I must containarize the backend and the database)

Answer 1

can you try in code
EXPOSE 80 under

FROM mcr.microsoft.com/dotnet/aspnet:6.0 AS base
WORKDIR /app
EXPOSE 80

ENV ConnectionStrings:MagsConnectionAzSql="Server=xxx.xxx.xxx.xxx;Database=db;Trusted_Connection=True;User ID=ENVID;Password=ENVPW;Integrated Security=false;"    
ENV ASPNETCORE_ENVIRONMENT=Development
ENV ASPNETCORE_URLS=http://+:80
ENV DB_UserId="xxxx"
ENV DB_PW="xxxx"

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build
WORKDIR /src
COPY ["WEBapi/WEBapi.csproj", "WEBapi/"]
RUN dotnet restore "WEBapi/WEBapi.csproj"
COPY . .
WORKDIR "/src/WEBapi"
RUN dotnet build "WEBapi.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "WEBapi.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "WEBapi.dll"]

maybe TLS protocol question