Search
StarWind is a hyperconverged (HCI) vendor with focus on Enterprise ROBO, SMB & Edge
Find out how HCI cuts down virtualization costs and complexity

SQL Tools on a pod on AKS to manage your Azure SQL databases

  • July 27, 2021
  • 3 min read
Florent Appointaire
Cloud and Virtualization Architect. Florent is specializing in public, hybrid, and private cloud technologies. He is a Microsoft MVP in Cloud and Datacenter Management and an MCSE in Private Cloud.
Cloud and Virtualization Architect. Florent is specializing in public, hybrid, and private cloud technologies. He is a Microsoft MVP in Cloud and Datacenter Management and an MCSE in Private Cloud.


If you want to manage/test connectivity to your private SQL server, that are using private endpoint for example, and without deploying a VM, installing SQL Server Management Studio and so on, you can use AKS to do this.

To start, deploy a pod that we will customize later:

kubectl apply -f https://k8s.io/examples/application/shell-demo.yaml

Connect to the pod itself:

kubectl exec -it shell-demo -- /bin/bash

Install sqlcmd tool:

apt-get update && apt-get install gnupg2

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | tee /etc/apt/sources.list.d/msprod.list

apt-get update && apt-get install mssql-tools unixodbc-dev

ls /opt/mssql-tools/bin/sqlcmd*

ln -sfn /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd

wp-image-16954

Connect to your database server, with the following sql command, and your credentials:

kubectl exec -it shell-demo -- /bin/bash

sqlcmd -S starwind.database.windows.net -U starwind -P 'Demo2021!'

select name from sys.databases

go

wp-image-16955

This is very interesting to manage your databases, or to try a connection from a private AKS cluster to a SQL Server that is using a private endpoint connection for example.

Related articles
Kubectl with Azure CLI
Planned maintenance and auto-upgrade for AKS
Tags
Found Florent’s article helpful? Looking for a reliable, high-performance, and cost-effective shared storage solution for your production cluster?
Dmytro Malynka
Dmytro Malynka StarWind Virtual SAN Product Manager
We’ve got you covered! StarWind Virtual SAN (VSAN) is specifically designed to provide highly-available shared storage for Hyper-V, vSphere, and KVM clusters. With StarWind VSAN, simplicity is key: utilize the local disks of your hypervisor hosts and create shared HA storage for your VMs. Interested in learning more? Book a short StarWind VSAN demo now and see it in action!