Unable to connect SQLServer inside docker container

Question

I'm creating a container, which has an .net core application, based on the official microsoft image.

I'm getting the following error when the application try to connect to SQL server, it only happens inside the container: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)

My application uses the following packages for communcicate with sqlserver:

System.Data.SqlClient 4.8.2
Dapper 2.0.78

My connectionstring looks like this:

Data Source=xxx.xxx.xxx.xxx;Initial Catalog=XXXXXXXX;User ID=XXXXX;Password=XXXX;MultipleActiveResultSets=True;Connect Timeout=60;TrustServerCertificate=true

My docker Version isthe latest avaliable at the time: "Docker version 20.10.2, build 2291f61" is running on windows and this is how i'm creating the docher image:

FROM mcr.microsoft.com/dotnet/sdk:3.1 AS build-env
WORKDIR /prj

COPY . .
RUN dotnet publish myapp.csproj -o /app 

FROM mcr.microsoft.com/dotnet/aspnet:3.1
WORKDIR /app

RUN update-ca-certificates --fresh

COPY --from=build-env /app .
ENTRYPOINT ["dotnet", "myapp.dll"]

I've been googling for some time now, and I didn't found a solution that works for me, can some one help?

Why are you using System.Data.SqlClient 4.8.2 in a .NET Core application? You probably mean to be using Microsoft.Data.SqlClient instead with Dapper 2.x. — AlwaysLearning
– AlwaysLearning, Commented Feb 5, 2021 at 14:45
Thanks for your feedback @AlwaysLearning, yes but after changing the package, the problem remains — Flavio CF Oliveira
– Flavio CF Oliveira, Commented Feb 8, 2021 at 10:11
With Net5 I have the same error I found this bug that seems quite related github.com/dotnet/SqlClient/issues/633 — cadaov
– cadaov, Commented Jun 4, 2021 at 20:30

Shaybakov · Accepted Answer · 2021-10-25 02:05:11Z

2

This error typically occurs in client environments like docker image containers, Unix clients, or Windows clients where TLS 1.2 is the minimum supported TLS protocol.

Configure TLS/SSL settings in the docker image/client environment to connect with TLS 1.0.

MinProtocol = TLSv1 
CipherString = DEFAULT@SECLEVEL=1

answered Oct 25, 2021 at 2:05

Shaybakov

7668 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Benyamin Limanto Over a year ago

Anyway, same question, do we need to run sed -i 's/TLSv1.2/TLSv1/g' /etc/ssl/openssl.cnf or we can use the ENV?

raddevus · Accepted Answer · 2023-08-14 11:58:51Z

1

I was seeing a very similar error:

Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)

I had to add Encrypt=false; item to the connection string. I am also using the IP Address from docker settings.

After that, it worked perfectly.

"Server=232.13.1.2;Initial Catalog=FakeDbName;User ID=sa;Password=This1sAFak3P@ass;Encrypt=False;"

answered Aug 14, 2023 at 11:58

raddevus

9,28610 gold badges78 silver badges99 bronze badges

Comments

oudi · Accepted Answer · 2024-06-20 02:23:39Z

1

run below command in Dockerfile with official dotnet image (base Debian ). it change the MinProtocol to 1.2 to support sqlserver like 2012.

RUN sed -i 's/DEFAULT@SECLEVEL=2/DEFAULT@SECLEVEL=1/g' /etc/ssl/openssl.cnf
RUN sed -i 's/MinProtocol = TLSv1.2/MinProtocol = TLSv1/g' /etc/ssl/openssl.cnf
RUN sed -i 's/DEFAULT@SECLEVEL=2/DEFAULT@SECLEVEL=1/g' /usr/lib/ssl/openssl.cnf
RUN sed -i 's/MinProtocol = TLSv1.2/MinProtocol = TLSv1/g' /usr/lib/ssl/openssl.cnf

answered Jun 20, 2024 at 2:23

oudi

6775 silver badges13 bronze badges

Collectives™ on Stack Overflow

Unable to connect SQLServer inside docker container

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related