Docker – Connect an external SQL databse to .NET microservice pods in Kubernetes

I have created .NET microservices pods in Kubernetes,and want to connect these pods to the external SQL database present on-premises. I have made all the possible changes to the connection string, added TrustServerCertficate=True and Encrypt=False, but still no luck.

I have added Hostalises, property in deployment file, with IP address and and the corresponding hostname.

Pods

Currently I am working on master-api pod,below the connection string details,

{
  "ConnectionStrings": {
     "con": "data source=DB_name; database=admin_table; user id=admin; pwd=admin; Pooling=true;Max Pool Size=500;timeout=40000; TrustServerCertificate=True; Encrypt=False"
    },
  "Logging": {
      "LogLevel": {
          "Default": "Information",
          "Microsoft.AspNetCore": "Warning"
      }
  },
  "AllowedHosts": "*"
}

Kubectl get svc
svc for this microservice is master-service

This is the deployment file with service

apiVersion: apps/v1
kind: Deployment
metadata:
  name: master-api
  labels:
    app: master-api
    type: back-end
spec:
  template:
    metadata:
      name: master-api
      labels:
        app: master-api
        type: back-end
    spec:
      containers:
        - name: masterapi
          image: repo/mpsaps-masters:v1.14
          env:
          - name: HTTP_PROXY
            value: http://proxy-details
          - name: HTTPS_PROXY
            value: http://proxy-detail
      hostAliases:
          - ip: "hostip"
            hostnames:
            - "hostname"

      
  replicas: 1
  selector:
    matchLabels:
      type: back-end

---
apiVersion: v1
kind: Service
metadata:
  name: master-service
spec:
  selector:
    app: master-api
  type: NodePort
  ports:
    - protocol: TCP
      targetPort: 80
      port: 3040
      nodePort: 31902

This is the docker-compose file which I am using.

version: '3.5'
services:
  MasterApi:
   image: repo/mpsaps-masters:v1.14
   container_name: mpsaps-master
   build:
    context: .
    dockerfile: Mpsaps.Masters/Dockerfile
   environment:
    - HTTP_PROXY=http://proxy
    - HTTPS_PROXY=http://proxy
  
   ports:
    - "443:443"
    - "1433:1433"
    - "42016:80"

When I run the curl command to fetch the data from DB, the following error occurs all the time:

curl 'http://192.168.100.1:31902/PublicService/GetServiceByDepartment?Dep_Code=%2201%22' 

{"response":{"response_code":"0","response_message":"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)","result":null}}

Please any help regarding this issue would be appreciated.