Unable to connect to SQL Server from Docker container (Linux image)

Question

In our application we are using linux based container which access SQL server installed on VM. Everything works fine in local environment outside the container, But when I ran the app in local container we are getting the below 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"

appsetings.json
"ConnectionStrings": {
    
    "DbConnection": "Server=tcp:vmname\\sqlservername,49763;Database=dbname;User ID=username_Users;Password=pwd;MultipleActiveResultSets=true;Integrated Security=False;"
  }

Dockerfile

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

Any inputs will be appreciated

So the real question is how to connect to a named SQL Server instance from Linux using ADO.NET? Is the server configured to use SSL? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jul 29, 2021 at 17:21
@PanagiotisKanavos yes, it is configured to use SSL and I have configured root CA in the linux image — SijoX
– SijoX, Commented Jul 29, 2021 at 17:28

Rakesh Gupta · Accepted Answer · 2021-07-29 17:10:52Z

2

Please add ;TrustServerCertificate=true to your connection string.

answered Jul 29, 2021 at 17:10

Rakesh Gupta

3,8303 gold badges21 silver badges24 bronze badges

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

4 Comments

SijoX Over a year ago

Tried that , same issue. Thanks for helping out

John Over a year ago

@SijoX did you solve this? I am facing the same error. Thanks.

Rakesh Gupta Over a year ago

@John see SijoX's answer above. Apparently, upgrading TLS 1.2 resolved the issue.

SijoX Over a year ago

@John yes , upgrading TLS version solved the issue

SijoX · Accepted Answer · 2021-08-05 19:39:19Z

1

The issue was related to TLS version of the SQL server, enabling TLS 1.2 resolved the issue

answered Aug 5, 2021 at 19:39

SijoX

1072 silver badges11 bronze badges

Collectives™ on Stack Overflow

Unable to connect to SQL Server from Docker container (Linux image)

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related