Kubernetes: Connect to Azure SQL

user_916470 0
Viewed 8157

I have hosted my SQL on Azure SQL.
From my AKS, each of the pods, I found out it is not able to connect to Azure SQL.
DB Connection:

Data Source=tcp:dbname.database.windows.net,1433;Initial Catalog=dbname;User Id={account};Password={password}

In Azure Portal > I have enable this below enter image description here

I double checked the connection string and is able to connect from my local machine, but inside the kubenetes pod, I try to perform telnet to the server it responds

Connection closed by foreign host.

May I know what going wrong on this.

kubernetes azure
3 Answers

Azure provides two options for pods running on an AKS worker nodes to access a MySQL or PostgreSQL DB instance:

Create a firewall rule on the Azure DB Server with a range of IP addresses that encompasses all IPs of the AKS Cluster nodes (this can be a very large range if using node auto-scaling).

Create a VNet Rule on the Azure DB Server that allows access from the subnet the AKS nodes are in. This is used in conjunction with the Microsoft.Sql VNet Service Endpoint enabled on the cluster subnet.

VNet Rules are recommended and preferable in this situation for several reasons. Nodes are often configured with dynamic IP addresses that can change when a node is restarted resulting in broken firewall rules that reference specific IPs. Nodes can be added to a cluster which would require updating the firewall rule to add additional IPs. VNet Rules avoid these issues by granting access to an entire subnet of AKS nodes.

Manual steps

Configuring a secure networking environment for AKS and Azure DB requires the following:

  1. AKS cluster setup

ResourceGroup: a logical grouping a resources required for all resources.

VNet: creates a virtual network for the AKS cluster nodes.

Subnet has a range of private IPs for AKS cluster nodes Create an AKS cluster using the above resources.

  1. Configure managed service access

VNet Service Endpoint: update the cluster subnet above with a service endpoint for Microsoft.Sql to enable connectivity for new Azure DB service resource.

  1. Provision managed services with private IPs on the cluster’s network

Provision managed Azure DB service instances: PostgreSQL, MySQL. VNet Rule for each managed service instance to allow traffic from all nodes in the cluster subnet to a given Azure DB service instance (PostgreSQL, MySQL).

user_18394820

I have found the issue, basically the Issue is on the AKS getting the wrong configuration, For the Identity, It doesn't read the proper appsettings.json, which it should be point to /secrets/*.json

AddEntityFrameworkStores()

I change the code to retrieve the information from the correct secret, the apps is work now.

user_9164700

Sadhus answer is correct and secure. But first you can quickly check by enabling the traffic as follows.

  1. First select your server from your resource group.

Azure Resource Group

  1. Now in your sql server enable "Allow Azure services and resources to access this serve"

enter image description here

user_19778710
Related